What are the emails of employees with null commission, salary between 7000 and 12000, and who work in department 50?
select email from employees where commission_pct = "null" and salary between 7000 and 12000 and department_id = 50