Complete the SQL queries to fetch the right data.
Test your knowledge of SELECT, JOIN, WHERE, and GROUP BY.
