CREATE TABLE employee (sex VARCHAR, salary INT)

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" < 50000 GROUP BY "sex"