CREATE TABLE locations (location_id DECIMAL, street_address TEXT, postal_code TEXT, city TEXT, state_province TEXT, country_id TEXT)
CREATE TABLE departments (department_id DECIMAL, department_name TEXT, manager_id DECIMAL, location_id DECIMAL)
CREATE TABLE job_history (employee_id DECIMAL, start_date TIME, end_date TIME, job_id TEXT, department_id DECIMAL)
CREATE TABLE regions (region_id DECIMAL, region_name TEXT)
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 countries (country_id TEXT, country_name TEXT, region_id DECIMAL)
CREATE TABLE jobs (job_id TEXT, job_title TEXT, min_salary DECIMAL, max_salary DECIMAL)

display the emails of the employees who have no commission percentage and salary within the range 7000 to 12000 and works in that department which number is 50.
SELECT email FROM employees WHERE commission_pct = "null" AND salary BETWEEN 7000 AND 12000 AND department_id = 50
SELECT "email" FROM "employees" WHERE "commission_pct" = "null" AND "department_id" = 50 AND "salary" <= 12000 AND "salary" >= 7000