CREATE TABLE Participates_in (stuid INT, actid INT)
CREATE TABLE Activity (actid INT, activity_name VARCHAR)
CREATE TABLE Faculty_Participates_in (FacID INT, actid INT)
CREATE TABLE Faculty (FacID INT, Lname VARCHAR, Fname VARCHAR, Rank VARCHAR, Sex VARCHAR, Phone INT, Room VARCHAR, Building VARCHAR)
CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)

Show the number of male and female assistant professors with a bar chart, rank in desc by the X-axis.
SELECT Sex, COUNT(*) FROM Faculty WHERE Rank = "AsstProf" GROUP BY Sex ORDER BY Sex DESC
SELECT "Sex", COUNT(*) FROM "Faculty" WHERE "AsstProf" = "Rank" GROUP BY "Sex" ORDER BY "Sex" DESC NULLS LAST