Given this table (employees):
| id | dept | salary |
|---|---|---|
| 1 | Eng | 90000 |
| 2 | Eng | 80000 |
| 3 | Sales | 60000 |
| 4 | Sales | 70000 |
What does this query return?
SELECT dept, AVG(salary) FROM employees GROUP BY dept ORDER BY dept;
← → arrow keys to navigate
Sign in to save your progress.