Assignment 5 (SQL #2)

I don’t understand this Computer Science question and need help to study.

Part 1)
I will give you pre-populated tables and ask you English questions (that is, in normal conversational sentences).
You will give me the SQL statements that will give the exact answers, along with the results of the queries.

Surround your answers with block comments, please.

Part 2) You give me English questions (that is, normal conversational sentences) from YOUR tables (the ones you’ve been using all along),
You will then give me the SQL statements that will give the exact answers, along with the results of the queries.