Database: movie_3
Question: What is the largest number of films rented per customer?
Evidence: the largest number of films refers to MAX(rental_id)
SQL: SELECT COUNT(rental_id) FROM rental GROUP BY customer_id ORDER BY COUNT(rental_id) DESC LIMIT 1

Database: airline
Question: For the flight on 2018/8/1 that was delayed for the longest time, which was the destination airport of this flight?
Evidence: on 2018/8/1 refers to FL_DATE = '2018/8/1';  delayed for the longest time refers to MAX(DEP_DELAY); destination airport refers to DEST;
SQL: SELECT T1.Description FROM Airports AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.DEST WHERE T2.FL_DATE = '2018/8/1' ORDER BY T2.DEP_DELAY DESC LIMIT 1

Database: world_development_indicators
Question: What are the sources for the data of children who finished primary school education in Latin America & Caribbean countries?
Evidence: Latin America & Caribbean is the name of the region; children who finished primary school education refer to IndicatorName = 'Out-of-school children of primary school age, both sexes (number)'; sources refer to Description;
SQL: SELECT DISTINCT T2.Source FROM Footnotes AS T1 INNER JOIN Series AS T2 ON T1.Seriescode = T2.SeriesCode INNER JOIN Country AS T3 ON T1.Countrycode = T3.CountryCode WHERE T3.Region = 'Latin America & Caribbean' AND T2.IndicatorName = 'Children out of school, primary'

Database: music_tracker
Question: What is the tag of the album with the highest amount of downloads?
Evidence: album refers to releaseType; the highest amount of downloads refers to MAX(totalSnatched);
SQL: SELECT T2.tag FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T1.releaseType = 'album' ORDER BY T1.totalSnatched DESC LIMIT 1

Database: movie_3
Question: Among the films starring PENELOPE GUINESS, how many of them are released in 2006?
Evidence: release in 2006 refers to release_year = 2006;
SQL: SELECT COUNT(T2.film_id) 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 WHERE T3.release_year = 2006 AND T1.first_name = 'PENELOPE' AND T1.last_name = 'GUINESS'

Database: public_review_platform
Question: How many users who have received a low cool vote have also received at least 1 low cool vote for some of their reviews?
Evidence: low cool vote for user refers to user_votes_cool = 'Low';  low cool vote for review refers to review_votes_cool = 'Low'
SQL: SELECT COUNT(DISTINCT T1.user_id) FROM Users AS T1 INNER JOIN Reviews AS T2 ON T1.user_id = T2.user_id WHERE T1.user_votes_cool = 'Low' AND T2.review_votes_cool = 'Low'

Database: sales_in_weather
Question: How many stores belong to the station with the highest recorded heat of all time?
Evidence: highest recorded heat refers to Max(heat); station refers to station_nbr
SQL: SELECT COUNT(T2.store_nbr) FROM ( SELECT station_nbr FROM weather ORDER BY heat DESC LIMIT 1 ) AS T1 INNER JOIN relation AS T2 ON T1.station_nbr = T2.station_nbr

Database: retail_world
Question: What is the most common product ordered by a customer from Germany?
Evidence: most common product refers to max(count(ProductID)); customer from Germany refers to Country = 'Germany'
SQL: SELECT T2.ProductID FROM Customers AS T1 INNER JOIN `Order Details` AS T2 WHERE T1.Country = 'Germany' GROUP BY T2.ProductID ORDER BY COUNT(T2.ProductID) DESC LIMIT 1

Database: movie_3
Question: What is Diane Collins' email address?
SQL: SELECT email FROM customer WHERE first_name = 'DIANE' AND last_name = 'COLLINS'

Database: language_corpus
Question: How many times that the word pair of "barcelona" and "precolombina" occur?
Evidence: Pair is a relationship of two words: w1st and w2nd, where w1st is word id of the first word and w2nd is a word id of the second word; w1st or w2nd = 'barcelona'; w1st or w2nd = 'precolombina';
SQL: SELECT SUM(occurrences) FROM biwords WHERE w1st = ( SELECT wid FROM words WHERE word = 'barcelona' ) AND w2nd = ( SELECT wid FROM words WHERE word = 'precolombina' )

Database: image_and_language
Question: List the ID of all images with objects that have multiple relations.
Evidence: ID of all images refer to IMG_ID; if two objects (OBJ1_SAMPLE_ID,
OBJ2_SAMPLE_ID) has
multiple PRED_CLASS_ID, it
means these two objects
have multiple relations;
SQL: SELECT IMG_ID FROM IMG_REL GROUP BY PRED_CLASS_ID HAVING COUNT(DISTINCT OBJ1_SAMPLE_ID) != 0 AND COUNT(DISTINCT OBJ2_SAMPLE_ID) != 0

Database: movie_3
Question: How long did Austin Cintron take to return the movie 'Destiny Saturday'?
Evidence: 'Destiny Saturday' refers to title = 'DESTINY SATURDAY'; length = subtract(return_date, rental_date)
SQL: SELECT T2.rental_date - T2.return_date FROM customer AS T1 INNER JOIN rental AS T2 ON T1.customer_id = T2.customer_id INNER JOIN inventory AS T3 ON T2.inventory_id = T3.inventory_id INNER JOIN film AS T4 ON T3.film_id = T4.film_id WHERE T1.first_name = 'AUSTIN' AND T4.title = 'DESTINY SATURDAY'

Database: sales_in_weather
Question: How many units of item no.9 were sold in store no.1 on 2012/1/1?
Evidence: store no. 1 refers to store_nbr = 1; item no. 9 refers to item_nbr = 9; on 2012/1/1 refers to date = '2012-01-01'
SQL: SELECT units FROM sales_in_weather WHERE `date` = '2012-01-01' AND store_nbr = 1 AND item_nbr = 9

Database: restaurant
Question: What restaurant on Drive Street in San Rafael doesn't serve American food?
Evidence: Drive Street refers to street_name = 'drive'; San Rafael refers to city = 'san rafael'; American food refers to food_type <> 'american'
SQL: SELECT T1.label FROM generalinfo AS T1 INNER JOIN location AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T2.street_name = 'drive' AND T1.food_type != 'american' AND T2.city = 'san rafael'

Database: student_loan
Question: Name all students enlisted in the foreign legion.
Evidence: in the foreign legion organ = 'foreign_legion';
SQL: SELECT name FROM enlist WHERE organ = 'foreign_legion'

Database: ice_hockey_draft
Question: Name the player who had the most goals for team Rimouski Oceanic in playoff.
Evidence: name of the player refers to PlayerName; most goals refers to MAX(G); team Rimouski Oceanic refers to TEAM = 'Rimouski Oceanic'; playoff refers to GAMETYPE = 'Playoffs';
SQL: SELECT T1.PlayerName FROM PlayerInfo AS T1 INNER JOIN SeasonStatus AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.TEAM = 'Rimouski Oceanic' AND T2.GAMETYPE = 'Playoffs' ORDER BY T2.G DESC LIMIT 1

Database: talkingdata
Question: How many users in user group M23-26 use a vivo device?
Evidence: user group M23-26 refers to group = 'M23-26'; vivo device refers to phone_brand = 'vivo';
SQL: SELECT COUNT(T2.device_id) FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.`group` = 'M23-26' AND T2.phone_brand = 'vivo'

Database: retails
Question: On which date was the part "burnished seashell gainsboro navajo chocolate" in order no.1 shipped?
Evidence: date refers to l_shipdate; part "burnished seashell gainsboro navajo chocolate" refers to p_name = 'burnished seashell gainsboro navajo chocolate'; order no.1 refers to l_orderkey = 1
SQL: SELECT T1.l_shipdate FROM lineitem AS T1 INNER JOIN part AS T2 ON T1.l_partkey = T2.p_partkey WHERE T1.l_orderkey = 1 AND T2.p_name = 'burnished seashell gainsboro navajo chocolate'

Database: public_review_platform
Question: For businesses with long length reviews, which state are they located?
Evidence: businesses with long length tips refer to business_id where tip_length = 'Long';
SQL: SELECT DISTINCT T1.state FROM Business AS T1 INNER JOIN Tips AS T2 ON T1.business_id = T2.business_id WHERE T2.tip_length = 'Long'