Database: donor
Question: How many teachers in Twin Falls have Math & Science as their primary focus area?
Evidence: Twin Falls is school_country; 'Math & Science' is primary_focus_area;
SQL: SELECT COUNT(teacher_acctid) FROM projects WHERE school_county = 'Twin Falls' AND primary_focus_area = 'Math & Science'

Database: software_company
Question: In geographic identifier from 10 to 30, how many of them has an income below 2000?
Evidence: GEOID BETWEEN 10 AND 30; INCOME_K < 2000;
SQL: SELECT COUNT(GEOID) FROM Demog WHERE INCOME_K < 2000 AND GEOID >= 10 AND GEOID <= 30

Database: ice_hockey_draft
Question: Among the Italian players, who has the shortest height?
Evidence: Italian refers to nation = 'Italy'; players refers to PlayerName; shortest height refers to MIN(height_in_cm);
SQL: SELECT T2.PlayerName FROM height_info AS T1 INNER JOIN PlayerInfo AS T2 ON T1.height_id = T2.height WHERE T2.nation = 'Italy' ORDER BY T1.height_in_cm ASC LIMIT 1

Database: citeseer
Question: Find the words cited in papers that are cited by sima01computational?
Evidence: paper cited by refers to citing_paper_id; citing_paper_id = 'sima01computational';
SQL: SELECT DISTINCT T2.word_cited_id FROM cites AS T1 INNER JOIN content AS T2 ON T1.cited_paper_id = T2.paper_id WHERE T1.citing_paper_id = 'sima01computational'

Database: cs_semester
Question: How many of the professors are female?
Evidence: female refers to gender = 'Female';
SQL: SELECT COUNT(prof_id) FROM prof WHERE gender = 'Female'

Database: airline
Question: What is the percentage of flights which landed at Pittsburgh were faster than scheduled?
Evidence: percentage = MULTIPLY(DIVIDE(SUM(ACTUAL_ELAPSED_TIME < T2.CRS_ELAPSED_TIME), COUNT(Code)), 100); landed at refers to DEST; Pittsburgh refers to Description which contains 'Pittsburgh'; faster than scheduled refers to ACTUAL_ELAPSED_TIME < CRS_ELAPSED_TIME;
SQL: SELECT CAST(SUM(CASE WHEN T1.ACTUAL_ELAPSED_TIME < T1.CRS_ELAPSED_TIME THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM Airlines AS T1 INNER JOIN Airports AS T2 ON T2.Code = T1.DEST WHERE T2.Description LIKE '%Pittsburgh%' AND T1.CRS_ELAPSED_TIME IS NOT NULL AND T1.ACTUAL_ELAPSED_TIME IS NOT NULL

Database: cars
Question: What is the maximum acceleration of a car with price over $40000?
Evidence: the maximum acceleration refers to max(acceleration); price over $40000 refers to price > 40000
SQL: SELECT MAX(T1.acceleration) FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T2.price > 40000

Database: disney
Question: What is the highest grossing movie without a song?
Evidence: the highest grossing movie without song refers to movie_title where MAX(total_gross) and song = 'null';
SQL: SELECT T1.movie_title FROM movies_total_gross AS T1 INNER JOIN characters AS T2 ON T2.movie_title = T1.movie_title WHERE T2.song IS NULL ORDER BY CAST(REPLACE(trim(T1.total_gross, '$'), ',', '') AS REAL) DESC LIMIT 1

Database: bike_share_1
Question: Please list the starting stations of the bike trips made on a day with a max humidity over 80 in 2013 in the area where the zip code is 94107.
Evidence: starting stations refers to start_station_name; day with a max humidity over 80 refers to max_humidity>80; in 2013 refers to date LIKE'%2013';
SQL: SELECT DISTINCT T1.start_station_name FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE SUBSTR(CAST(T2.date AS TEXT), -4) = '2013' AND T2.zip_code = 94107 AND T2.max_temperature_f > 80

Database: synthea
Question: List down the first name of patients who encountered normal pregnancy.
Evidence: encountered normal pregnancy refers to encounters where REASONDESCRIPTION = 'Normal pregnancy';
SQL: SELECT DISTINCT T1.first FROM patients AS T1 INNER JOIN encounters AS T2 ON T1.patient = T2.PATIENT WHERE T2.REASONDESCRIPTION = 'Normal pregnancy'

Database: food_inspection
Question: How many unscheduled routine inspections did "Soma Restaurant And Bar" have?
Evidence: "Soma Restaurant And Bar" is the name of the business; unscheduled routine inspections refer to type = 'Routine - Unscheduled';
SQL: SELECT COUNT(T1.business_id) FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T2.name = 'Soma Restaurant And Bar' AND T1.type = 'Routine - Unscheduled'

Database: movielens
Question: UK produced what genre of movies?
Evidence: UK is a country
SQL: SELECT T2.genre FROM movies AS T1 INNER JOIN movies2directors AS T2 ON T1.movieid = T2.movieid WHERE T1.country = 'UK'

Database: authors
Question: How many more papers in total were published in the journal "Cases Journal" than in the journal "Molecular Brain" in percentage?
Evidence: "Cases Journal" and "Molecular Brain" are FullName of journal; more paper in percentage = Subtract(Count(Id(FullName = 'Cases Journal')), Count(Id(FullName = 'Molecular Brain')))/ Count(Id(FullNmae = 'Molecular Brain')) * 100
SQL: SELECT SUM(CASE WHEN T1.FullName = 'Cases Journal' THEN 1 ELSE 0 END) - SUM(CASE WHEN T1.FullName = 'Molecular Brain' THEN 1 ELSE 0 END) AS DIFF FROM Journal AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.JournalId

Database: world_development_indicators
Question: What is the percentage of increase of the indicator on Adolescent fertility rate from 1960 to 1961 in the country whose Alpha2Code is 1A?
Evidence: the percentage of increase from 1960 to 1961 = divide(subtract(sum(value where Year = 1961), sum(Value where Year = 1960)), sum(Value where Year = 1960)) *100%; indicator on Adolescent fertility rate refers to IndicatorName = 'Adolescent fertility rate (births per 1,000 women ages 15-19)%'


SQL: SELECT (( SELECT T2.Value FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.Alpha2Code = '1A' AND T2.IndicatorName = 'Adolescent fertility rate (births per 1,000 women ages 15-19)' AND T2.Year = 1961 ) - ( SELECT T2.Value FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.Alpha2Code = '1A' AND T2.IndicatorName = 'Adolescent fertility rate (births per 1,000 women ages 15-19)' AND T2.Year = 1960 )) * 1.0 / ( SELECT SUM(T2.Value) FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.Alpha2Code = '1A' AND T2.IndicatorName = 'Adolescent fertility rate (births per 1,000 women ages 15-19)' AND T2.Year = 1960 )

Database: codebase_comments
Question: List the summary of the method "Castle.MonoRail.Framework.Test.StubViewComponentContext.RenderSection".
SQL: SELECT DISTINCT Summary FROM Method WHERE Name = 'Castle.MonoRail.Framework.Test.StubViewComponentContext.RenderSection'

Database: food_inspection
Question: How many eateries applied in 2012?
Evidence: eateries applied in 2012 refer to business_id where application_date between '2012-01-01' and '2012-12-31';
SQL: SELECT COUNT(business_id) FROM businesses WHERE STRFTIME('%Y', application_date) = '2012'

Database: food_inspection_2
Question: How many "food maintenance" related violations did inspection no.1454071 have?
Evidence: "food maintenance" related refers to category = 'Food Maintenance'; inspection no.1454071 refers to inspection_id = '1454071'
SQL: SELECT COUNT(T2.point_id) FROM inspection_point AS T1 INNER JOIN violation AS T2 ON T1.point_id = T2.point_id WHERE T2.inspection_id = '1454071' AND T1.category = 'Food Maintenance'

Database: movie_3
Question: Give the duration of the film starred by Nick Wahlberg with the highest rental rate.
Evidence: duration refers to length; the highest rental rate refers to max(rental_rate)
SQL: SELECT T3.title FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T1.first_name = 'Nick' AND T1.last_name = 'Wahlberg' ORDER BY T3.rental_rate DESC LIMIT 1

Database: language_corpus
Question: Indicate which is the word that is repeated the most times.
Evidence: repeated the most times refer to MAX(occurrences);
SQL: SELECT word FROM words WHERE occurrences = ( SELECT MAX(occurrences) FROM words )