Working With Mutiple Tables COMP SCI path 9

I am very confused by this exercise.

https://www.codecademy.com/paths/data-science/tracks/sql-intermediate/modules/dspath-sql-multiple-tables/lessons/multiple-tables/exercises/with