CREATE TABLE Lives_in (stuid INT, dormid INT, room_number INT)
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)
CREATE TABLE Dorm (dormid INT, dorm_name VARCHAR, student_capacity INT, gender VARCHAR)
CREATE TABLE Dorm_amenity (amenid INT, amenity_name VARCHAR)

Find the number of male students (with sex M) from each city in a bar chart.
SELECT city_code, COUNT(*) FROM Student WHERE Sex = 'M' GROUP BY city_code
SELECT "city_code", COUNT(*) FROM "Student" WHERE "Sex" = 'M' GROUP BY "city_code"