Employees Sorted by Department - Easy SQL Sorting Interview Problem

Problem

One team might export a sorted employee list at some point, whether it's for a spreadsheet, a PDF, or a quick org overview. A different team working within the same company might want that same list, but sorted alphabetically by department first, and employee name second. Using the employees table, return name, department, and salary ordered alphabetically by department, then alphabetically by name within each department.

Schema

employees

column	type
id	INTEGER
name	TEXT
department	TEXT
salary	INTEGER

Sample Data

id	name	department	salary
1	Carol	Engineering	95000
2	Alice	Engineering	120000
3	Dave	HR	65000
4	Bob	Marketing	80000
5	Eve	HR	70000

Expected Output

name	department	salary
Alice	Engineering	120000
Carol	Engineering	95000
Dave	HR	65000
Eve	HR	70000
Bob	Marketing	80000

Hints