display all the information of employees whose salary is in the range of 8000 and 12000 and commission is not null or department number does not equal to 40.
SELECT * FROM employees WHERE salary BETWEEN 8000 AND 12000 AND commission_pct != "null" OR  department_id != 40
salary in the range of 8000 and 12000 refers to salary BETWEEN 8000 AND 12000; commission is not null refers to commission_pct IS NOT NULL (incorrectly represented as != \"null\" in SQL code); department number does not equal to 40 refers to department_id != 40; display all the information refers to SELECT *;