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

Return a bar chart on how many faculty members does each building have? List the result with the name of the building, and rank the total number from high to low order.
SELECT Building, COUNT(*) FROM Faculty GROUP BY Building ORDER BY COUNT(*) DESC
SELECT "Building", COUNT(*) FROM "Faculty" GROUP BY "Building" ORDER BY COUNT(*) DESC