Database: olympics
Question: Which sport did John Aalberg participate in?
Evidence: sport refers to sport_name;
SQL: SELECT DISTINCT T1.sport_name FROM sport AS T1 INNER JOIN event AS T2 ON T1.id = T2.sport_id INNER JOIN competitor_event AS T3 ON T2.id = T3.event_id INNER JOIN games_competitor AS T4 ON T3.competitor_id = T4.id INNER JOIN person AS T5 ON T4.person_id = T5.id WHERE T5.full_name = 'John Aalberg'

Database: car_retails
Question: To whom does Steve Patterson report? Please give his or her full name.
Evidence: reportsTO' is the leader of the 'employeeNumber';
SQL: SELECT t2.firstName, t2.lastName FROM employees AS t1 INNER JOIN employees AS t2 ON t2.employeeNumber = t1.reportsTo WHERE t1.firstName = 'Steve' AND t1.lastName = 'Patterson'

Database: codebase_comments
Question: How many solutions are in "https://github.com/derickbailey/presentations-and-training.git"?
Evidence: solutions refers to Solution.Id; https://github.com/derickbailey/presentations-and-training.git refers to Url; Url; = 'https://github.com/derickbailey/presentations-and-training.git';
SQL: SELECT COUNT(T2.RepoId) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Url = 'https://github.com/derickbailey/presentations-and-training.git'

Database: soccer_2016
Question: What is the city name of country ID 3?
SQL: SELECT City_Name FROM City WHERE Country_ID = 3

Database: menu
Question: How much does the dish on page 2 of menu ID 12474 cost?
Evidence: page 2 refers to page_number = 2;
SQL: SELECT T1.price FROM MenuItem AS T1 INNER JOIN MenuPage AS T2 ON T2.id = T1.menu_page_id WHERE T2.menu_id = 12474 AND T2.page_number = 2

Database: professional_basketball
Question: List all the coatches of the Oklahoma City Thunder
Evidence: coach refers to coachID; Oklahoma City Thunder refers to name = 'Oklahoma City Thunder'
SQL: SELECT DISTINCT coachID FROM coaches AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID WHERE name = 'Oklahoma City Thunder'

Database: video_games
Question: List the genre id of the game Pro Evolution Soccer 2012.
Evidence: Pro Evolution Soccer 2012 refers to game_name = 'Pro Evolution Soccer 2012'
SQL: SELECT T.genre_id FROM game AS T WHERE T.game_name = 'Pro Evolution Soccer 2012'

Database: movie
Question: What is the name of male and white actor with actor ID 439?
Evidence: male refers to Gender = 'Male'; white refers to Ethnicity = 'White'
SQL: SELECT Name FROM actor WHERE ActorID = 439 AND Gender = 'Male' AND Ethnicity = 'White'

Database: retail_complains
Question: What is the social number of the person who made the most complaints?
Evidence: social number refers to social; most complaints refers to max(count(event.Client_ID))
SQL: SELECT T1.social FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID GROUP BY T1.client_id ORDER BY COUNT(T1.client_id) DESC LIMIT 1

Database: retails
Question: What is the size of the smallest part in a jumbo case container?
Evidence: size refers to p_size; the smallest part refers to min(p_size); jumbo case container refers to p_container = 'JUMBO CASE'
SQL: SELECT MIN(p_size) FROM part WHERE p_container = 'JUMBO CASE'

Database: professional_basketball
Question: Among the winning game from the team, what is the percentage of the winning was home game.
Evidence: percentage of winning at the home = Divide(homeWon, won) * 100
SQL: SELECT CAST(homeWon AS REAL) * 100 / won  FROM teams

Database: sales_in_weather
Question: What was the average temperature difference between store number 18 and 19 on 16 September 2022?
Evidence: store number 18 refers to store_nbr = 18; store number 19 refers to store_nbr = 19; on 16 September 2022 refers to date = '2022-09-16'; average temperature difference = Subtract(tavg where store_nbr = 18, tavg where store_nbr = 19)
SQL: SELECT SUM(CASE WHEN T1.store_nbr = 18 THEN T2.tavg ELSE 0 END) - SUM(CASE WHEN T1.store_nbr = 19 THEN T2.tavg ELSE 0 END) FROM relation AS T1 INNER JOIN weather AS T2 ON T1.station_nbr = T2.station_nbr WHERE T2.`date` = '2012-09-16'

Database: genes
Question: Taking all the essential genes of the transcription factors class located in the nucleus as a reference, how many of them carry out a genetic-type interaction with another gene? List them.
SQL: SELECT T2.GeneID1 FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T1.Localization = 'nucleus' AND T1.Class = 'Transcription factors' AND T1.Essential = 'Essential' AND T2.Expression_Corr != 0

Database: retail_world
Question: Give the home phone number of the employee who is in charge of "Savannah" territory.
Evidence: home phone number refers to HomePhone; Savannah refers to TerritoryDescription = 'Savannah';
SQL: SELECT T1.HomePhone FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN Territories AS T3 ON T2.TerritoryID = T3.TerritoryID WHERE T3.TerritoryDescription = 'Savannah'

Database: movie
Question: Who played the No.2 character in the credit list of the movie "American Hustle"?
Evidence: No.2 character refers to creditOrder = '2'; movie "American Hustle" refers to Title = 'American Hustle'
SQL: SELECT T3.Name FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID INNER JOIN actor AS T3 ON T3.ActorID = T2.ActorID WHERE T1.Title = 'American Hustle' AND T2.creditOrder = '2'

Database: food_inspection_2
Question: What is the difference in the number of restaurants that passed and failed the canvass inspection type?
Evidence: canvass inspection type refers to inspection_type = 'Canvass'; restaurant refers to facility_type = 'Restaurant'; difference = subtract(count(inspection_id where results = 'Pass'), count(inspection_id where results = 'Fail'))
SQL: SELECT COUNT(CASE WHEN T2.results = 'Pass' THEN T1.license_no END) - COUNT(CASE WHEN T2.results = 'Fail' THEN T1.license_no END) AS diff FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T2.inspection_type = 'Canvass' AND T1.facility_type = 'Restaurant'

Database: talkingdata
Question: State the gender of users who use the device "-9222956879900150000".
Evidence: device refers to device_id; device_id = -9222956879900150000;
SQL: SELECT gender FROM gender_age WHERE device_id = -9222956879900150000

Database: books
Question: Name the book title of the bestseller.
Evidence: book title refers to title; best sellers refers to title where Max(count(order_id))
SQL: SELECT T1.title FROM book AS T1 INNER JOIN order_line AS T2 ON T1.book_id = T2.book_id GROUP BY T1.title ORDER BY COUNT(T1.title) DESC LIMIT 1

Database: movie_3
Question: Distinguish the films performed by Judy Dean according to category.
Evidence: films performed refers to film
SQL: SELECT T5.name 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 INNER JOIN film_category AS T4 ON T2.film_id = T4.film_id INNER JOIN category AS T5 ON T4.category_id = T5.category_id WHERE T1.first_name = 'Judy' AND T1.last_name = 'Dean'

Database: book_publishing_company
Question: In which country is the publisher of the book "Life Without Fear" located?
Evidence: Life Without Fear is book title
SQL: SELECT T2.country FROM titles AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id WHERE T1.title = 'Life Without Fear'

Database: simpson_episodes
Question: Among the people in Animation Department, who are credited for additional time in the episode titled by "How the Test Was Won"?
Evidence: Animation Department refers to category = 'Animation Department'; credited refers to credited = 'true'; for additional timer refers to role = 'additional timer'
SQL: SELECT T2.person FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id WHERE T1.title = 'How the Test Was Won' AND T2.role = 'additional timer' AND T2.credited = 'true' AND T2.category = 'Animation Department';