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?