Problem

Given two tables, "employees" and "departments", write a SQL query to find the names of all employees who work in the "Sales" department.
Example input:
employees table:
id | name | department
1 | John | Sales
2 | Jane | Marketing
3 | Joe | Sales
4 | Bill | Accounting
5 | Karen | IT
departments table:
id | name
1 | Sales
2 | Marketing
3 | Accounting
4 | IT
Example output:
John
Joe

Solution

SELECT name FROM employees WHERE department = 'Sales';

/*

The above solution is optimal because it uses the WHERE clause to filter the results of the query to only include employees who work in the Sales department.

*/