CREATE TABLE department (dname CLOB, dnumber NUMBER, mgr_ssn NUMBER, mgr_start_date CLOB)
CREATE TABLE works_on (essn NUMBER, pno NUMBER, hours NUMBER)
CREATE TABLE project (pname CLOB, pnumber NUMBER, plocation CLOB, dnum NUMBER)
CREATE TABLE employee (fname CLOB, minit CLOB, lname CLOB, ssn NUMBER, bdate CLOB, address CLOB, sex CLOB, salary NUMBER, super_ssn NUMBER, dno NUMBER)
CREATE TABLE dependent (essn NUMBER, dependent_name CLOB, sex CLOB, bdate CLOB, relationship CLOB)
CREATE TABLE dept_locations (dnumber NUMBER, dlocation CLOB)

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"