CREATE TABLE dept_locations (Dnumber INT, Dlocation TEXT)
CREATE TABLE project (Pname TEXT, Pnumber INT, Plocation TEXT, Dnum INT)
CREATE TABLE dependent (Essn INT, Dependent_name TEXT, Sex TEXT, Bdate TEXT, Relationship TEXT)
CREATE TABLE department (Dname TEXT, Dnumber INT, Mgr_ssn INT, Mgr_start_date TEXT)
CREATE TABLE works_on (Essn INT, Pno INT, Hours FLOAT)
CREATE TABLE employee (Fname TEXT, Minit TEXT, Lname TEXT, Ssn INT, Bdate TEXT, Address TEXT, Sex TEXT, Salary INT, Super_ssn INT, Dno INT)

Find the number of employees of each gender whose salary is lower than 50000 Visualize by bar chart, could you rank in descending by the Sex?
SELECT Sex, COUNT(*) FROM employee WHERE Salary < 50000 GROUP BY Sex ORDER BY Sex DESC
SELECT "Sex", COUNT(*) FROM "employee" WHERE "Salary" < 50000 GROUP BY "Sex" ORDER BY "Sex" DESC NULLS LAST