Yes. Can you tell me the number of employees?
select count ( * ) from employee
Thank you. Can you tell me how many of them are males?
select count ( * ) from employee where sex = "M"
Can you also tell me how many employees have a salary lower than 50000?
select count ( * ) from employee where salary < 50000
Ok.How many male employees have a salary lower than 50000?
select count ( * ) from employee where salary < 50000 and sex = "M"