target-benchmark/spider-queries huggingface dataset:
Database: csu_1 (tables: degrees)
Question: Which year has the most degrees conferred?
SQL: SELECT YEAR FROM degrees GROUP BY YEAR ORDER BY sum(degrees) DESC LIMIT 1
Database: csu_1 (tables: degrees)
Question: In what year was the most degrees conferred?
SQL: SELECT YEAR FROM degrees GROUP BY YEAR ORDER BY sum(degrees) DESC LIMIT 1
Database: csu_1 (tables: degrees)
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
Database: csu_1 (tables: degrees)
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
Database: csu_1 (tables: campuses, faculty)
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
Database: csu_1 (tables: campuses, faculty)
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
Database: csu_1 (tables: csu_fees)
Question: Find the average fee on a CSU campus in 1996
SQL: SELECT avg(campusfee) FROM csu_fees WHERE YEAR  =  1996
Database: csu_1 (tables: csu_fees)
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
Database: csu_1 (tables: csu_fees)
Question: What is the average fee on a CSU campus in 2005?
SQL: SELECT avg(campusfee) FROM csu_fees WHERE YEAR  =  2005
Database: csu_1 (tables: csu_fees)
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
Database: csu_1 (tables: campuses, degrees)
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
Database: csu_1 (tables: campuses, degrees)
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
Database: csu_1 (tables: campuses, degrees)
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
Database: csu_1 (tables: campuses, degrees)
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
Database: csu_1 (tables: campuses, faculty)
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")
Database: csu_1 (tables: campuses, faculty)
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")
Database: csu_1 (tables: campuses, enrollments)
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
Database: csu_1 (tables: campuses, enrollments)
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
Database: csu_1 (tables: campuses)
Question: How many campuses are there in Los Angeles county?
SQL: SELECT count(*) FROM campuses WHERE county  =  "Los Angeles"
Database: csu_1 (tables: campuses)
Question: How many campuses exist are in the county of LA?
SQL: SELECT count(*) FROM campuses WHERE county  =  "Los Angeles"
Database: csu_1 (tables: campuses)
Question: List the campuses in Los Angeles county.
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles"
Database: csu_1 (tables: campuses)
Question: What campuses are in Los Angeles county?
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles"
Database: csu_1 (tables: campuses, degrees)
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
Database: csu_1 (tables: campuses, degrees)
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
Database: csu_1 (tables: campuses, degrees)
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
Database: csu_1 (tables: campuses, degrees)
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
Database: csu_1 (tables: faculty)
Question: How many faculty is there in total in the year of 2002?
SQL: SELECT sum(faculty) FROM faculty WHERE YEAR  =  2002
Database: csu_1 (tables: faculty)
Question: How many faculty, in total, are there in the year 2002?
SQL: SELECT sum(faculty) FROM faculty WHERE YEAR  =  2002
Database: csu_1 (tables: campuses, faculty)
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"
Database: csu_1 (tables: campuses, faculty)
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"
Database: csu_1 (tables: campuses, faculty)
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"
Database: csu_1 (tables: campuses, faculty)
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"
Database: csu_1 (tables: campuses, faculty)
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
Database: csu_1 (tables: campuses, faculty)
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
Database: csu_1 (tables: campuses, faculty, degrees)
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
Database: csu_1 (tables: campuses, faculty, degrees)
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
Database: csu_1 (tables: campuses, faculty, degrees)
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
Database: csu_1 (tables: campuses, faculty, degrees)
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
Database: csu_1 (tables: discipline_enrollments, campuses)
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"
Database: csu_1 (tables: discipline_enrollments, campuses)
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"
Database: csu_1 (tables: discipline_enrollments, campuses)
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"
Database: csu_1 (tables: discipline_enrollments, campuses)
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"
Database: csu_1 (tables: campuses, csu_fees)
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
Database: csu_1 (tables: campuses, csu_fees)
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
Database: csu_1 (tables: campuses, csu_fees)
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
Database: csu_1 (tables: campuses, csu_fees)
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
Database: csu_1 (tables: campuses)
Question: How many CSU campuses are there?
SQL: SELECT count(*) FROM campuses
Database: csu_1 (tables: campuses)
Question: What is the total number of campuses?
SQL: SELECT count(*) FROM campuses
Database: candidate_poll (tables: candidate)
Question: How many candidates are there?
SQL: SELECT count(*) FROM candidate
Database: candidate_poll (tables: candidate)
Question: Count the number of candidates.
SQL: SELECT count(*) FROM candidate
Database: candidate_poll (tables: candidate)
Question: Which poll resource provided the most number of candidate information?
SQL: SELECT poll_source FROM candidate GROUP BY poll_source ORDER BY count(*) DESC LIMIT 1
Database: candidate_poll (tables: candidate)
Question: Return the poll resource associated with the most candidates.
SQL: SELECT poll_source FROM candidate GROUP BY poll_source ORDER BY count(*) DESC LIMIT 1
Database: candidate_poll (tables: candidate)
Question: what are the top 3 highest support rates?
SQL: SELECT support_rate FROM candidate ORDER BY support_rate DESC LIMIT 3
Database: candidate_poll (tables: candidate)
Question: Return the top 3 greatest support rates.
SQL: SELECT support_rate FROM candidate ORDER BY support_rate DESC LIMIT 3
Database: candidate_poll (tables: candidate)
Question: Find the id of the candidate who got the lowest oppose rate.
SQL: SELECT Candidate_ID FROM candidate ORDER BY oppose_rate LIMIT 1
Database: candidate_poll (tables: candidate)
Question: What is the id of the candidate with the lowest oppose rate?
SQL: SELECT Candidate_ID FROM candidate ORDER BY oppose_rate LIMIT 1
Database: candidate_poll (tables: candidate)
Question: Please list support, consider, and oppose rates for each candidate in ascending order by unsure rate.
SQL: SELECT Support_rate ,  Consider_rate ,  Oppose_rate FROM candidate ORDER BY unsure_rate
Database: candidate_poll (tables: candidate)
Question: What are the support, consider, and oppose rates of each candidate, ordered ascending by their unsure rate?
SQL: SELECT Support_rate ,  Consider_rate ,  Oppose_rate FROM candidate ORDER BY unsure_rate
Database: candidate_poll (tables: candidate)
Question: which poll source does the highest oppose rate come from?
SQL: SELECT poll_source FROM candidate ORDER BY oppose_rate DESC LIMIT 1
Database: candidate_poll (tables: candidate)
Question: Return the poll source corresponding to the candidate who has the oppose rate.
SQL: SELECT poll_source FROM candidate ORDER BY oppose_rate DESC LIMIT 1
Database: candidate_poll (tables: people)
Question: List all people names in the order of their date of birth from old to young.
SQL: SELECT name FROM people ORDER BY date_of_birth
Database: candidate_poll (tables: people)
Question: What are the names of all people, ordered by their date of birth?
SQL: SELECT name FROM people ORDER BY date_of_birth
Database: candidate_poll (tables: people)
Question: Find the average height and weight for all males (sex is M).
SQL: SELECT avg(height) ,  avg(weight) FROM people WHERE sex  =  'M'
Database: candidate_poll (tables: people)
Question: What are the average height and weight across males (sex is M)?
SQL: SELECT avg(height) ,  avg(weight) FROM people WHERE sex  =  'M'
Database: candidate_poll (tables: people)
Question: find the names of people who are taller than 200 or lower than 190.
SQL: SELECT name FROM people WHERE height  >  200 OR height  <  190
Database: candidate_poll (tables: people)
Question: What are the names of people who have a height greater than 200 or less than 190?
SQL: SELECT name FROM people WHERE height  >  200 OR height  <  190
Database: candidate_poll (tables: people)
Question: Find the average and minimum weight for each gender.
SQL: SELECT avg(weight) ,  min(weight) ,  sex FROM people GROUP BY sex
Database: candidate_poll (tables: people)
Question: What are the average and minimum weights for people of each sex?
SQL: SELECT avg(weight) ,  min(weight) ,  sex FROM people GROUP BY sex
Database: candidate_poll (tables: candidate, people)
Question: Find the name and gender of the candidate who got the highest support rate.
SQL: SELECT t1.name ,  t1.sex FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id ORDER BY t2.support_rate DESC LIMIT 1
Database: candidate_poll (tables: candidate, people)
Question: What is the name and sex of the candidate with the highest support rate?
SQL: SELECT t1.name ,  t1.sex FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id ORDER BY t2.support_rate DESC LIMIT 1
Database: candidate_poll (tables: candidate, people)
Question: Find the name of the candidates whose oppose percentage is the lowest for each sex.
SQL: SELECT t1.name ,  t1.sex ,  min(oppose_rate) FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id GROUP BY t1.sex
Database: candidate_poll (tables: candidate, people)
Question: For each sex, what is the name and sex of the candidate with the oppose rate for their sex?
SQL: SELECT t1.name ,  t1.sex ,  min(oppose_rate) FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id GROUP BY t1.sex
Database: candidate_poll (tables: candidate, people)
Question: which gender got the highest average uncertain ratio.
SQL: SELECT t1.sex FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id GROUP BY t1.sex ORDER BY avg(t2.unsure_rate) DESC LIMIT 1
Database: candidate_poll (tables: candidate, people)
Question: What is the sex of the candidate who had the highest unsure rate?
SQL: SELECT t1.sex FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id GROUP BY t1.sex ORDER BY avg(t2.unsure_rate) DESC LIMIT 1
Database: candidate_poll (tables: candidate, people)
Question: what are the names of people who did not participate in the candidate election.
SQL: SELECT name FROM people WHERE people_id NOT IN (SELECT people_id FROM candidate)
Database: candidate_poll (tables: candidate, people)
Question: Give the names of people who did not participate in the candidate election.
SQL: SELECT name FROM people WHERE people_id NOT IN (SELECT people_id FROM candidate)
Database: candidate_poll (tables: candidate, people)
Question: Find the names of the candidates whose support percentage is lower than their oppose rate.
SQL: SELECT t1.name FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id WHERE t2.support_rate  <  t2.oppose_rate
Database: candidate_poll (tables: candidate, people)
Question: What are the names of candidates who have a lower support rate than oppose rate?
SQL: SELECT t1.name FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id WHERE t2.support_rate  <  t2.oppose_rate
Database: candidate_poll (tables: people)
Question: how many people are there whose weight is higher than 85 for each gender?
SQL: SELECT count(*) ,  sex FROM people WHERE weight  >  85 GROUP BY sex
Database: candidate_poll (tables: people)
Question: Count the number of people of each sex who have a weight higher than 85.
SQL: SELECT count(*) ,  sex FROM people WHERE weight  >  85 GROUP BY sex
Database: candidate_poll (tables: candidate)
Question: find the highest support percentage, lowest consider rate and oppose rate of all candidates.
SQL: SELECT max(support_rate) ,  min(consider_rate) ,  min(oppose_rate) FROM candidate
Database: candidate_poll (tables: candidate)
Question: Return the maximum support rate, minimum consider rate, and minimum oppose rate across all candidates?
SQL: SELECT max(support_rate) ,  min(consider_rate) ,  min(oppose_rate) FROM candidate
Database: candidate_poll (tables: candidate, people)
Question: list all female (sex is F) candidate names in the alphabetical order.
SQL: SELECT t1.name FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id WHERE t1.sex  =  'F' ORDER BY t1.name
Database: candidate_poll (tables: candidate, people)
Question: What are the names of all female candidates in alphabetical order (sex is F)?
SQL: SELECT t1.name FROM people AS t1 JOIN candidate AS t2 ON t1.people_id  =  t2.people_id WHERE t1.sex  =  'F' ORDER BY t1.name
Database: candidate_poll (tables: people)
Question: find the name of people whose height is lower than the average.
SQL: SELECT name FROM people WHERE height  <  (SELECT avg(height) FROM people)
Database: candidate_poll (tables: people)
Question: What are the names of people who are shorter than average?
SQL: SELECT name FROM people WHERE height  <  (SELECT avg(height) FROM people)
Database: candidate_poll (tables: people)
Question: List all info about all people.
SQL: SELECT * FROM people
Database: candidate_poll (tables: people)
Question: What is all the information about all people?
SQL: SELECT * FROM people
Database: movie_1 (tables: movie)
Question: Find the titles of all movies directed by steven spielberg.
SQL: SELECT title FROM Movie WHERE director = 'Steven Spielberg'
Database: movie_1 (tables: movie)
Question: What are the names of all movies directed by Steven Spielberg?
SQL: SELECT title FROM Movie WHERE director = 'Steven Spielberg'
Database: movie_1 (tables: movie)
Question: What is the name of the movie produced after 2000 and directed by James Cameron?
SQL: SELECT title FROM Movie WHERE director = 'James Cameron' AND YEAR  >  2000
Database: movie_1 (tables: movie)
Question: What are the titles of all movies that James Cameron directed after 2000?
SQL: SELECT title FROM Movie WHERE director = 'James Cameron' AND YEAR  >  2000
Database: movie_1 (tables: movie)
Question: How many movies were made before 2000?
SQL: SELECT count(*) FROM Movie WHERE YEAR  <  2000
Database: movie_1 (tables: movie)
Question: Who is the director of movie Avatar?
SQL: SELECT director FROM Movie WHERE title  = 'Avatar'
Database: movie_1 (tables: movie)
Question: Who directed Avatar?
SQL: SELECT director FROM Movie WHERE title  = 'Avatar'
Database: movie_1 (tables: reviewer)
Question: How many reviewers listed?
SQL: SELECT count(*) FROM Reviewer
Database: movie_1 (tables: reviewer)
Question: How many reviewers are there?
SQL: SELECT count(*) FROM Reviewer
Database: movie_1 (tables: reviewer)
Question: What is the id of the reviewer whose name has substring “Mike”?
SQL: SELECT rID FROM Reviewer WHERE name LIKE "%Mike%"
Database: movie_1 (tables: reviewer)
Question: What is the id of the reviewer whose name includes the word "Mike"?
SQL: SELECT rID FROM Reviewer WHERE name LIKE "%Mike%"
Database: movie_1 (tables: reviewer)
Question: What is the reviewer id of Daniel Lewis?
SQL: SELECT rID FROM Reviewer WHERE name  =  "Daniel Lewis"
Database: movie_1 (tables: reviewer)
Question: What is the id of the reviewer named Daniel Lewis?
SQL: SELECT rID FROM Reviewer WHERE name  =  "Daniel Lewis"
Database: movie_1 (tables: rating)
Question: What is the total number of ratings that has more than 3 stars?
SQL: SELECT count(*) FROM Rating WHERE stars  >  3
Database: movie_1 (tables: rating)
Question: How many movie ratings have more than 3 stars?
SQL: SELECT count(*) FROM Rating WHERE stars  >  3
Database: movie_1 (tables: rating)
Question: What is the lowest and highest rating star?
SQL: SELECT max(stars) ,  min(stars) FROM Rating
Database: movie_1 (tables: rating)
Question: What is the maximum and mininum number of stars a rating can receive?
SQL: SELECT max(stars) ,  min(stars) FROM Rating
Database: movie_1 (tables: movie, rating)
Question: Find all years that have a movie that received a rating of 4 or 5, and sort them in increasing order of year.
SQL: SELECT DISTINCT YEAR FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID  =  T2.mID WHERE T2.stars  >=  4 ORDER BY T1.year
Database: movie_1 (tables: movie, rating)
Question: In what years did a movie receive a 4 or 5 star rating, and list the years from oldest to most recently?
SQL: SELECT DISTINCT YEAR FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID  =  T2.mID WHERE T2.stars  >=  4 ORDER BY T1.year
Database: movie_1 (tables: movie, rating)
Question: What are the names of directors who directed movies with 5 star rating? Also return the title of these movies.
SQL: SELECT T1.director ,  T1.title FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID  =  T2.mID WHERE T2.stars  =  5