CREATE TABLE Campuses (
    Id NUMBER PRIMARY KEY,
    Campus TEXT,
    Location TEXT,
    County TEXT,
    Year NUMBER
);
CREATE TABLE csu_fees (
    Campus NUMBER PRIMARY KEY,
    Year NUMBER,
    CampusFee NUMBER,
    FOREIGN KEY ("Campus") REFERENCES Campuses("Id")
);
CREATE TABLE degrees (
    Year NUMBER PRIMARY KEY,
    Campus NUMBER,
    Degrees NUMBER,
    FOREIGN KEY ("Campus") REFERENCES Campuses("Id")
);
CREATE TABLE discipline_enrollments (
    Campus NUMBER PRIMARY KEY,
    Discipline NUMBER,
    Year NUMBER,
    Undergraduate NUMBER,
    Graduate NUMBER,
    FOREIGN KEY ("Campus") REFERENCES Campuses("Id")
);
CREATE TABLE enrollments (
    Campus NUMBER PRIMARY KEY,
    Year NUMBER,
    TotalEnrollment_AY NUMBER,
    FTE_AY NUMBER,
    FOREIGN KEY ("Campus") REFERENCES Campuses("Id")
);
CREATE TABLE faculty (
    Campus NUMBER,
    Year NUMBER,
    Faculty NUMBER,
    FOREIGN KEY ("Campus") REFERENCES Campuses("Id")
);

Question: Report the name of all campuses in Los Angeles county.
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles"

Question: What campuses are located in the county of Los Angeles?
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles"

Question: What are the names of all campuses located at Chico?
SQL: SELECT campus FROM campuses WHERE LOCATION  =  "Chico"

Question: What campuses are located in Chico?
SQL: SELECT campus FROM campuses WHERE LOCATION  =  "Chico"

Question: Find all the campuses opened in 1958.
SQL: SELECT campus FROM campuses WHERE YEAR  =  1958

Question: What are the campuses that opened in 1958?
SQL: SELECT campus FROM campuses WHERE YEAR  =  1958

Question: Find the name of the campuses opened before 1800.
SQL: SELECT campus FROM campuses WHERE YEAR  <  1800

Question: What campuses opened before 1800?
SQL: SELECT campus FROM campuses WHERE YEAR  <  1800

Question: Which campus was opened between 1935 and 1939?
SQL: SELECT campus FROM campuses WHERE YEAR  >=  1935 AND YEAR  <=  1939

Question: What campuses opened between 1935 and 1939?
SQL: SELECT campus FROM campuses WHERE YEAR  >=  1935 AND YEAR  <=  1939

Question: Find the name of the campuses that is in Northridge, Los Angeles or in San Francisco, San Francisco.
SQL: SELECT campus FROM campuses WHERE LOCATION  =  "Northridge" AND county  =  "Los Angeles" UNION SELECT campus FROM campuses WHERE LOCATION  =  "San Francisco" AND county  =  "San Francisco"

Question: What campuses are located in Northridge, Los Angeles or in San Francisco, San Francisco?
SQL: SELECT campus FROM campuses WHERE LOCATION  =  "Northridge" AND county  =  "Los Angeles" UNION SELECT campus FROM campuses WHERE LOCATION  =  "San Francisco" AND county  =  "San Francisco"

Question: What is the campus fee of "San Jose State University" in year 1996?
SQL: SELECT campusfee FROM campuses AS T1 JOIN csu_fees AS T2 ON T1.id  =  t2.campus WHERE t1.campus  =  "San Jose State University" AND T2.year  =  1996

Question: What is the campus fee for San Jose State University in 1996?
SQL: SELECT campusfee FROM campuses AS T1 JOIN csu_fees AS T2 ON T1.id  =  t2.campus WHERE t1.campus  =  "San Jose State University" AND T2.year  =  1996

Question: What is the campus fee of "San Francisco State University" in year 1996?
SQL: SELECT campusfee FROM campuses AS T1 JOIN csu_fees AS T2 ON T1.id  =  t2.campus WHERE t1.campus  =  "San Francisco State University" AND T2.year  =  1996

Question: What is the campus fee for San Francisco State University in 1996?
SQL: SELECT campusfee FROM campuses AS T1 JOIN csu_fees AS T2 ON T1.id  =  t2.campus WHERE t1.campus  =  "San Francisco State University" AND T2.year  =  1996

Question: Find the count of universities whose campus fee is greater than the average campus fee.
SQL: SELECT count(*) FROM csu_fees WHERE campusfee  >  (SELECT avg(campusfee) FROM csu_fees)

Question: How many universities have a campus fee higher than average?
SQL: SELECT count(*) FROM csu_fees WHERE campusfee  >  (SELECT avg(campusfee) FROM csu_fees)

Question: Find the count of universities whose campus fee is greater than the average campus fee.
SQL: SELECT count(*) FROM csu_fees WHERE campusfee  >  (SELECT avg(campusfee) FROM csu_fees)

Question: How many universities have a campus fee greater than the average?
SQL: SELECT count(*) FROM csu_fees WHERE campusfee  >  (SELECT avg(campusfee) FROM csu_fees)

Question: Which university is in Los Angeles county and opened after 1950?
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles" AND YEAR  >  1950

Question: What campuses are located in Los Angeles county and opened after 1950?
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles" AND YEAR  >  1950

Question: Which year has the most degrees conferred?
SQL: SELECT YEAR FROM degrees GROUP BY YEAR ORDER BY sum(degrees) DESC LIMIT 1

Question: In what year was the most degrees conferred?
SQL: SELECT YEAR FROM degrees GROUP BY YEAR ORDER BY sum(degrees) DESC LIMIT 1

Question: Which campus has the most degrees conferred in all times?
SQL: SELECT campus FROM degrees GROUP BY campus ORDER BY sum(degrees) DESC LIMIT 1

Question: What campus has the most degrees  conferrred over its entire existence?
SQL: SELECT campus FROM degrees GROUP BY campus ORDER BY sum(degrees) DESC LIMIT 1

Question: Which campus has the most faculties in year 2003?
SQL: SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2003 ORDER BY T2.faculty DESC LIMIT 1

Question: What campus has the most faculties in 2003?
SQL: SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2003 ORDER BY T2.faculty DESC LIMIT 1

Question: Find the average fee on a CSU campus in 1996
SQL: SELECT avg(campusfee) FROM csu_fees WHERE YEAR  =  1996

Question: What is the average fee for a CSU campus in the year of 1996?
SQL: SELECT avg(campusfee) FROM csu_fees WHERE YEAR  =  1996

Question: What is the average fee on a CSU campus in 2005?
SQL: SELECT avg(campusfee) FROM csu_fees WHERE YEAR  =  2005

Question: What is the average fee for a CSU campus in the year of 2005?
SQL: SELECT avg(campusfee) FROM csu_fees WHERE YEAR  =  2005

Question: report the total number of degrees granted between 1998 and 2002.
SQL: SELECT T1.campus ,  sum(T2.degrees) FROM campuses AS T1 JOIN degrees AS T2 ON T1.id  =  T2.campus WHERE T2.year  >=  1998 AND T2.year  <=  2002 GROUP BY T1.campus

Question: how many degrees were conferred between 1998 and 2002?
SQL: SELECT T1.campus ,  sum(T2.degrees) FROM campuses AS T1 JOIN degrees AS T2 ON T1.id  =  T2.campus WHERE T2.year  >=  1998 AND T2.year  <=  2002 GROUP BY T1.campus

Question: For each Orange county campus, report the number of degrees granted after 2000.
SQL: SELECT T1.campus ,  sum(T2.degrees) FROM campuses AS T1 JOIN degrees AS T2 ON T1.id  =  T2.campus WHERE T1.county  =  "Orange" AND T2.year  >=  2000 GROUP BY T1.campus

Question: What is the total number of degrees granted after 2000 for each Orange county campus?
SQL: SELECT T1.campus ,  sum(T2.degrees) FROM campuses AS T1 JOIN degrees AS T2 ON T1.id  =  T2.campus WHERE T1.county  =  "Orange" AND T2.year  >=  2000 GROUP BY T1.campus

Question: Find the names of the campus which has more faculties in 2002 than every campus in Orange county.
SQL: SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2002 AND faculty  >  (SELECT max(faculty) FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2002 AND T1.county  =  "Orange")

Question: What are the names of the campus that have more faculties in 2002 than the maximum number in Orange county?
SQL: SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2002 AND faculty  >  (SELECT max(faculty) FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2002 AND T1.county  =  "Orange")