Practice: Lists for the Manager

Time to put what you've learned together. The shop's manager needs a few lists, and you know everything it takes to make them: SELECT with the columns you want, FROM with the table, and a semicolon at the end of each query.

Before you write a query, find the columns in the Tables tab. Which table has the data you need, and what are its columns called? That's always the first question, and in a larger database, it's often the hardest one.

And remember that the result of a query is a table too: it has columns and rows, just like the tables of the database. That will be important later, when you'll use the result of one query in another one.