Chapter 6

Advanced SQL for Testers — quiz

5 questions · ~4 min

Chapter 6 quiz

Question 1 of 5

You want every order whose total is above the average order total across all orders. Which query is correct?

SELECT * FROM orders WHERE total > AVG(total)
SELECT * FROM orders WHERE total > (SELECT AVG(total) FROM orders)
SELECT AVG(total) FROM orders WHERE total > total
SELECT * FROM orders ORDER BY total DESC