SELECT employee_id, first_name, last_name, salary FROM employees WHERE salary > 14000 ORDER BY salary DESC;
SELECT employee_id, first_name, last_name, department_id FROM employees WHERE department_id = 5 ORDER BY first_name;
SELECT employee_id, first_name, last_name FROM employees WHERE last_name = 'Chen';
SELECT employee_id, first_name, last_name, hire_date FROM employees WHERE hire_date >= '1999-01-01' ORDER BY hire_date DESC;
SELECT employee_id, first_name, last_name, hire_date FROM employees WHERE CAST(strftime('%Y',hire_date) AS INTEGER) = 2000 ORDER BY hire_date DESC;
SELECT * FROM countries;
SELECT * FROM departments;
SELECT * FROM dependents;
SELECT * FROM employees;
SELECT * FROM jobs;
SELECT * FROM locations;
SELECT * FROM regions;
