SELECT * FROM employees WHERE salary BETWEEN 8000 AND 12000 AND commission_pct != "null" OR  department_id != 40
Return all information about employees with salaries between 8000 and 12000 for which commission is not null or where their department id is not 40.
SELECT * FROM employees WHERE salary BETWEEN 8000 AND 12000 AND commission_pct ! = `` null '' OR department_id ! = 40
select * from employees where salary between value and value and commission_pct ! = value or department_id ! = value
Return all information about employees with salaries between 8000 and 12000 for which commission is not null or where their department id is not 40 .