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 report joins
products p to categories c and must return one row per category with c.category_id, c.category_name, and SUM(p.revenue). The database does not infer functional dependencies across joins and requires each selected non-aggregate expression to be explicitly grouped.Which revision most directly makes the query valid while preserving the requested category-level result and avoiding an arbitrary aggregate around the category name?
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