Database: retail_world
Question: What is the title of Michael Suyama?
SQL: SELECT Title FROM Employees WHERE FirstName = 'Michael' AND LastName = 'Suyama'

Database: soccer_2016
Question: Which teams did SC Ganguly join in season year 2008?
Evidence: SC Ganguly refers to Player_Name = 'SC Ganguly'; in season year 2008 refers to Season_Year = 2008
SQL: SELECT T5.Team_Name FROM Player AS T1 INNER JOIN Match AS T2 ON T1.Player_Id = T2.Man_of_the_Match INNER JOIN Player_Match AS T3 ON T3.Player_Id = T1.Player_Id INNER JOIN Season AS T4 ON T2.Season_Id = T4.Season_Id INNER JOIN Team AS T5 ON T3.Team_Id = T5.Team_Id WHERE T4.Season_Year = 2008 AND T1.Player_Name = 'SC Ganguly' GROUP BY T5.Team_Name

Database: music_platform_2
Question: How many total reviews runned at in June 2022 were added to the podcasts?
Evidence: run at in June 2022 refers to run_at BETWEEN '2022-06-01 00:00:00' and '2022-06-30 23:59:59'; reviews refers to review_added
SQL: SELECT SUM(reviews_added) FROM runs WHERE run_at LIKE '2022-06-%'

Database: codebase_comments
Question: Please provide the id of the respository that the most people like.
Evidence: repository that the most people like refers to MAX(Stars);
SQL: SELECT Id FROM Repo WHERE Stars = ( SELECT MAX(Stars) FROM Repo )

Database: books
Question: What is the name of the publisher of the book with the most pages?
Evidence: book with the most pages refers to Max(num_pages); name of publisher refers to publisher_name
SQL: SELECT T2.publisher_name FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id ORDER BY T1.num_pages DESC LIMIT 1

Database: movie_3
Question: Provide the email, address, city, and country of the customer Lillie Kim.
Evidence: 'Lillie Kim' is the full name of a customer; full name refers to first_name, last_name
SQL: SELECT T1.email, T2.address, T3.city, T4.country FROM customer AS T1 INNER JOIN address AS T2 ON T1.address_id = T2.address_id INNER JOIN city AS T3 ON T2.city_id = T3.city_id INNER JOIN country AS T4 ON T3.country_id = T4.country_id WHERE T1.first_name = 'Lillie' AND T1.last_name = 'Kim'

Database: world
Question: What is the average life expentancy of countries that speak Arabic?
Evidence: average life expectancy = AVG(LifeExpectancy); speak Arabic refers to `Language` = 'Arabic';
SQL: SELECT AVG(T1.LifeExpectancy) FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = 'Arabic'

Database: professional_basketball
Question: From 1980 to 1983, how many of the NBA All-Star players have more than 60% three point rate?
Evidence: from 1980 to 1983 refers to year BETWEEN 1980 and 1983; NBA refers to lgID = 'NBA'; more than 60% three point rate refers to divide(threeMade, threeAttempted) > 0.6
SQL: SELECT DISTINCT T2.playerID FROM player_allstar AS T1 INNER JOIN players_teams AS T2 ON T1.playerID = T2.playerID WHERE T2.year BETWEEN 1980 AND 1983 AND T1.three_made / T1.three_attempted > 0.6

Database: authors
Question: At which conference was the paper "Skew-Circulant Preconditioners for Systems of LMF-Based ODE Codes" presented?
Evidence: 'Skew-Circulant Preconditioners for Systems of LMF-Based ODE Codes' is the Title of the paper; conference refers to Conference.FullName
SQL: SELECT T2.FullName FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T1.Title = 'Skew-Circulant Preconditioners for Systems of LMF-Based ODE Codes'

Database: student_loan
Question: Among students with 1 month of absenses, how many of them are enlisted in the air force department?
Evidence: 1 month of absences refers to month = 1; department refers to organ; organ = 'air_force';
SQL: SELECT COUNT(T1.name) FROM longest_absense_from_school AS T1 INNER JOIN enlist AS T2 ON T1.name = T2.name WHERE T1.month = 1 AND T2.organ = 'air_force'

Database: codebase_comments
Question: How many solution paths that needs to be compiled if user wants to implement it in "https://github.com/jeffdik/tachy.git"?
Evidence: needs to be compiled if user wants to implement refers to WasCompiled = 0; https://github.com/jeffdik/tachy.git is url of repository
SQL: SELECT COUNT(T2.Path) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Url = 'https://github.com/jeffdik/tachy.git' AND T2.WasCompiled = 0

Database: computer_student
Question: Which level of courses is taught by professor ID 297?
Evidence: professor ID 297 refers to taughtBy.p_id = 297
SQL: SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 297

Database: olympics
Question: How many Men's 200 Metres Freestyle events did Ian James Thorpe compete in?
Evidence: Men's 200 Metres Freestyle events refer to event_name = 'Swimming Men''s 200 metres Freestyle'; events compete in refers to event_id;
SQL: SELECT COUNT(T1.id) FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id INNER JOIN competitor_event AS T3 ON T2.id = T3.competitor_id INNER JOIN event AS T4 ON T3.event_id = T4.id WHERE T1.full_name = 'Ian James Thorpe' AND T4.event_name LIKE 'Swimming Men%s 200 metres Freestyle'

Database: coinmarketcap
Question: How many coins were added in May 2013? Please list the names of coins.
Evidence: in May 2013 refers to year(date_added) = 2013 and month(date_added) = 5
SQL: SELECT COUNT(id) num FROM coins WHERE STRFTIME('%Y-%m', date_added) = '2013-05' UNION ALL SELECT name FROM coins WHERE STRFTIME('%Y-%m', date_added) = '2013-05'

Database: professional_basketball
Question: List out all the players fullname who won the championship in 1970.
Evidence: full name refers to firstName, middleName, lastName; won the championship refers to round = 'F'; in 1970 refers to year = 1970
SQL: SELECT DISTINCT T3.firstName, T3.middleName, T3.lastName FROM series_post AS T1 INNER JOIN players_teams AS T2 ON T1.tmIDWinner = T2.tmID INNER JOIN players AS T3 ON T3.playerID = T2.playerID WHERE T1.year = 1970 AND T1.round = 'F'

Database: public_review_platform
Question: For the user who gave the most number of long reviews, what is his/her averge ratings of all review?
Evidence: long reviews refers to review_length = 'long'; most number of long reviews refers to MAX(COUNT(review_length = 'long')); average ratings = AVG(review_stars);
SQL: SELECT CAST(SUM(T1.review_stars) AS REAL) / COUNT(T1.review_stars) FROM Reviews AS T1 INNER JOIN Users AS T2 ON T1.user_id = T2.user_id WHERE T1.review_length LIKE 'Long' GROUP BY T1.user_id ORDER BY COUNT(T1.review_length) DESC LIMIT 1

Database: soccer_2016
Question: Please list the bowling skills of all the players from Australia.
Evidence: Australia refers to Country_Name = 'Australia'
SQL: SELECT T2.Bowling_Skill FROM Player AS T1 INNER JOIN Bowling_Style AS T2 ON T1.Bowling_skill = T2.Bowling_Id INNER JOIN Country AS T3 ON T1.Country_Name = T3.Country_Id WHERE T3.Country_Name = 'Australia' GROUP BY T2.Bowling_Skill

Database: food_inspection
Question: Among violations on 3rd June, 2014, describe any 5 names, located cities and tax codes of the eateries with high risk category.
Evidence: eateries with high risk category refer to business_id where risk_category = 'High Risk'; 3rd June, 2014 refers to date = '2014-06-03';
SQL: SELECT DISTINCT T2.name, T2.city, T2.tax_code FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.risk_category = 'High Risk' AND T1.`date` = '2014-06-03' LIMIT 5