Summarising data quiz

  • Admin
  • 1 min read

Nine questions on DISTINCT, aggregates, GROUP BY and HAVING.

SQL

Summarising data quiz

9 questions, instant feedback

Question 1 of 9 Which keyword removes duplicate rows from a result?
Question 2 of 9 What does COUNT(*) count?
Question 3 of 9 What does AVG ignore?
Question 4 of 9 Which clause groups rows that share a value?
Question 5 of 9 Which clause filters groups after aggregation?
Question 6 of 9 A query selects category and COUNT(*) with no GROUP BY. What happens in most engines?
Question 7 of 9 What does SUM return when every value is NULL?
Question 8 of 9 Which expression rounds an average to two decimals?
Question 9 of 9 Where does HAVING belong in a query?

Your answers stay in this browser. Nothing is sent to a server.