Find the number of employees of each gender whose salary is lower than 50000.
SELECT count(*) ,  sex FROM employee WHERE salary  <  50000 GROUP BY sex
number of employees of each gender refers to COUNT(*) GROUP BY sex; salary is lower than 50000 refers to salary < 50000;