CREATE TABLE teaches (ID VARCHAR2, course_id VARCHAR2, sec_id VARCHAR2, semester VARCHAR2, year NUMBER)
CREATE TABLE classroom (building VARCHAR2, room_number VARCHAR2, capacity NUMBER)
CREATE TABLE time_slot (time_slot_id VARCHAR2, day VARCHAR2, start_hr NUMBER, start_min NUMBER, end_hr NUMBER, end_min NUMBER)
CREATE TABLE instructor (ID VARCHAR2, name VARCHAR2, dept_name VARCHAR2, salary NUMBER)
CREATE TABLE section (course_id VARCHAR2, sec_id VARCHAR2, semester VARCHAR2, year NUMBER, building VARCHAR2, room_number VARCHAR2, time_slot_id VARCHAR2)
CREATE TABLE prereq (course_id VARCHAR2, prereq_id VARCHAR2)
CREATE TABLE course (course_id VARCHAR2, title VARCHAR2, dept_name VARCHAR2, credits NUMBER)
CREATE TABLE advisor (s_ID VARCHAR2, i_ID VARCHAR2)
CREATE TABLE student (ID VARCHAR2, name VARCHAR2, dept_name VARCHAR2, tot_cred NUMBER)
CREATE TABLE takes (ID VARCHAR2, course_id VARCHAR2, sec_id VARCHAR2, semester VARCHAR2, year NUMBER, grade VARCHAR2)
CREATE TABLE department (dept_name VARCHAR2, building VARCHAR2, budget NUMBER)

Bar chart x axis building y axis the average of capacity, and show by the total number in descending please.
SELECT building, AVG(capacity) FROM classroom GROUP BY building ORDER BY AVG(capacity) DESC
SELECT "building", AVG("capacity") FROM "classroom" GROUP BY "building" ORDER BY AVG("capacity") DESC