Database: soccer_2016
Question: What is the venue for the match ID 829768?
Evidence: 
venue refers to Venue_Name
SQL: SELECT T1.Venue_Name FROM Venue AS T1 INNER JOIN Match AS T2 ON T1.venue_id = T2.venue_id WHERE T2.match_id = 829768

Database: world
Question: Calculate the average population per city in Karnataka district.
Evidence: average population = AVG(Population);
SQL: SELECT AVG(Population) FROM City WHERE District = 'Karnataka' GROUP BY ID

Database: regional_sales
Question: List all the customers with name containing the word 'Group'.
Evidence: name containing the word 'Group' refers to Customer Names LIKE '%Group%';
SQL: SELECT T FROM ( SELECT IIF(`Customer Names` LIKE '%Group%', `Customer Names`, NULL) AS T FROM Customers ) WHERE T IS NOT NULL

Database: retail_world
Question: What is the total price of Ikura ordered in order no. 10273?
Evidence: total price = MULTIPLY(UnitPrice, Quantity); Ikura refers to ProductName = 'Ikura'; order no. refers to OrderID;
SQL: SELECT T2.UnitPrice * T2.Quantity FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T2.OrderID = 10273 AND T1.ProductName = 'Ikura'

Database: books
Question: List all the names of the books written by Danielle Steel.
Evidence: "Danielle Steel" is the author_name; name of books refers to title
SQL: SELECT T1.title FROM book AS T1 INNER JOIN book_author AS T2 ON T1.book_id = T2.book_id INNER JOIN author AS T3 ON T3.author_id = T2.author_id WHERE T3.author_name = 'Danielle Steel'

Database: movies_4
Question: How many female characters are there in the movie "Spider-Man 3"?
Evidence: female characters refer to gender = 'Female'; "Spider-Man 3" refers to title = 'Spider-Man 3'
SQL: SELECT COUNT(*) FROM movie AS T1 INNER JOIN movie_cast AS T2 ON T1.movie_id = T2.movie_id INNER JOIN gender AS T3 ON T2.gender_id = T3.gender_id WHERE T1.title = 'Spider-Man 3' AND T3.gender = 'Female'

Database: simpson_episodes
Question: Who is the oldest among all the casts and crews?
Evidence: oldest refers to MIN(birthdate)
SQL: SELECT name FROM Person ORDER BY birthdate ASC LIMIT 1;

Database: airline
Question: How many hours in total did all of the Delta Air Lines aircraft were delayed due to a late aircraft in August of 2018? Identify the plane number of the aircraft with the highest delayed hours.
Evidence: hours in total = DIVIDE(SUM(LATE_AIRCRAFT_DELAY), 60); Delta Air Lines refers to Description = 'Delta Air Lines Inc.: DL'; delayed due to a late aircraft refers to LATE_AIRCRAFT_DELAY; in August of 2018 refers to FL_DATE like '2018/8/%'; plane number refers to TAIL_NUM; highest delayed hours refers to MAX(DIVIDE(SUM(LATE_AIRCRAFT_DELAY),60));
SQL: SELECT T1.TAIL_NUM, SUM(CAST(T1.LATE_AIRCRAFT_DELAY AS REAL) / 60) AS delay FROM Airlines AS T1 INNER JOIN `Air Carriers` AS T2 ON T2.Code = T1.OP_CARRIER_AIRLINE_ID WHERE T1.FL_DATE LIKE '2018/8/%' AND T2.Description = 'Delta Air Lines Inc.: DL' ORDER BY delay DESC LIMIT 1

Database: movies_4
Question: What is the title of Jamie Foxx's most recent movie?
Evidence: most recent movie refers to max(release_date)
SQL: SELECT T1.title FROM movie AS T1 INNER JOIN movie_cast AS T2 ON T1.movie_id = T2.movie_id INNER JOIN person AS T3 ON T2.person_id = T3.person_id WHERE T3.person_name = 'Jamie Foxx' ORDER BY T1.release_date DESC LIMIT 1

Database: menu
Question: What is the name of the dish that appeared on the upper left corner on menu page no. 1389?
Evidence: appeared on the upper left corner on menu refers to xpos < 0.25 AND ypos < 0.25; menu page no. refers to menu_page_id; menu_page_id = 1389;
SQL: SELECT T1.name FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE T2.menu_page_id = 1389 AND T2.xpos < 0.25 AND T2.ypos < 0.25

Database: public_review_platform
Question: How many businesses are opened for 24 hours?
Evidence: opened for 24 hours refers to attribute_name = 'Open 24 Hours' AND attribute_value = 'true'
SQL: SELECT COUNT(T2.business_id) FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T2.attribute_value LIKE 'TRUE' AND T1.attribute_name LIKE 'Open 24 Hours'

Database: chicago_crime
Question: How many different neighborhoods are there in Roseland community?
Evidence: Roseland community refers to community_area_name = 'Roseland'
SQL: SELECT SUM(CASE WHEN T1.community_area_name = 'Roseland' THEN 1 ELSE 0 END) FROM Community_Area AS T1 INNER JOIN Neighborhood AS T2 ON T1.community_area_no = T2.community_area_no

Database: movie_3
Question: Who is the owner of email address "JEREMY.HURTADO@sakilacustomer.org"? Give the full name.
Evidence: "JEREMY.HURTADO@sakilacustomer.org" is the email; owner refers to customer; full name refers to first_name, last_name
SQL: SELECT first_name, last_name FROM customer WHERE email = 'JEREMY.HURTADO@sakilacustomer.org'

Database: shipping
Question: What is the full name of the driver that has done the most shipments in 2017?
Evidence: driver refers to driver_id; full name refers to first_name, last_name; in 2017 refers to Cast(ship_date AS DATE) = 2017; Most shipment refers to Max(Sum(weight))
SQL: SELECT T2.first_name, T2.last_name FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id WHERE STRFTIME('%Y', T1.ship_date) = '2017' GROUP BY T2.first_name, T2.last_name ORDER BY COUNT(*) DESC LIMIT 1

Database: synthea
Question: Among the patients with acute bronchitis, what is the percentage of Asian women?
Evidence: DIVIDE(COUNT(PATIENT where gender = 'F' and race = 'asian'), COUNT(PATIENT)) as percentage where DESCRIPTION = 'Acute bronchitis (disorder)' ;
SQL: SELECT CAST(SUM(CASE WHEN T2.gender = 'F' AND T2.race = 'asian' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T2.gender) FROM conditions AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T1.DESCRIPTION = 'Acute bronchitis (disorder)'

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

Database: movies_4
Question: How many movies have "vi" as their language code?
Evidence: "vi" as their language code refers to language_code = 'vi'
SQL: SELECT COUNT(T1.movie_id) FROM movie_languages AS T1 INNER JOIN language AS T2 ON T1.language_id = T2.language_id WHERE T2.language_code = 'vi'

Database: chicago_crime
Question: What phone number does alderman Emma Mitts have to call if she wants to speak to the commander in charge of the investigation of the crimes that have occurred in her ward?
SQL: SELECT T3.phone FROM Ward AS T1 INNER JOIN Crime AS T2 ON T2.ward_no = T1.ward_no INNER JOIN District AS T3 ON T3.district_no = T2.district_no WHERE T1.alderman_first_name = 'Emma' AND T1.alderman_last_name = 'Mitts'

Database: authors
Question: Between "Standford University" and "Massachusetts Institute of Technolgy", which organization had affiliated with more author.?
Evidence: "Standford University" and "Massachusetts Institute of Technolgy" are affiliation organization; affiliated with more author refers to Max(Count(Id))
SQL: SELECT Affiliation FROM Author WHERE Affiliation IN ('Stanford University', 'Massachusetts Institute of Technology') GROUP BY Affiliation ORDER BY COUNT(Id) DESC LIMIT 1

Database: books
Question: Please give the title of the oldest book published by publisher "Thomas Nelson".
Evidence: "Thomas Nelson" is the publisher_name; oldest book refers to Min(publication_date)
SQL: SELECT T1.title FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T2.publisher_name = 'Thomas Nelson' ORDER BY T1.publication_date ASC LIMIT 1