SELECT first_name, last_name, hire_date FROM employees WHERE CAST(strftime('%Y',hire_date) AS INTEGER) = 1997 OR CAST(strftime('%Y',hire_date) AS INTEGER) = 1998 ORDER BY first_name, last_name;
SELECT first_name, last_name, hire_date, department_id FROM employees WHERE department_id = 3 AND ( CAST(strftime('%Y',hire_date) AS INTEGER) = 1997 OR CAST(strftime('%Y',hire_date) AS INTEGER) = 1998 ) ORDER BY first_name, last_name;
SELECT first_name, last_name, hire_date, department_id FROM employees WHERE department_id = 3 AND CAST(strftime('%Y',hire_date) AS INTEGER) = 1997 OR CAST(strftime('%Y',hire_date) AS INTEGER) = 1998 ORDER BY first_name, last_name;
SELECT first_name, last_name, hire_date FROM employees WHERE CAST(strftime('%Y',hire_date) AS INTEGER) = 2000 OR CAST(strftime('%Y',hire_date) AS INTEGER) = 1999 OR CAST(strftime('%Y',hire_date) AS INTEGER) = 1990;
SELECT first_name, last_name, hire_date FROM employees WHERE CAST(strftime('%Y',hire_date) AS INTEGER) IN (1990, 1999, 2000) ORDER BY hire_date;
SELECT * FROM countries;
SELECT * FROM departments;
SELECT * FROM dependents;
SELECT * FROM employees;
SELECT * FROM jobs;
SELECT * FROM locations;
SELECT * FROM regions;
