Problem

Given a table with the following schema:
CREATE TABLE employees (
id INTEGER PRIMARY KEY,
name TEXT,
salary INTEGER
);
Write a SQL query that returns the id, name, and salary of all employees with a salary greater than $50,000.
Example input:
INSERT INTO employees (id, name, salary)
VALUES (1, 'John', 50000),
(2, 'Jane', 60000),
(3, 'Joe', 40000);
Example output:
id | name | salary
----+-------+--------
2 | Jane | 60000

Solution

SELECT id, name, salary
FROM employees
WHERE salary > 50000;

/*

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

*/