Filter with IN and ORDER BY

Easy
where Amazon Google Meta

Write a query to find all employees who work in the 'Sales', 'Marketing', or 'Engineering' departments. Return name and department, ordered by department then name.

Expected Output: Employees in the three specified departments, sorted by department and name.

Tables

Hints (2 available)

SQL Editor

Output

Click "Run" to see results...