Problem

Given a table of users and their roles, write a SQL query to find all the users who have the role of 'admin' or 'manager'.
Example input:
| id | name  | role  |
|----|-------|-------|
| 1  | John  | admin |
| 2  | Sarah | user  |
| 3  | Mike  | manager|
Example output:
| id | name  |
|----|-------|
| 1  | John  |
| 3  | Mike  |

Solution

SELECT id, name
FROM users
WHERE role = 'admin' OR role = 'manager';

/*

The solution above is optimal because it uses the WHERE clause to filter the results.

*/