SELECT * FROM employees WHERE salary BETWEEN 8000 AND 12000 AND commission_pct != "null" OR  department_id != 40
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
select * from employees where salary between value and value and commission_pct ! = value or department_id ! = value
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 .