Can you also tell me how many employees have a salary lower than 50000?
SELECT count ( * )  FROM employee WHERE salary < 50000
number of employees with salary less than 50000 refers to COUNT(*) WHERE salary < 50000;