CREATE TABLE dept_locations (Dnumber NUMBER, Dlocation CLOB)
CREATE TABLE dependent (Essn NUMBER, Dependent_name CLOB, Sex CLOB, Bdate CLOB, Relationship CLOB)
CREATE TABLE works_on (Essn NUMBER, Pno NUMBER, Hours FLOAT)
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 project (Pname CLOB, Pnumber NUMBER, Plocation CLOB, Dnum NUMBER)
CREATE TABLE department (Dname CLOB, Dnumber NUMBER, Mgr_ssn NUMBER, Mgr_start_date CLOB)

Find the number of employees of each gender whose salary is lower than 50000 Visualize by bar chart, rank in ascending by the X-axis please.
SELECT Sex, COUNT(*) FROM employee WHERE Salary < 50000 GROUP BY Sex ORDER BY Sex
SELECT "Sex", COUNT(*) FROM "employee" WHERE "Salary" < 50000 GROUP BY "Sex" ORDER BY "Sex"