SQL & Databases
Topic 15 · SQL in practice · ⏱ about 30 min

✅ Checkpoint: SQL & Databases

A mixed quiz on the whole SQL & Databases course. Pass mark: 7 of 10 on the first try.

Show:
In this topic
Beginner

How this checkpoint works

Answer every question below without looking back at the topics. Only your first try counts. If you reach the pass mark, you are ready for the next course. If not, the result tells you which topics to revisit; come back in a few days and try again.

Check yourself

Quiz

1. Which returns products cheaper than 50, most expensive first?

2. WHERE city != 'Sydney' on a table where some cities are NULL…

3. Which counts customers per country, keeping only countries with 3 or more?

4. customers LEFT JOIN orders: a customer with no orders appears…

5. You SUM order totals after joining orders to order_items. The sum is too large because…

6. Which gives each customer's orders numbered 1, 2, 3 by date?

7. What is the purpose of a FOREIGN KEY constraint?

8. How should user input be put into a query from Python?

9. Which is evaluated last?

10. Which is the best first step before an UPDATE?

Ready