target-benchmark/spider-queries huggingface dataset:
Database: machine_repair (tables: technician)
Question: List the names of technicians in ascending order of age.
SQL: SELECT Name FROM technician ORDER BY Age ASC
Database: machine_repair (tables: technician)
Question: What are the names of the technicians by ascending order of age?
SQL: SELECT Name FROM technician ORDER BY Age ASC
Database: machine_repair (tables: technician)
Question: What are the team and starting year of technicians?
SQL: SELECT Team ,  Starting_Year FROM technician
Database: machine_repair (tables: technician)
Question: What is the team and starting year for each technician?
SQL: SELECT Team ,  Starting_Year FROM technician
Database: machine_repair (tables: technician)
Question: List the name of technicians whose team is not "NYY".
SQL: SELECT Name FROM technician WHERE Team != "NYY"
Database: machine_repair (tables: technician)
Question: What is the name of the technician whose team is not 'NYY'?
SQL: SELECT Name FROM technician WHERE Team != "NYY"
Database: machine_repair (tables: technician)
Question: Show the name of technicians aged either 36 or 37
SQL: SELECT Name FROM technician WHERE Age  =  36 OR Age  =  37
Database: machine_repair (tables: technician)
Question: What are the names of the technicians aged either 36 or 37?
SQL: SELECT Name FROM technician WHERE Age  =  36 OR Age  =  37
Database: machine_repair (tables: technician)
Question: What is the starting year of the oldest technicians?
SQL: SELECT Starting_Year FROM technician ORDER BY Age DESC LIMIT 1
Database: machine_repair (tables: technician)
Question: What is the starting year for the oldest technician?
SQL: SELECT Starting_Year FROM technician ORDER BY Age DESC LIMIT 1
Database: machine_repair (tables: technician)
Question: Show different teams of technicians and the number of technicians in each team.
SQL: SELECT Team ,  COUNT(*) FROM technician GROUP BY Team
Database: machine_repair (tables: technician)
Question: For each team, how many technicians are there?
SQL: SELECT Team ,  COUNT(*) FROM technician GROUP BY Team
Database: machine_repair (tables: technician)
Question: Please show the team that has the most number of technicians.
SQL: SELECT Team FROM technician GROUP BY Team ORDER BY COUNT(*) DESC LIMIT 1
Database: machine_repair (tables: technician)
Question: What are the teams with the most technicians?
SQL: SELECT Team FROM technician GROUP BY Team ORDER BY COUNT(*) DESC LIMIT 1
Database: machine_repair (tables: technician)
Question: Show the team that have at least two technicians.
SQL: SELECT Team FROM technician GROUP BY Team HAVING COUNT(*)  >=  2
Database: machine_repair (tables: technician)
Question: What is the team with at least 2 technicians?
SQL: SELECT Team FROM technician GROUP BY Team HAVING COUNT(*)  >=  2
Database: machine_repair (tables: technician, machine, repair_assignment)
Question: Show names of technicians and series of machines they are assigned to repair.
SQL: SELECT T3.Name ,  T2.Machine_series FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID
Database: machine_repair (tables: technician, machine, repair_assignment)
Question: What are the names of technicians and the machine series that they repair?
SQL: SELECT T3.Name ,  T2.Machine_series FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID
Database: machine_repair (tables: technician, machine, repair_assignment)
Question: Show names of technicians in ascending order of quality rank of the machine they are assigned.
SQL: SELECT T3.Name FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID ORDER BY T2.quality_rank
Database: machine_repair (tables: technician, machine, repair_assignment)
Question: What are the names of the technicians by ascending order of quality rank for the machine they are assigned?
SQL: SELECT T3.Name FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID ORDER BY T2.quality_rank
Database: machine_repair (tables: technician, machine, repair_assignment)
Question: Show names of technicians who are assigned to repair machines with value point more than 70.
SQL: SELECT T3.Name FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID WHERE T2.value_points  >  70
Database: machine_repair (tables: technician, machine, repair_assignment)
Question: What are the names of the technicians that are assigned to repair machines with more point values than 70?
SQL: SELECT T3.Name FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID WHERE T2.value_points  >  70
Database: machine_repair (tables: technician, repair_assignment)
Question: Show names of technicians and the number of machines they are assigned to repair.
SQL: SELECT T2.Name ,  COUNT(*) FROM repair_assignment AS T1 JOIN technician AS T2 ON T1.technician_ID  =  T2.technician_ID GROUP BY T2.Name
Database: machine_repair (tables: technician, repair_assignment)
Question: What are the names of the technicians  and how many machines are they assigned to repair?
SQL: SELECT T2.Name ,  COUNT(*) FROM repair_assignment AS T1 JOIN technician AS T2 ON T1.technician_ID  =  T2.technician_ID GROUP BY T2.Name
Database: machine_repair (tables: technician, repair_assignment)
Question: List the names of technicians who have not been assigned to repair machines.
SQL: SELECT Name FROM technician WHERE technician_id NOT IN (SELECT technician_id FROM repair_assignment)
Database: machine_repair (tables: technician, repair_assignment)
Question: What are the names of the technicians that have not been assigned to repair machines?
SQL: SELECT Name FROM technician WHERE technician_id NOT IN (SELECT technician_id FROM repair_assignment)
Database: machine_repair (tables: technician)
Question: Show the starting years shared by technicians from team "CLE" and "CWS".
SQL: SELECT Starting_Year FROM technician WHERE Team  =  "CLE" INTERSECT SELECT Starting_Year FROM technician WHERE Team  =  "CWS"
Database: machine_repair (tables: technician)
Question: What are the starting years shared by the technicians from the team "CLE" or "CWS"?
SQL: SELECT Starting_Year FROM technician WHERE Team  =  "CLE" INTERSECT SELECT Starting_Year FROM technician WHERE Team  =  "CWS"
Database: entrepreneur (tables: entrepreneur)
Question: How many entrepreneurs are there?
SQL: SELECT count(*) FROM entrepreneur
Database: entrepreneur (tables: entrepreneur)
Question: Count the number of entrepreneurs.
SQL: SELECT count(*) FROM entrepreneur
Database: entrepreneur (tables: entrepreneur)
Question: List the companies of entrepreneurs in descending order of money requested.
SQL: SELECT Company FROM entrepreneur ORDER BY Money_Requested DESC
Database: entrepreneur (tables: entrepreneur)
Question: What are the companies of entrepreneurs, ordered descending by amount of money requested?
SQL: SELECT Company FROM entrepreneur ORDER BY Money_Requested DESC
Database: entrepreneur (tables: entrepreneur)
Question: List the companies and the investors of entrepreneurs.
SQL: SELECT Company ,  Investor FROM entrepreneur
Database: entrepreneur (tables: entrepreneur)
Question: What are the companies and investors that correspond to each entrepreneur?
SQL: SELECT Company ,  Investor FROM entrepreneur
Database: entrepreneur (tables: entrepreneur)
Question: What is the average money requested by all entrepreneurs?
SQL: SELECT avg(Money_Requested) FROM entrepreneur
Database: entrepreneur (tables: entrepreneur)
Question: Return the average money requested across all entrepreneurs.
SQL: SELECT avg(Money_Requested) FROM entrepreneur
Database: entrepreneur (tables: people)
Question: What are the names of people in ascending order of weight?
SQL: SELECT Name FROM People ORDER BY Weight ASC
Database: entrepreneur (tables: people)
Question: Return the names of people, ordered by weight ascending.
SQL: SELECT Name FROM People ORDER BY Weight ASC
Database: entrepreneur (tables: people, entrepreneur)
Question: What are the names of entrepreneurs?
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID
Database: entrepreneur (tables: people, entrepreneur)
Question: Return the names of entrepreneurs.
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID
Database: entrepreneur (tables: people, entrepreneur)
Question: What are the names of entrepreneurs whose investor is not "Rachel Elnaugh"?
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor != "Rachel Elnaugh"
Database: entrepreneur (tables: people, entrepreneur)
Question: Return the names of entrepreneurs do no not have the investor Rachel Elnaugh.
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor != "Rachel Elnaugh"
Database: entrepreneur (tables: people)
Question: What is the weight of the shortest person?
SQL: SELECT Weight FROM people ORDER BY Height ASC LIMIT 1
Database: entrepreneur (tables: people)
Question: Return the weight of the shortest person.
SQL: SELECT Weight FROM people ORDER BY Height ASC LIMIT 1
Database: entrepreneur (tables: people, entrepreneur)
Question: What is the name of the entrepreneur with the greatest weight?
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Weight DESC LIMIT 1
Database: entrepreneur (tables: people, entrepreneur)
Question: Return the name of the heaviest entrepreneur.
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Weight DESC LIMIT 1
Database: entrepreneur (tables: people, entrepreneur)
Question: What is the total money requested by entrepreneurs with height more than 1.85?
SQL: SELECT sum(T1.Money_Requested) FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Height  >  1.85
Database: entrepreneur (tables: people, entrepreneur)
Question: Give the total money requested by entrepreneurs who are taller than 1.85.
SQL: SELECT sum(T1.Money_Requested) FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Height  >  1.85
Database: entrepreneur (tables: people, entrepreneur)
Question: What are the dates of birth of entrepreneurs with investor "Simon Woodroffe" or "Peter Jones"?
SQL: SELECT T2.Date_of_Birth FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor  =  "Simon Woodroffe" OR T1.Investor  =  "Peter Jones"
Database: entrepreneur (tables: people, entrepreneur)
Question: Return the dates of birth for entrepreneurs who have either the investor Simon Woodroffe or Peter Jones.
SQL: SELECT T2.Date_of_Birth FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor  =  "Simon Woodroffe" OR T1.Investor  =  "Peter Jones"
Database: entrepreneur (tables: people, entrepreneur)
Question: What are the weights of entrepreneurs in descending order of money requested?
SQL: SELECT T2.Weight FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested DESC
Database: entrepreneur (tables: people, entrepreneur)
Question: Return the weights of entrepreneurs, ordered descending by amount of money requested.
SQL: SELECT T2.Weight FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested DESC
Database: entrepreneur (tables: entrepreneur)
Question: What are the investors of entrepreneurs and the corresponding number of entrepreneurs invested by each investor?
SQL: SELECT Investor ,  COUNT(*) FROM entrepreneur GROUP BY Investor
Database: entrepreneur (tables: entrepreneur)
Question: How many entrepreneurs correspond to each investor?
SQL: SELECT Investor ,  COUNT(*) FROM entrepreneur GROUP BY Investor
Database: entrepreneur (tables: entrepreneur)
Question: What is the investor that has invested in the most number of entrepreneurs?
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor ORDER BY COUNT(*) DESC LIMIT 1
Database: entrepreneur (tables: entrepreneur)
Question: Return the investor who have invested in the greatest number of entrepreneurs.
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor ORDER BY COUNT(*) DESC LIMIT 1
Database: entrepreneur (tables: entrepreneur)
Question: What are the investors that have invested in at least two entrepreneurs?
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor HAVING COUNT(*)  >=  2
Database: entrepreneur (tables: entrepreneur)
Question: Return the investors who have invested in two or more entrepreneurs.
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor HAVING COUNT(*)  >=  2
Database: entrepreneur (tables: people, entrepreneur)
Question: List the names of entrepreneurs and their companies in descending order of money requested?
SQL: SELECT T2.Name ,  T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested
Database: entrepreneur (tables: people, entrepreneur)
Question: What are the names of entrepreneurs and their corresponding investors, ordered descending by the amount of money requested?
SQL: SELECT T2.Name ,  T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested
Database: entrepreneur (tables: people, entrepreneur)
Question: List the names of people that are not entrepreneurs.
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM entrepreneur)
Database: entrepreneur (tables: people, entrepreneur)
Question: What are the names of people who are not entrepreneurs?
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM entrepreneur)
Database: entrepreneur (tables: entrepreneur)
Question: Show the investors shared by entrepreneurs that requested more than 140000 and entrepreneurs that requested less than 120000.
SQL: SELECT Investor FROM entrepreneur WHERE Money_Requested  >  140000 INTERSECT SELECT Investor FROM entrepreneur WHERE Money_Requested  <  120000
Database: entrepreneur (tables: entrepreneur)
Question: What are the investors who have invested in both entrepreneurs who requested more than 140000 and entrepreneurs who requested less than 120000?
SQL: SELECT Investor FROM entrepreneur WHERE Money_Requested  >  140000 INTERSECT SELECT Investor FROM entrepreneur WHERE Money_Requested  <  120000
Database: entrepreneur (tables: entrepreneur)
Question: How many distinct companies are there?
SQL: SELECT count(DISTINCT Company) FROM entrepreneur
Database: entrepreneur (tables: entrepreneur)
Question: Count the number of different companies.
SQL: SELECT count(DISTINCT Company) FROM entrepreneur
Database: entrepreneur (tables: people, entrepreneur)
Question: Show the company of the tallest entrepreneur.
SQL: SELECT T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Height DESC LIMIT 1
Database: entrepreneur (tables: people, entrepreneur)
Question: Which company was started by the entrepreneur with the greatest height?
SQL: SELECT T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Height DESC LIMIT 1
Database: perpetrator (tables: perpetrator)
Question: How many perpetrators are there?
SQL: SELECT count(*) FROM perpetrator
Database: perpetrator (tables: perpetrator)
Question: List the date of perpetrators in descending order of the number of people killed.
SQL: SELECT Date FROM perpetrator ORDER BY Killed DESC
Database: perpetrator (tables: perpetrator)
Question: List the number of people injured by perpetrators in ascending order.
SQL: SELECT Injured FROM perpetrator ORDER BY Injured ASC
Database: perpetrator (tables: perpetrator)
Question: What is the average number of people injured by all perpetrators?
SQL: SELECT avg(Injured) FROM perpetrator
Database: perpetrator (tables: perpetrator)
Question: What is the location of the perpetrator with the largest kills.
SQL: SELECT LOCATION FROM perpetrator ORDER BY Killed DESC LIMIT 1
Database: perpetrator (tables: people)
Question: What are the names of people in ascending order of height?
SQL: SELECT Name FROM People ORDER BY Height ASC
Database: perpetrator (tables: people, perpetrator)
Question: What are the names of perpetrators?
SQL: SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID
Database: perpetrator (tables: people, perpetrator)
Question: What are the names of perpetrators whose country is not "China"?
SQL: SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Country != "China"
Database: perpetrator (tables: people, perpetrator)
Question: What is the name of the perpetrator with the biggest weight.
SQL: SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Weight DESC LIMIT 1
Database: perpetrator (tables: people, perpetrator)
Question: What is the total kills of the perpetrators with height more than 1.84.
SQL: SELECT sum(T2.Killed) FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Height  >  1.84
Database: perpetrator (tables: people, perpetrator)
Question: What are the names of perpetrators in country "China" or "Japan"?
SQL: SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Country  =  "China" OR T2.Country  =  "Japan"
Database: perpetrator (tables: people, perpetrator)
Question: What are the heights of perpetrators in descending order of the number of people they injured?
SQL: SELECT T1.Height FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Injured DESC
Database: perpetrator (tables: perpetrator)
Question: What are the countries of perpetrators? Show each country and the corresponding number of perpetrators there.
SQL: SELECT Country ,  COUNT(*) FROM perpetrator GROUP BY Country
Database: perpetrator (tables: perpetrator)
Question: What is the country that has the most perpetrators?
SQL: SELECT Country ,  COUNT(*) FROM perpetrator GROUP BY Country ORDER BY COUNT(*) DESC LIMIT 1
Database: perpetrator (tables: perpetrator)
Question: What are the countries that have at least two perpetrators?
SQL: SELECT Country ,  COUNT(*) FROM perpetrator GROUP BY Country HAVING COUNT(*)  >=  2
Database: perpetrator (tables: people, perpetrator)
Question: List the names of perpetrators in descending order of the year.
SQL: SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Year DESC
Database: perpetrator (tables: people, perpetrator)
Question: List the names of people that are not perpetrators.
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM perpetrator)
Database: perpetrator (tables: perpetrator)
Question: Show the countries that have both perpetrators with injures more than 50 and perpetrators with injures smaller than 20.
SQL: SELECT Country FROM perpetrator WHERE Injured  >  50 INTERSECT SELECT Country FROM perpetrator WHERE Injured  <  20
Database: perpetrator (tables: perpetrator)
Question: How many distinct locations of perpetrators are there?
SQL: SELECT count(DISTINCT LOCATION) FROM perpetrator
Database: perpetrator (tables: people, perpetrator)
Question: Show the date of the tallest perpetrator.
SQL: SELECT T2.Date FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Height DESC LIMIT 1
Database: perpetrator (tables: perpetrator)
Question: In which year did the most recent crime happen?
SQL: SELECT max(YEAR) FROM perpetrator;
Database: csu_1 (tables: campuses)
Question: Report the name of all campuses in Los Angeles county.
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles"
Database: csu_1 (tables: campuses)
Question: What campuses are located in the county of Los Angeles?
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles"
Database: csu_1 (tables: campuses)
Question: What are the names of all campuses located at Chico?
SQL: SELECT campus FROM campuses WHERE LOCATION  =  "Chico"
Database: csu_1 (tables: campuses)
Question: What campuses are located in Chico?
SQL: SELECT campus FROM campuses WHERE LOCATION  =  "Chico"
Database: csu_1 (tables: campuses)
Question: Find all the campuses opened in 1958.
SQL: SELECT campus FROM campuses WHERE YEAR  =  1958
Database: csu_1 (tables: campuses)
Question: What are the campuses that opened in 1958?
SQL: SELECT campus FROM campuses WHERE YEAR  =  1958
Database: csu_1 (tables: campuses)
Question: Find the name of the campuses opened before 1800.
SQL: SELECT campus FROM campuses WHERE YEAR  <  1800
Database: csu_1 (tables: campuses)
Question: What campuses opened before 1800?
SQL: SELECT campus FROM campuses WHERE YEAR  <  1800
Database: csu_1 (tables: campuses)
Question: Which campus was opened between 1935 and 1939?
SQL: SELECT campus FROM campuses WHERE YEAR  >=  1935 AND YEAR  <=  1939
Database: csu_1 (tables: campuses)
Question: What campuses opened between 1935 and 1939?
SQL: SELECT campus FROM campuses WHERE YEAR  >=  1935 AND YEAR  <=  1939
Database: csu_1 (tables: campuses)
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"
Database: csu_1 (tables: campuses)
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"
Database: csu_1 (tables: campuses, csu_fees)
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
Database: csu_1 (tables: campuses, csu_fees)
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
Database: csu_1 (tables: campuses, csu_fees)
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
Database: csu_1 (tables: campuses, csu_fees)
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
Database: csu_1 (tables: 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)
Database: csu_1 (tables: 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)
Database: csu_1 (tables: 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)
Database: csu_1 (tables: campuses)
Question: Which university is in Los Angeles county and opened after 1950?
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles" AND YEAR  >  1950
Database: csu_1 (tables: campuses)
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