CREATE TABLE job_history (employee_id DECIMAL, start_date TIME, end_date TIME, job_id TEXT, department_id DECIMAL)
CREATE TABLE departments (department_id DECIMAL, department_name TEXT, manager_id DECIMAL, location_id DECIMAL)
CREATE TABLE employees (employee_id DECIMAL, first_name TEXT, last_name TEXT, email TEXT, phone_number TEXT, hire_date TIME, job_id TEXT, salary DECIMAL, commission_pct DECIMAL, manager_id DECIMAL, department_id DECIMAL)
CREATE TABLE regions (region_id DECIMAL, region_name TEXT)
CREATE TABLE jobs (job_id TEXT, job_title TEXT, min_salary DECIMAL, max_salary DECIMAL)
CREATE TABLE locations (location_id DECIMAL, street_address TEXT, postal_code TEXT, city TEXT, state_province TEXT, country_id TEXT)
CREATE TABLE countries (country_id TEXT, country_name TEXT, region_id DECIMAL)

Find job id and date of hire for those employees who was hired between November 5th, 2007 and July 5th, 2009.
SELECT job_id, hire_date FROM employees WHERE hire_date BETWEEN '2007-11-05' AND '2009-07-05'
SELECT "job_id", "hire_date" FROM "employees" WHERE "hire_date" <= '2009-07-05' AND "hire_date" >= '2007-11-05'