Database: movie_3
Question: What is the rental price per day for Airplane Sierra?
Evidence: rental price per day refers to DIVIDE(rental_price, rental_duration); 'Airplane Sierra' is a title of a film
SQL: SELECT rental_rate / rental_duration AS result FROM film WHERE title = 'AIRPLANE SIERRA'

Database: retails
Question: Clerk#000000936 dealt with a "Not Specified" order on 1995/3/13, what was the charge for the part of the order shipped by truck?
Evidence: MULTIPLY(MULTIPLY(l_extendedprice, SUBTRACT(1, l_discount)), SUM(1, l_tax)) WHERE o_clerk = 'Clerk#000000936', o_orderstatus = '4-NOT SPECIFIED', o_orderdate = '1995-03-13' AND l_shipmode = 'TRUCK';
SQL: SELECT T2.l_extendedprice * (1 - T2.l_discount) * (1 + T2.l_tax) AS num FROM orders AS T1 INNER JOIN lineitem AS T2 ON T1.o_orderkey = T2.l_orderkey WHERE T1.o_clerk = 'Clerk#000000936' AND T2.l_shipmode = 'TRUCK' AND T1.o_orderstatus = '4-NOT SPECIFIED' AND T1.o_orderdate = '1995-03-13'

Database: synthea
Question: Give the social security number of the female Irish patient allergic to grass pollen.
Evidence: social security number refers to ssn; female refers to gender = 'F'; Irish refers to ethnicity = 'irish'; allergic to grass pollen refers to allergies where DESCRIPTION = 'Allergy to grass pollen';
SQL: SELECT T2.ssn FROM allergies AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T1.DESCRIPTION = 'Allergy to grass pollen' AND T2.ethnicity = 'irish' AND T2.gender = 'F'

Database: world_development_indicators
Question: Mention the series code of countries using Hong Kong dollar as their currency unit.
SQL: SELECT T2.SeriesCode FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T1.CurrencyUnit = 'Hong Kong dollar'

Database: beer_factory
Question: What are the full names of the first top 10 customers?
Evidence: full name = First Last; first top 10 customers refers to MIN(FirstPurchaseDate) LIMIT 10;
SQL: SELECT First, Last FROM customers ORDER BY FirstPurchaseDate LIMIT 10

Database: chicago_crime
Question: Which alderman represents the ward with the most number of crimes in January, 2018? Please give his or her full name.
Evidence: in January 2018 refers to Substr(date, 1, 1) = '1' AND Substr(date, 5, 4) = '2018'; ward with the most number of crime refers to Max (Count(ward_no)); full name refers to alderman_first_name, alderman_last_name, alderman_name_suffix
SQL: SELECT T1.ward_no, T1.alderman_first_name, T1.alderman_last_name, T1.alderman_name_suffix FROM Ward AS T1 INNER JOIN Crime AS T2 ON T1.ward_no = T2.ward_no WHERE SUBSTR(T2.date, 1, 1) = '1' AND SUBSTR(T2.date, 5, 4) = '2018' GROUP BY T1.ward_no ORDER BY COUNT(T1.ward_no) DESC LIMIT 1

Database: donor
Question: Is teacher "42d43fa6f37314365d08692e08680973" a New York teacher?
Evidence: teacher "42d43fa6f37314365d08692e08680973"refers to teacher_acctid = '42d43fa6f37314365d08692e08680973';
SQL: SELECT teacher_ny_teaching_fellow end FROM projects WHERE teacher_acctid = '42d43fa6f37314365d08692e08680973'

Database: olympics
Question: Which game has Jessica Carolina Aguilera Aguilera participated in? Give the id of the game.
Evidence: id of the game refers to games_id;
SQL: SELECT T2.games_id FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id WHERE T1.full_name = 'Jessica Carolina Aguilera Aguilera'

Database: sales_in_weather
Question: Give the id of the weather station with most stores.
Evidence: station with more stores refers to Max(Count(store_nbr)); ID of weather station refers to station_nbr
SQL: SELECT station_nbr FROM relation GROUP BY station_nbr ORDER BY COUNT(station_nbr) DESC LIMIT 1

Database: university
Question: Name the university and country which had the highest number of international students in 2015.
Evidence: highest number of international students refers to MAX(DIVIDE(MULTIPLY(num_students, pct_international_students), 100)); in 2015 refers to year = 2015; name of university refers to university_name;
SQL: SELECT T1.university_name, T3.country_name FROM university AS T1 INNER JOIN university_year AS T2 ON T1.id = T2.university_id INNER JOIN country AS T3 ON T3.id = T1.country_id WHERE T2.year = 2015 ORDER BY T2.num_students DESC LIMIT 1

Database: ice_hockey_draft
Question: Among all the teams that made the playoffs in the 2007-2008 season, identify the percentage that played over 20 games.
Evidence: playoffs refers to GAMETYPE = 'Playoffs'; percentage = MULTIPLY(DIVIDE(SUM(GP > 20), COUNT(ELITEID)), 100); played over 20 games refers to GP > 20; 2007-2008 season refers to SEASON = '2007-2008';
SQL: SELECT CAST(COUNT(CASE WHEN GP > 20 THEN TEAM ELSE NULL END) AS REAL) * 100 / COUNT(TEAM) FROM SeasonStatus WHERE SEASON = '2007-2008' AND GAMETYPE = 'Playoffs'

Database: cookbook
Question: What is the average vitamin C amount of all cakes?
Evidence: average vitamin C refers to AVG(vitamin_c); all cakes refers to title LIKE '%cake%'
SQL: SELECT AVG(T1.vitamin_c) FROM Nutrition AS T1 INNER JOIN Recipe AS T2 ON T2.recipe_id = T1.recipe_id WHERE T2.title LIKE '%cake%'

Database: food_inspection_2
Question: Please list the assumed name of all the facilities that failed an inspection in 2010.
Evidence: assumed name refers to dba_name; failed an inspection refers to results = 'Fail'; in 2010 refers to inspection_date like '2010%'
SQL: SELECT DISTINCT T2.dba_name FROM inspection AS T1 INNER JOIN establishment AS T2 ON T1.license_no = T2.license_no WHERE T1.results = 'Fail' AND strftime('%Y', T1.inspection_date) = '2010'

Database: codebase_comments
Question: How many language code of method is used for the github address "https://github.com/managedfusion/managedfusion.git
"?
Evidence: language code of method refers to Lang; github address refers to Url; Url = 'https://github.com/managedfusion/managedfusion.git';
SQL: SELECT COUNT(DISTINCT T3.Lang) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId INNER JOIN Method AS T3 ON T2.Id = T3.SolutionId WHERE T1.Url = 'https://github.com/managedfusion/managedfusion.git'

Database: law_episode
Question: What is the average star with highest percentage for episodes that have received award?
Evidence: received award refers to result = 'Winner'; the highest percentage refers to max(percent); average star = divide(sum(stars), count(episode_id))
SQL: SELECT T2.person_id FROM Vote AS T1 INNER JOIN Award AS T2 ON T1.episode_id = T2.episode_id ORDER BY T1.percent DESC LIMIT 1

Database: synthea
Question: How old was Mr. Stacy Morar at the time of his first emergency room admission due to a drug overdose?
Evidence: how old = SUBTRACT(MIN(encounters.DATE), patients.birthdate); his first emergency room admission refers to MIN(encounters.DATE); drug overdose refers to encounters.REASONDESCRIPTION = 'Drug overdose' ;
SQL: SELECT T2.DATE - T1.birthdate AS age FROM patients AS T1 INNER JOIN encounters AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Stacy' AND T1.last = 'Morar' AND T2.DESCRIPTION = 'Emergency Room Admission' AND T2.REASONDESCRIPTION = 'Drug overdose' ORDER BY T2.DATE LIMIT 1

Database: world_development_indicators
Question: What is the series note description of the series "SP.DYN.TO65.MA.ZS" which covers the topic "Health: Mortality" in 1967?
Evidence: in 1967 refers to Year = 'YR1967'
SQL: SELECT T2.Description FROM Series AS T1 INNER JOIN SeriesNotes AS T2 ON T1.SeriesCode = T2.Seriescode WHERE T1.SeriesCode = 'SP.DYN.TO65.MA.ZS' AND T1.Topic = 'Health: Mortality' AND T2.Year = 'YR1967'

Database: talkingdata
Question: Calculate the percentage of male users among all device users.
Evidence: percentage = DVIDE(SUM(gender = 'M'), COUNT(device_id)); male refers to gender = 'M';
SQL: SELECT SUM(IIF(gender = 'M', 1, 0)) / COUNT(device_id) AS per FROM gender_age