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: What campus had more than 400 total enrollment but more than 200 full time enrollment in year 1956?
SQL: SELECT T1.campus FROM campuses AS t1 JOIN enrollments AS t2 ON t1.id  =  t2.campus WHERE t2.year  =  1956 AND totalenrollment_ay  >  400 AND FTE_AY  >  200

Question: What campus started in year 1956, has more than 200 full time students, and more than 400 students enrolled?
SQL: SELECT T1.campus FROM campuses AS t1 JOIN enrollments AS t2 ON t1.id  =  t2.campus WHERE t2.year  =  1956 AND totalenrollment_ay  >  400 AND FTE_AY  >  200

Question: How many campuses are there in Los Angeles county?
SQL: SELECT count(*) FROM campuses WHERE county  =  "Los Angeles"

Question: How many campuses exist are in the county of LA?
SQL: SELECT count(*) FROM campuses WHERE county  =  "Los Angeles"

Question: List the campuses in Los Angeles county.
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles"

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

Question: How many degrees were conferred in "San Jose State University" in 2000?
SQL: SELECT degrees FROM campuses AS T1 JOIN degrees AS T2 ON t1.id  =  t2.campus WHERE t1.campus  =  "San Jose State University" AND t2.year  =  2000

Question: How many degrees were conferred at San Jose State University in 2000?
SQL: SELECT degrees FROM campuses AS T1 JOIN degrees AS T2 ON t1.id  =  t2.campus WHERE t1.campus  =  "San Jose State University" AND t2.year  =  2000

Question: What are the degrees conferred in "San Francisco State University" in 2001.
SQL: SELECT degrees FROM campuses AS T1 JOIN degrees AS T2 ON t1.id  =  t2.campus WHERE t1.campus  =  "San Francisco State University" AND t2.year  =  2001

Question: What degrees were conferred in San Francisco State University in the year 2001?
SQL: SELECT degrees FROM campuses AS T1 JOIN degrees AS T2 ON t1.id  =  t2.campus WHERE t1.campus  =  "San Francisco State University" AND t2.year  =  2001

Question: How many faculty is there in total in the year of 2002?
SQL: SELECT sum(faculty) FROM faculty WHERE YEAR  =  2002

Question: How many faculty, in total, are there in the year 2002?
SQL: SELECT sum(faculty) FROM faculty WHERE YEAR  =  2002

Question: What is the number of faculty lines in campus "Long Beach State University" in 2002?
SQL: SELECT faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus  =  T2.id WHERE T1.year  =  2002 AND T2.campus  =  "Long Beach State University"

Question: What is the number of faculty at Long Beach State University in 2002?
SQL: SELECT faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus  =  T2.id WHERE T1.year  =  2002 AND T2.campus  =  "Long Beach State University"

Question: How many faculty lines are there in "San Francisco State University" in year 2004?
SQL: SELECT faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus  =  T2.id WHERE T1.year  =  2004 AND T2.campus  =  "San Francisco State University"

Question: How many faculty lines are there at San Francisco State University in 2004?
SQL: SELECT faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus  =  T2.id WHERE T1.year  =  2004 AND T2.campus  =  "San Francisco State University"

Question: List the campus that have between 600 and 1000 faculty lines in year 2004.
SQL: SELECT T1.campus FROM campuses AS t1 JOIN faculty AS t2 ON t1.id  =  t2.campus WHERE t2.faculty  >=  600 AND t2.faculty  <=  1000 AND T1.year  =  2004

Question: What are the campuses that had between 600 and 1000 faculty members in 2004?
SQL: SELECT T1.campus FROM campuses AS t1 JOIN faculty AS t2 ON t1.id  =  t2.campus WHERE t2.faculty  >=  600 AND t2.faculty  <=  1000 AND T1.year  =  2004

Question: How many faculty lines are there in the university that conferred the most number of degrees in year 2002?
SQL: SELECT T2.faculty FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  t2.campus JOIN degrees AS T3 ON T1.id  =  t3.campus AND t2.year  =  t3.year WHERE t2.year  =  2002 ORDER BY t3.degrees DESC LIMIT 1

Question: How many faculty members did the university that conferred the most degrees in 2002 have?
SQL: SELECT T2.faculty FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  t2.campus JOIN degrees AS T3 ON T1.id  =  t3.campus AND t2.year  =  t3.year WHERE t2.year  =  2002 ORDER BY t3.degrees DESC LIMIT 1

Question: How many faculty lines are there in the university that conferred the least number of degrees in year 2001?
SQL: SELECT T2.faculty FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  t2.campus JOIN degrees AS T3 ON T1.id  =  t3.campus AND t2.year  =  t3.year WHERE t2.year  =  2001 ORDER BY t3.degrees LIMIT 1

Question: How many faculty members are at the university that gave the least number of degrees in 2001?
SQL: SELECT T2.faculty FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  t2.campus JOIN degrees AS T3 ON T1.id  =  t3.campus AND t2.year  =  t3.year WHERE t2.year  =  2001 ORDER BY t3.degrees LIMIT 1

Question: How many undergraduates are there in "San Jose State University" in year 2004?
SQL: SELECT sum(t1.undergraduate) FROM discipline_enrollments AS t1 JOIN campuses AS t2 ON t1.campus  =  t2.id WHERE t1.year  =  2004 AND t2.campus  =  "San Jose State University"

Question: How many undergraduates are there at San Jose State
SQL: SELECT sum(t1.undergraduate) FROM discipline_enrollments AS t1 JOIN campuses AS t2 ON t1.campus  =  t2.id WHERE t1.year  =  2004 AND t2.campus  =  "San Jose State University"

Question: What is the number of graduates in "San Francisco State University" in year 2004?
SQL: SELECT sum(t1.graduate) FROM discipline_enrollments AS t1 JOIN campuses AS t2 ON t1.campus  =  t2.id WHERE t1.year  =  2004 AND t2.campus  =  "San Francisco State University"

Question: How many people graduated from San Francisco State University in 2004?
SQL: SELECT sum(t1.graduate) FROM discipline_enrollments AS t1 JOIN campuses AS t2 ON t1.campus  =  t2.id WHERE t1.year  =  2004 AND t2.campus  =  "San Francisco State University"

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

Question: In the year 2000, what is the campus fee for San Francisco State University?
SQL: SELECT t1.campusfee FROM csu_fees AS t1 JOIN campuses AS t2 ON t1.campus  =  t2.id WHERE t2.campus  =  "San Francisco State University" AND t1.year  =  2000

Question: Find the campus fee of "San Jose State University" in year 2000.
SQL: SELECT t1.campusfee FROM csu_fees AS t1 JOIN campuses AS t2 ON t1.campus  =  t2.id WHERE t2.campus  =  "San Jose State University" AND t1.year  =  2000

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