Database: synthea
Question: What is the most common condition among the female Americans?
Evidence: the most common condition refers to MAX(COUNT(DESCRIPTION)); among the female Americans refer to PATIENT where gender = 'F' and ethnicity = 'american';
SQL: SELECT T2.DESCRIPTION FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT WHERE T1.gender = 'F' AND T1.ethnicity = 'american' GROUP BY T2.DESCRIPTION ORDER BY COUNT(T2.DESCRIPTION) DESC LIMIT 1

Database: food_inspection
Question: What was the inspection type when El Aji Peruvian Restaurant got highest inspection score?
Evidence: El Aji Peruvian Restaurant is the name of the business; highest inspection score refers to MAX(score);
SQL: SELECT T1.type FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T2.name = 'El Aji Peruvian Restaurant' ORDER BY T1.score DESC LIMIT 1

Database: soccer_2016
Question: What percentage of players have Legbreak skill?
Evidence: Legbreak skill refers to Bowling_skill = 'Legbreak' ; percentage = divide(sum(Player_Id) when Bowling_skill = 'Legbreak', count(Player_Id)) as percentage
SQL: SELECT CAST(SUM(CASE WHEN T2.Bowling_skill = ' Legbreak' THEN 1 ELSE 0 END) AS REAL) * 100 / TOTAL(T1.Player_Id) FROM Player AS T1 INNER JOIN Bowling_Style AS T2 ON T1.Bowling_skill = T2.Bowling_Id

Database: movie_platform
Question: What's the average rating score of the movie "A Way of Life"?
Evidence: A Way of Life' is movie_title; average rating score = Divide (Sum(rating_score), Count(rating_id));
SQL: SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'A Way of Life'

Database: movies_4
Question: Give the number of movies with "saving the world" as the keyword.
Evidence: "saving the world" as the keyword refers to keyword_name = 'saving the world'
SQL: SELECT COUNT(T2.movie_id) FROM keyword AS T1 INNER JOIN movie_keywords AS T2 ON T1.keyword_id = T2.keyword_id WHERE keyword_name = 'saving the world'

Database: superstore
Question: How many art products were ordered in 2013 in the east superstore?
Evidence: ordered in 2013 refers to strftime('%Y', "Order Date") = '2013'; art products refers to "Sub-Category" = 'Art'
SQL: SELECT COUNT(DISTINCT T1.`Product ID`) FROM east_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.`Sub-Category` = 'Art' AND T1.Region = 'East' AND STRFTIME('%Y', T1.`Order Date`) = '2013'

Database: movies_4
Question: How many movies did Harrison Ford appear in total?
SQL: SELECT COUNT(T2.movie_id) FROM person AS T1 INNER JOIN movie_cast AS T2 ON T1.person_id = T2.person_id WHERE T1.person_name = 'Harrison Ford'

Database: cars
Question: What is the price of a Chevrolet Bel Air?
Evidence: Chevrolet Bel Air refers to car_name = 'chevrolet bel air'
SQL: SELECT T2.price FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T1.car_name = 'chevrolet bel air'

Database: language_corpus
Question: What is the revision page ID of title "Aigua dolÃ§a"?
Evidence: title "Aigua dolÃ§a" refers to title LIKE 'Aigua dolÃ§a%'
SQL: SELECT revision FROM pages WHERE title = 'Aigua dolÃ§a'

Database: video_games
Question: How many video game publishers have Interactive in their names?
Evidence: publishers that have Interactive in their names refers to publisher_name LIKE '%Interactive%';
SQL: SELECT COUNT(T.id) FROM publisher AS T WHERE T.publisher_name LIKE '%Interactive%'

Database: car_retails
Question: How many sales representatives who have office code is 1?
Evidence: sales representative refers to jobTitle = 'Sales Rep';
SQL: SELECT COUNT(officeCode) FROM employees WHERE jobTitle = 'Sales Rep' AND officeCode = 1

Database: cookbook
Question: List the ingredients which measure in slices.
Evidence: slices refers to unit = 'slice(s)'
SQL: SELECT T1.name FROM Ingredient AS T1 INNER JOIN Quantity AS T2 ON T1.ingredient_id = T2.ingredient_id WHERE T2.unit = 'slice(s)'

Database: shipping
Question: How many customers who live in California that are retailers?
Evidence: "retailer" is the cust_type; live in California refers to state = 'CA'
SQL: SELECT COUNT(*) FROM customer WHERE cust_type = 'retailer' AND state = 'CA'

Database: disney
Question: Among the movies in which Alan Tudyk is a voice actor, how many of them were released after 2012?
Evidence: released after 2012 refers to (release_date, instr(release_date, '-') + 5) > 12;
SQL: SELECT COUNT(T2.movie) FROM characters AS T1 INNER JOIN `voice-actors` AS T2 ON T1.movie_title = T2.movie WHERE T2.`voice-actor` = 'Alan Tudyk' AND SUBSTR(release_date, INSTR(release_date, '-') + 5) > 12

Database: european_football_1
Question: List the number of games that ended up with 5-0 in Greece.
Evidence: 5-0 is a score where FTHG = '5' and FTAG = '0'; Greece is a name of country; games refer to Div;
SQL: SELECT COUNT(T1.Div) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.country = 'Greece' AND T1.FTHG = 5 AND T1.FTAG = 0

Database: university
Question: List the countries of universities that scored 70 and below in 2016.
Evidence: scored 70 and below refers to score < 70; in 2016 refers to year = 2016
SQL: SELECT DISTINCT T3.country_name FROM university AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.university_id INNER JOIN country AS T3 ON T3.id = T1.country_id WHERE T2.score < 70 AND T2.year = 2016

Database: movie_3
Question: How many times is the number of Indian cities than Italian cities?
Evidence: indian refers to country = 'India'; Italian refers to country = 'Italy'; times = Divide(Count(city where country = 'India), Count(city where country = 'Italy'))
SQL: SELECT CAST(SUM(IIF(T1.country = 'India', 1, 0)) AS REAL) / SUM(IIF(T1.country = 'Italy', 1, 0)) FROM country AS T1 INNER JOIN city AS T2 ON T1.country_id = T2.country_id

Database: food_inspection_2
Question: How many inspections were done under the display of inspection report summary category?
Evidence: under the display of inspection report summary category refers to category = 'Display of Inspection Report Summary'
SQL: SELECT COUNT(T2.inspection_id) FROM inspection_point AS T1 INNER JOIN violation AS T2 ON T1.point_id = T2.point_id WHERE T1.category = 'Display of Inspection Report Summary'

Database: video_games
Question: What is the genre of the game "Grand Theft Auto V"?
Evidence: genre refers to genre_name; "Grand Theft Auto V" refers to game_name = 'Grand Theft Auto V';
SQL: SELECT T2.genre_name FROM game AS T1 INNER JOIN genre AS T2 ON T1.genre_id = T2.id WHERE T1.game_name = 'Grand Theft Auto V'

Database: cookbook
Question: Which recipe has the highest calories?
Evidence: the highest calories refers to MAX(calories)
SQL: SELECT T1.title FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id ORDER BY T2.calories DESC LIMIT 1

Database: movie_platform
Question: What is the average rating for movie titled 'When Will I Be Loved'?
Evidence: average rating = DIVIDE((SUM(rating_score where movie_title = 'When Will I Be Loved')), COUNT(rating_score));
SQL: SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'When Will I Be Loved'

Database: car_retails
Question: What was the latest order that customer No.114 made? Give the name of the product.
Evidence: The latest refers to the most recent orderDate;
SQL: SELECT t3.productName FROM orderdetails AS t1 INNER JOIN orders AS t2 ON t1.orderNumber = t2.orderNumber INNER JOIN products AS t3 ON t1.productCode = t3.productCode WHERE t2.customerNumber = '114' ORDER BY t2.orderDate DESC LIMIT 1

Database: movies_4
Question: Who is the person associated with the crew id 1325273?
Evidence: Who is the person refers to person_name; crew id 1325273 refers to person_id = 1325273
SQL: SELECT person_name FROM person WHERE person_id = 1325273