Database: public_review_platform
Question: How many photos type compliment given from users with high cool votes?
Evidence: photos type compliment refers to compliment_type = 'photos'; high cool votes refers to review_votes_cool = 'High'
SQL: SELECT COUNT(T1.user_id) FROM Users AS T1 INNER JOIN Users_Compliments AS T2 ON T1.user_id = T2.user_id INNER JOIN Compliments AS T3 ON T2.compliment_id = T3.compliment_id INNER JOIN Reviews AS T4 ON T1.user_id = T4.user_id WHERE T3.compliment_type = 'photos' AND T4.review_votes_cool = 'High'

Database: university
Question: Provide the ranking system of the ranking criteria named Quality of Education Rank.
Evidence: criteria named Quality of Education Rank refers to criteria_name = 'Quality of Education Rank'; ranking system refers to system_name;
SQL: SELECT T1.system_name FROM ranking_system AS T1 INNER JOIN ranking_criteria AS T2 ON T1.id = T2.ranking_system_id WHERE T2.criteria_name = 'Quality of Education Rank'

Database: books
Question: In which cities are the customers of Costa Rica located?
Evidence: "Costa Rica" is the country_name
SQL: SELECT T1.city FROM address AS T1 INNER JOIN country AS T2 ON T2.country_id = T1.country_id WHERE T2.country_name = 'Costa Rica'

Database: language_corpus
Question: How many times did the word "grec" occur on the page titled "Àbac"?
Evidence: how many times occur refers to occurrences; page titled "Àbac" refers to title = 'Àbac' ;
SQL: SELECT T2.occurrences FROM words AS T1 INNER JOIN pages_words AS T2 ON T1.wid = T2.wid INNER JOIN pages AS T3 ON T2.pid = T3.pid WHERE T3.title = 'Àbac' AND T1.word = 'grec'

Database: world
Question: Among the languages used in Baltic Countries, provide the languages which are used by over 80%.
Evidence: Baltic Countries refers to Region = 'Baltic Countries'; languages which are used by over 80% refers to Percentage > 80;
SQL: SELECT T2.Language FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Region = 'Baltic Countries' AND T2.Percentage > 80

Database: coinmarketcap
Question: What was the percentage of the Bitcoins verifiably burned until 2018/4/28?
Evidence: the percentage of the Bitcoins verifiably burned = divide(subtract(SUM(max_supply), SUM(total_supply)),SUM(total_supply))*100%; until 2013/4/28 refers to date<'2013-04-08'
SQL: SELECT CAST((SUM(T2.max_supply) - SUM(T2.total_supply)) AS REAL) / SUM(T2.total_supply) FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T2.date < '2018-04-28' AND T1.name = 'Bitcoin'

Database: beer_factory
Question: What is the best seller root beer brand and what is the average star rating for this root beer?
Evidence: best seller root beer refers to MAX(COUNT(BrandID)); average star rating = AVG(StarRating);
SQL: SELECT T1.BrandID, AVG(T1.StarRating) FROM rootbeerreview AS T1 INNER JOIN `transaction` AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN rootbeerbrand AS T3 ON T1.BrandID = T3.BrandID GROUP BY T3.BrandID ORDER BY COUNT(T1.BrandID) DESC LIMIT 1

Database: bike_share_1
Question: Find the longest ride on foggy day. What were the mean visibility, mean wind speed, and weather event during that ride? Also, list the coordinates and names of the start and end stations.
Evidence: foggy day refers to events = 'fog'; longest ride on a foggy day refers to MAX(duration) where events = 'fog'; mean visibility refers to mean_visibility_miles; mean wind speed refers to mean_wind_speed_mph; weather event refers to events; coordinates refers to (lat, long); start station refers to start_station_id; end station refers to end_station_id;
SQL: SELECT T3.mean_visibility_miles, T3.mean_wind_speed_mph, T3.events, T1.lat, T1.long , T2.start_station_name, T2.end_station_name FROM station AS T1 INNER JOIN trip AS T2 ON T2.start_station_name = T1.name INNER JOIN weather AS T3 ON T3.zip_code = T2.zip_code WHERE T3.events = 'Fog' ORDER BY T2.duration DESC LIMIT 1

Database: donor
Question: Give the coordinates of the buyer of R & A Plant Genetics from Benchmark Education.
Evidence: coordinates refer to (school_latitude, school_longitude); R & A Plant Genetics refer to item_name; Benchmark Education refer to vendor_name
SQL: SELECT T2.school_latitude, T2.school_longitude FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.item_name = 'R & A Plant Genetics' AND T1.vendor_name = 'Benchmark Education'

Database: retail_world
Question: How many more territories are there in than Eastern Region than in the Southern Region?
Evidence: how many more = SUBTRACT(SUM(RegionDescription = 'Eastern'), SUM(RegionDescription = 'Southern')); Eastern Region refers to RegionDescription = 'Eastern'; Southern Region refers to RegionDescription = 'Southern';
SQL: SELECT ( SELECT COUNT(T1.TerritoryID) FROM Territories AS T1 INNER JOIN Region AS T2 ON T1.RegionID = T2.RegionID WHERE T2.RegionDescription = 'Eastern' ) - ( SELECT COUNT(T1.TerritoryID) FROM Territories AS T1 INNER JOIN Region AS T2 ON T1.RegionID = T2.RegionID WHERE T2.RegionDescription = 'Southern' ) AS Calu

Database: legislator
Question: What are the Wikipedia page names of all the anti-administration senators?
Evidence: Wikipedia page names refers to wikipedia_id; anti-administration refers to party = 'Anti-Administration'; senators refers to type = 'sen';
SQL: SELECT T1.wikipedia_id FROM historical AS T1 INNER JOIN `historical-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.type = 'sen' AND T2.party = 'Anti-Administration'

Database: professional_basketball
Question: Please list the top three shortest black players.
Evidence: shortest player refers to Min(height); black players refers to race = 'B'
SQL: SELECT firstName, lastName FROM players WHERE race = 'B' AND height > 0 ORDER BY height ASC LIMIT 3

Database: food_inspection_2
Question: List the types and results of the inspections done on Riverwalk café.
Evidence: type refers to inspection_type; Riverwalk café refers to facility_type = 'RIVERWALK CAFE'
SQL: SELECT T2.inspection_type, T2.results FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T1.facility_type = 'RIVERWALK CAFE'

Database: superstore
Question: What is the name of the product that was ordered recently by Darren Powers?
Evidence: Darren Powers is the "Customer Name"; name of the product refers to "Product Name"; recently refers to MAX("Order Date")
SQL: SELECT T3.`Product Name` FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T2.`Product ID` WHERE T1.`Customer Name` = 'Darren Powers' ORDER BY T2.`Order Date` DESC LIMIT 1

Database: soccer_2016
Question: Name the player who is born on July 7, 1981.
Evidence: name of the player refers to Player_Name; born on July 7 1981 refers to DOB = '1981-07-07'
SQL: SELECT Player_name FROM Player WHERE DOB = '1981-07-07'

Database: bike_share_1
Question: Which station did the user who started at Market at 4th station ended their trip at the time of 12:45:00 PM and the date of 8/29/2013 and what is the location coordinates of the ending station?
Evidence: started at refers to start_station_name; start_station_name = 'Market at 4th'; location coordinates refers to (lat, long);
SQL: SELECT T1.name, T1.lat, T1.long FROM station AS T1 INNER JOIN trip AS T2 ON T2.end_station_name = T1.name WHERE T2.start_station_name = 'Market at 4th' AND T2.end_date = '8/29/2013 12:45'