SQL Quiz
10 questions · no time limit
0:00
AGGREGATION AND GROUPING
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
A query groups sales independently by region and by product:
SELECT region, product, SUM(amount) AS total
FROM sales
GROUP BY GROUPING SETS ((region), (product))
HAVING SUM(amount) > 100;Which statement correctly describes the effect of the
HAVING clause? YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end