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
Department
A has two employees with salaries of 30 and 50. Department B has one employee with a salary of 100.What does
SELECT AVG(dept_avg) FROM (SELECT department_id, AVG(salary) AS dept_avg FROM employee GROUP BY department_id) AS d; return? 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