Final Quiz
Prove it to yourself.
Let's finish with a final quiz. Four questions, from across the whole course. Pause before each answer. If you get them all, you can honestly say you know SQL.

- Four questions
- From the whole course
- Pause before each answer
Final question 1
Question one. You want the number of customers in each country. Which clause do you need? Pause and choose. The answer is B, group by.
Final question 2
Question two. You want every customer, including those with no orders. Which join? Pause and choose. The answer is C, left join, from customers to orders.
Final question 3
Question three. Which finds the most expensive book in each genre? Pause and choose. The answer is A. Row number, partitioned by genre, then keep number one.
Final question 4
Last one. Which is the safe way to compare with a missing value? Pause and choose. The answer is D, is null. Equals null never matches anything.
Summary
Thank you for learning SQL with me. You started by asking a database for a few rows, and now you can turn raw tables into answers a business can act on. That's a real skill, and it's yours now. Keep asking good questions.
Key takeaways- You know SQL
- Keep practising
- Ask good questions