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
display the emails of the employees who have no commission percentage
select email from employees where commission_pct = "null"
yes
select email from employees where commission_pct > 0
How many employees with salary above 12000 are there?
select count ( * ) from employees where salary >12000
yes
select first_name,last_name from employees where salary >12000