SQL Quiz
10 questions · no time limit
0:00
WINDOW FUNCTIONS
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
A report must return individual employees whose salary is greater than the average salary of their own department. The result must retain one row per qualifying employee.
Which query correctly uses a partitioned window aggregate to produce the report under standard SQL query-processing rules?
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