Chapter 2

SELECT Queries — quiz

5 questions · ~4 min

Chapter 2 quiz

Question 1 of 5

After a user places an order through the UI, you need to verify the order was saved correctly in the database. The orders table has columns: id, user_id, total, status, created_at. Which query verifies the most recent order for user 42?

SELECT * FROM orders WHERE user_id = 42
SELECT * FROM orders WHERE user_id = 42 ORDER BY created_at DESC LIMIT 1
SELECT COUNT(*) FROM orders WHERE user_id = 42
SELECT total FROM orders WHERE id = 42