Database: csu_1

CREATE TABLE "Campuses" (
	"Id" INTEGER PRIMARY KEY, 
	"Campus" TEXT, 
	"Location" TEXT, 
	"County" TEXT, 
	"Year" INTEGER 
);
CREATE TABLE "csu_fees" ( 
	"Campus" INTEGER PRIMARY KEY, 
	"Year" INTEGER, 
	"CampusFee" INTEGER,
	FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);
CREATE TABLE "degrees" ( 
	"Year" INTEGER,
	"Campus" INTEGER, 
	"Degrees" INTEGER,
	PRIMARY KEY (Year, Campus),
	FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);
CREATE TABLE "discipline_enrollments" ( 
	"Campus" INTEGER, 
	"Discipline" INTEGER, 
	"Year" INTEGER, 
	"Undergraduate" INTEGER, 
	"Graduate" INTEGER,
	PRIMARY KEY (Campus, Discipline),
	FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);
CREATE TABLE "enrollments" ( 
	"Campus" INTEGER, 
	"Year" INTEGER, 
	"TotalEnrollment_AY" INTEGER, 
	"FTE_AY" INTEGER,
	PRIMARY KEY(Campus, Year),
	FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);
CREATE TABLE "faculty" ( 
	"Campus" INTEGER, 
	"Year" INTEGER, 
	"Faculty" REAL,
	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")

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

Question: How many CSU campuses are there?
SQL: SELECT count(*) FROM campuses

Question: What is the total number of campuses?
SQL: SELECT count(*) FROM campuses