Database: coinmarketcap
Question: For all transactions for WRAP in August 2016, list the time to achieve highest price and the time to achieve the lowest price.
Evidence: in May 2013 refers to month(date) = 5 AND year(date) = 2013; time to achieve the highest price refers to time_high; time to achieve the lowest price refers to time_low; WRAP refers to name = 'WARP'
SQL: SELECT T2.time_high, T2.time_low, T2.date FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T1.name = 'WARP' AND STRFTIME('%Y-%m', T2.date) = '2016-08'

Database: social_media
Question: Give the name of the city of the user who tweeted `One of our favorite stories is @FINRA_News's move to the cloud with AWS Enterprise Support! https://amp.twimg.com/v/991837f1-4815-4edc-a88f-e68ded09a02a`.
Evidence: "One of our favorite stories is @FINRA_News's move to the cloud with AWS Enterprise Support! https://amp.twimg.com/v/991837f1-4815-4edc-a88f-e68ded09a02a" is the text
SQL: SELECT T2.City FROM twitter AS T1 INNER JOIN location AS T2 ON T2.LocationID = T1.LocationID WHERE T1.text = 'One of our favorite stories is @FINRA_News''s move to the cloud with AWS Enterprise Support! https://amp.twimg.com/v/991837f1-4815-4edc-a88f-e68ded09a02a'

Database: movielens
Question: What is the most distinct rated movie with a running time of 0?
SQL: SELECT DISTINCT T1.movieid FROM movies AS T1 INNER JOIN u2base AS T2 ON T1.movieid = T2.movieid WHERE T1.runningtime = 0 AND T2.rating = ( SELECT MAX(rating) FROM u2base )

Database: movie_3
Question: How many films are in English?
Evidence: "English" is the name of language
SQL: SELECT COUNT(T1.film_id) FROM film AS T1 INNER JOIN language AS T2 ON T1.language_id = T2.language_id WHERE T2.name = 'English'

Database: bike_share_1
Question: What was the hottest temperature on the day of trip ID 4080?
Evidence: the hottest temperature refers to max_temperature_f;
SQL: SELECT MAX(T2.max_temperature_f) FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code AND T2.date = SUBSTR(CAST(T1.start_date AS TEXT), 1, INSTR(T1.start_date, ' ') - 1) WHERE T1.id = 4080

Database: synthea
Question: What is the glucose level of the patient that lives at 365 Della Crossroad Suite 202, Deerfield, MA 01342 US?
Evidence: glucose level refers to VALUE, UNITS where DESCRIPTION = 'Glucose' from observations; lives at 365 Della Crossroad Suite 202, Deerfield, MA 01342 US refers to address = '365 Della Crossroad Suite 202 Deerfield MA 01342 US';
SQL: SELECT DISTINCT T2.DESCRIPTION, T2.VALUE, T2.UNITS FROM patients AS T1 INNER JOIN observations AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Glucose' AND T1.address = '365 Della Crossroad Suite 202 Deerfield MA 01342 US'

Database: donor
Question: What is the name of the item that is provided in the biggest amount by the vendor Lakeshore Learning Materials?
Evidence: lakeshore Learning Materials is vendor_name; biggest amount refers to Max(item_quantity);
SQL: SELECT item_name FROM resources WHERE vendor_name = 'Lakeshore Learning Materials' ORDER BY item_quantity DESC LIMIT 1

Database: public_review_platform
Question: How many businesses are with high review count?
Evidence: high review count refers to review_count = 'High'
SQL: SELECT COUNT(business_id) FROM Business WHERE review_count LIKE 'High'

Database: retail_world
Question: How many suppliers are there in the United States of America?
Evidence: United States of America refers to Country = 'USA'
SQL: SELECT COUNT(SupplierID) FROM Suppliers WHERE Country = 'USA'

Database: soccer_2016
Question: Calculate the percentage of left hand batting style players among all players.
Evidence: left hand batting style players refers to Batting_hand = 'Left-hand bat'; percentage refers to DIVIDE(COUNT(Batting_hand = 'Left-hand bat'), COUNT(Player_Id)) * 100.0
SQL: SELECT CAST(SUM(CASE WHEN T2.Batting_hand = 'Left-hand bat' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.Player_Id) FROM Player AS T1 INNER JOIN Batting_Style AS T2 ON T1.Batting_hand = T2.Batting_Id

Database: retails
Question: Calculate the difference in the average number of low-priority orders shipped by truck in each month of 1995 and 1996.
Evidence: SUBTRACT(DIVIDE(SUM(l_orderkey where year(l_shipdate) = 1995), 12), DIVIDE(SUM(l_orderkey where year(l_shipdate) = 1996), 12)) where o_orderpriority = '5-LOW';
SQL: SELECT (CAST(SUM(IIF(STRFTIME('%Y', T2.l_shipdate) = 1995, 1, 0)) AS REAL) / 12) - (CAST(SUM(IIF(STRFTIME('%Y', T2.l_shipdate) = 1996, 1, 0)) AS REAL) / 12) FROM orders AS T1 INNER JOIN lineitem AS T2 ON T1.o_orderkey = T2.l_orderkey WHERE T1.o_orderpriority = '5-LOW' AND T2.l_shipmode = 'TRUCK'

Database: restaurant
Question: Among the bakeries, what is total number of bakery located at University Avenue, Palo Alto?
Evidence: bakery refers to food_type = 'bakery'; University Avenue refers to street_name = 'university ave.'; Palo Alto refers to city = 'palo alto'
SQL: SELECT COUNT(T1.id_restaurant) FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T2.food_type = 'bakery' AND T2.city = 'palo alto' AND T1.street_name = 'university ave.'

Database: movie_3
Question: Give the number of documentary films.
Evidence: "Documentary" is the name of category; number of film refers to Count(film_id)
SQL: SELECT COUNT(T1.film_id) FROM film_category AS T1 INNER JOIN category AS T2 ON T1.category_id = T2.category_id WHERE T2.name = 'Documentary'

Database: retails
Question: What is the name of the supplier that provides the part "hot spring dodger dim light" with the lowest supply cost?
Evidence: supplier name refers to s_name; part "hot spring dodger dim light" refers to p_name = 'hot spring dodger dim light'; the lowest supply cost refers to min(ps_supplycost)
SQL: SELECT T2.s_name FROM partsupp AS T1 INNER JOIN supplier AS T2 ON T1.ps_suppkey = T2.s_suppkey INNER JOIN part AS T3 ON T1.ps_partkey = T3.p_partkey WHERE T3.p_name = 'hot spring dodger dim light' ORDER BY T1.ps_supplycost LIMIT 1

Database: menu
Question: Provide the numbers of the menu item which includes Fresh lobsters in every style and location where that dish was used on a menu.
Evidence: Fresh lobsters in every style' is a name of dish; location where the dish was used on a menu = (xpos, ypos);
SQL: SELECT T2.menu_id, T1.xpos, T1.ypos FROM MenuItem AS T1 INNER JOIN MenuPage AS T2 ON T1.menu_page_id = T2.id INNER JOIN Menu AS T3 ON T2.menu_id = T3.id INNER JOIN Dish AS T4 ON T1.dish_id = T4.id WHERE T4.name = 'Fresh lobsters in every style'

Database: address
Question: Provide the names of bad aliases in the city of Aguadilla.
SQL: SELECT T1.bad_alias FROM avoid AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.city = 'Aguadilla'

Database: books
Question: What is the most expensive price paid by a customer for the book "Bite Me If You Can (Argeneau #6)"?
Evidence: "Bite Me If You Can (Argeneau #6)" is the title of the book; most expensive price refers to Max(price)
SQL: SELECT MAX(T2.price) FROM book AS T1 INNER JOIN order_line AS T2 ON T1.book_id = T2.book_id WHERE T1.title = 'Bite Me If You Can (Argeneau #6)'

Database: movie_3
Question: List the name of the films that can only be found in store id 2.
Evidence: name of film refers to title
SQL: SELECT T1.title FROM film AS T1 INNER JOIN inventory AS T2 ON T1.film_id = T2.film_id WHERE T2.store_id = 2

Database: public_review_platform
Question: What is the quantity of the closed or not running Yelp Businesses in 'AZ'?
Evidence: closed or not running refers to active = 'False'; AZ refers to state = 'AZ';
SQL: SELECT COUNT(business_id) FROM Business WHERE state LIKE 'AZ' AND active LIKE 'False'