Intermediate SQL
3 exercises · in teaching order
- 1Who works whereReturn each employee's **name** and their **department name**, with the columns labelled `name` and `department`.INNER JOINtable aliases9m
- 2Headcount per departmentReturn each **department name** and how many employees it has, as columns `department` and `headcount`.GROUP BYCOUNTJOIN9m
- 3Well-paid departmentsReturn each **department name** and its **average salary** (columns `department`, `avg_salary`) - but only departments whose average is above 60,000.AVGHAVINGGROUP BY10m