SELECT count(*) ,  sex FROM employee WHERE salary  <  50000 GROUP BY sex
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
select count ( * ) , sex from employee where salary < value group by sex
Find the number of employees of each gender whose salary is lower than 50000 .