CREATE TABLE Dorm (dormid INT, dorm_name VARCHAR, student_capacity INT, gender VARCHAR)
CREATE TABLE Lives_in (stuid INT, dormid INT, room_number INT)
CREATE TABLE Dorm_amenity (amenid INT, amenity_name VARCHAR)
CREATE TABLE Has_amenity (dormid INT, amenid INT)
CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)

How many dorms are there for each gender? Show me a bar chart, and display in descending by the x axis.
SELECT gender, COUNT(*) FROM Dorm GROUP BY gender ORDER BY gender DESC
SELECT "gender", COUNT(*) FROM "Dorm" GROUP BY "gender" ORDER BY "gender" DESC NULLS LAST