Database: chicago_crime
Question: Which district had the most number of first degree murders? Give the district number.
Evidence: the most number refers to max(count(case_number)); first degree murder refers to secondary_description = 'FIRST DEGREE MURDER'; district number refers to district_no
SQL: SELECT T2.district_no FROM IUCR AS T1 INNER JOIN Crime AS T2 ON T1.iucr_no = T2.iucr_no WHERE T1.secondary_description = 'FIRST DEGREE MURDER' GROUP BY T2.district_no ORDER BY COUNT(*) DESC LIMIT 1

Database: talkingdata
Question: How many users of the app were not active when event no.2 happened?
Evidence: not active refers to is_active = 0; event no. refers to event_id; event_id = 2;
SQL: SELECT COUNT(event_id) FROM app_events WHERE event_id = 2 AND is_active = 0

Database: legislator
Question: Give the YouTube ID of the channel 'RepWassermanSchultz.'
Evidence: RepWassermanSchultz refers to youtube
SQL: SELECT youtube_id FROM `social-media` WHERE youtube = 'RepWassermanSchultz'

Database: codebase_comments
Question: Among the repositories whose number of stars received are between 6,000 to 9,000, which repository has the highest number of solution paths and many of those solution paths needs to be compiled if user wants to implement it?
Evidence: Stars between 6,000 to 9,000; highest number of solution paths refers to max(count(Path)); needs to be compiled if user wants to implement it refers to WasCompiled = 0;
SQL: SELECT T2.RepoId, COUNT(T2.RepoId) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Stars BETWEEN 6000 AND 9000 AND T2.WasCompiled = 0 GROUP BY T2.RepoId ORDER BY COUNT(T2.RepoId) DESC LIMIT 1

Database: restaurant
Question: Among all indian restaurants in Castro St., Mountainview, how many of them is about cookhouse in their label?
Evidence: indian restaurant refers to food_type = 'indian'; Castro St. refers to street_name = 'castro st'; Mountainview refers to city = 'mountainview'; have the word "Indian" in label refers to label = 'indian'
SQL: SELECT COUNT(T1.id_restaurant) FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T1.street_name = 'castro st' AND T1.city = 'mountain view' AND T2.food_type = 'indian' AND T2.label LIKE '%cookhouse%'

Database: law_episode
Question: How many people have won at least 3 awards?
Evidence: won refers to result = 'Winner'; at least 3 awards refers to count(result) > 3
SQL: SELECT COUNT(T1.person_id) FROM Person AS T1 INNER JOIN Award AS T2 ON T1.person_id = T2.person_id WHERE T2.result = 'Winner' GROUP BY T1.person_id HAVING COUNT(T2.award_id) >= 3

Database: social_media
Question: Among all the tweets posted on Mondays, how many of them are reshared?
Evidence: "Monday" is the Weekday; reshare refers to IsReshare = 'TRUE'
SQL: SELECT COUNT(DISTINCT TweetID) FROM twitter WHERE Weekday = 'Monday' AND IsReshare = 'TRUE'

Database: food_inspection
Question: What is the total number of businesses with a tax code H25?
SQL: SELECT COUNT(tax_code) FROM businesses WHERE tax_code = 'H25'

Database: retail_complains
Question: How many days delay for the complaint call from Mr. Brantley Julian Stanley on 2012/5/18?
Evidence: days delay for the complaint = SUBTRACT("date sent to company", "Date received"); Mr refers to sex = 'Male'; on 2012/5/18 refers to "Date received" = '2012-05-18';
SQL: SELECT 365 * (strftime('%Y', T2.`Date sent to company`) - strftime('%Y', T2.`Date received`)) + 30 * (strftime('%M', T2.`Date sent to company`) - strftime('%M', T2.`Date received`)) + (strftime('%d', T2.`Date sent to company`) - strftime('%d', T2.`Date received`)) AS days FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.`Date received` = '2012-05-18' AND T1.sex = 'Male' AND T1.first = 'Brantley' AND T1.middle = 'Julian' AND T1.last = 'Stanley'

Database: student_loan
Question: How many of the unemployed students are disabled?
SQL: SELECT COUNT(T1.name) FROM unemployed AS T1 INNER JOIN disabled AS T2 ON T1.name = T2.name

Database: professional_basketball
Question: Which NBA team that didn't play in playoffs had the most winning rate in the 2000 NBA regular season?
Evidence: NBA refers to lgID = 'NBA'; didn't play in the playoffs refers to PostGP = 0; 2000 refers to year = 2000; the most winning rate refers to max(divide(won, add(won, lost)))
SQL: SELECT T2.tmID FROM players_teams AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID AND T1.year = T2.year WHERE T1.PostGP = 0 AND T1.year = 2000 ORDER BY CAST(T2.won AS REAL) / (T2.won + T2.lost) DESC LIMIT 1

Database: synthea
Question: Among the patients who have been using Penicillin V Potassium 250 MG, what percentage of patients are female?
Evidence: Penicillin V Potassium 250 MG refers to medications.DESCRIPTION = 'Penicillin V Potassium 250 MG'; percentage = MULTIPLY(DIVIDE(patients.patient WHERE gender = 'F'), COUNT(patients.patient) WHERE medications.DESCRIPTION = 'Penicillin V Potassium 250 MG'), 100) female refers to gender = 'F';
SQL: SELECT CAST(SUM(CASE WHEN T1.gender = 'F' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.patient) FROM patients AS T1 INNER JOIN medications AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Penicillin V Potassium 250 MG'

Database: human_resources
Question: Which position has the highest amount of poor performing employees?
Evidence: poor performing employees refers to performance = 'Poor'; the highest amount of employees refers to MAX(positiontitle)
SQL: SELECT T2.positiontitle FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.performance = 'Poor' GROUP BY T2.positiontitle ORDER BY COUNT(T2.positiontitle) DESC LIMIT 1

Database: video_games
Question: How many games were released on PS4 in 2014?
Evidence: on PS4 refers to platform_name = 'PS4'; in 2014 refers to release_year = 2014
SQL: SELECT COUNT(DISTINCT T3.game_id) FROM platform AS T1 INNER JOIN game_platform AS T2 ON T1.id = T2.platform_id INNER JOIN game_publisher AS T3 ON T2.game_publisher_id = T3.id WHERE T1.platform_name = 'PS4' AND T2.release_year = 2014

Database: retail_complains
Question: What is the name of the state in which there have been the largest number of complaints with priority 0?
Evidence: largest number of complaints refers to MAX(COUNT("Complaint ID") WHERE priority = 0);
SQL: SELECT T2.state FROM callcenterlogs AS T1 INNER JOIN client AS T2 ON T1.`rand client` = T2.client_id INNER JOIN district AS T3 ON T2.district_id = T3.district_id INNER JOIN state AS T4 ON T3.state_abbrev = T4.StateCode WHERE T1.priority = 0 GROUP BY T2.state ORDER BY COUNT(T2.state) DESC LIMIT 1

Database: app_store
Question: Which apps have multiple genres and what is the total sentiment subjectivity of these apps?
Evidence: multiple genres refers to COUNT(Genres>1; total sentiment subjectivity = Sum(Sentiment_Subjectivity);
SQL: SELECT SUM(T2.Sentiment_Subjectivity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres > 1

Database: mental_health_survey
Question: How many users answered the question "Overall, how much importance does your employer place on physical health?"?
Evidence: question refers to questiontext
SQL: SELECT COUNT(T1.UserID) FROM Answer AS T1 INNER JOIN Question AS T2 ON T1.QuestionID = T2.questionid WHERE T2.questiontext LIKE 'Overall, how much importance does your employer place on physical health?'

Database: airline
Question: What is the only flight destination for flights from Albany?
Evidence: flight destination refers to DEST; from Albany refers to ORIGIN = 'ABY';
SQL: SELECT DEST FROM Airlines WHERE ORIGIN = 'ABY' GROUP BY DEST