AI Hints
Home›SQL Tutorial›Recap and Roadmap
SQL · Lesson 126 of 126

Final Quiz

Prove it to yourself.

⏱ 2 min read▶ Video at 3:00:10🎓 Free
Watch this lesson in the SQL courseWatch on YouTube ↗Full SQL course

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.

Final Quiz
From the video: Final Quiz
  • 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.

Quick check
Customers in each country

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.

Quick check
Every customer, even with no 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.

Quick check
Most expensive book in each genre

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.

Quick check
Find customers with no city

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
Next up: Data Science — your next course