Google Interview Question

They gave an example SQL schema and asked how you would write a SQL statement to query the schema requiring a join and foreign key