Database: sales_in_weather
Question: What are the items sold by the store during the day whose station recorded the thickest snowfall?
Evidence: thickest snowfall refers to Max(snowfall); item refers to item_nbr
SQL: SELECT T1.item_nbr FROM sales_in_weather AS T1 INNER JOIN relation AS T2 ON T1.store_nbr = T2.store_nbr INNER JOIN ( SELECT station_nbr, `date` FROM weather ORDER BY snowfall DESC LIMIT 1 ) AS T3 ON T2.station_nbr = T3.station_nbr

Database: professional_basketball
Question: How many players, in games played in 1990, achieved 50% or less of oRebounds than dRebounds.
Evidence: in 1990 refers to season_id = 1990; 50% or less of oRebounds than dRebounds refers to o_rebounds < = multiply(d_rebounds, 0.5)
SQL: SELECT COUNT(playerID) FROM players_teams WHERE CAST(oRebounds AS REAL) * 100 / dRebounds <= 50 AND year = 1990

Database: student_loan
Question: Please list the names of the male students that belong to the navy department.
Evidence: belong to the navy department refers to organ = 'navy';
SQL: SELECT T1.name FROM enlist AS T1 INNER JOIN male AS T2 ON T1.`name` = T2.`name` WHERE T1.organ = 'navy'

Database: synthea
Question: Describe the encounter of Mr. Hubert Baumbach on 2008/10/25.
Evidence: encounter refers to DESCRIPTION from encounters; on 2008/10/25 refers to DATE = '2008-10-25';
SQL: SELECT T2.description FROM patients AS T1 INNER JOIN encounters AS T2 ON T1.patient = T2.PATIENT WHERE T1.prefix = 'Mr.' AND T1.first = 'Hubert' AND T1.last = 'Baumbach' AND T2.date = '2008-10-25'

Database: retails
Question: What is the phone number of Customer#000000001?
Evidence: customer phone refers to c_phone; Customer#000000001 refers to c_name;
SQL: SELECT c_phone FROM customer WHERE c_name = 'Customer#000000001'

Database: shipping
Question: Among the shipments in 2017, how many of them have the destination in New Jersey?
Evidence: in 2017 refers to Cast(ship_date AS DATE) = 2017; 'New Jersey' is the state
SQL: SELECT COUNT(*) FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id WHERE STRFTIME('%Y', T1.ship_date) = '2017' AND T2.state = 'New Jersey'

Database: music_platform_2
Question: What is the least common category?
Evidence: least common category refers to Min(Count(category))
SQL: SELECT category FROM categories GROUP BY category ORDER BY COUNT(podcast_id) ASC LIMIT 1

Database: airline
Question: Provide the name of the airport which landed the most number of flights on 2018/8/15.
Evidence: name of the airport refers to Description; airport that landed the most number of flights refers to MAX(COUNT(DEST)); on 2018/8/15 refers to FL_DATE = '2018/8/15';
SQL: SELECT T1.Description FROM Airports AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.DEST WHERE T2.FL_DATE = '2018/8/15' ORDER BY T2.DEST DESC LIMIT 1

Database: donor
Question: List all the items from "Sax Arts & Crafts" and the zip code of the schools that received them.
Evidence: from "Sax Arts & Crafts" refers to vendor_name = 'Sax Arts & Crafts'; zip code of the schools refers school_zip
SQL: SELECT T2.school_zip, T1.item_name FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.vendor_name = 'Sax Arts & Crafts'

Database: restaurant
Question: How many American food restaurants are unpopular in Carmel?
Evidence: American Food Restaurant refers to food_type = 'ameraican'; unpopular refers to min(review); Carmel refers to city = 'Carmel'
SQL: SELECT COUNT(id_restaurant) FROM generalinfo WHERE food_type = 'american' AND city = 'carmel' AND review = ( SELECT MIN(review) FROM generalinfo WHERE food_type = 'american' AND city = 'carmel' )

Database: airline
Question: Give the number of planes that took off from Los Angeles International airport on 2018/8/27.
Evidence: took off from refers to ORIGIN; Los Angeles International airport refers to Description = 'Los Angeles, CA: Los Angeles International'; on 2018/8/27 refers to FL_DATE = '2018/8/27';
SQL: SELECT SUM(CASE WHEN T2.FL_DATE = '2018/8/27' THEN 1 ELSE 0 END) AS count FROM Airports AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.ORIGIN WHERE T1.Description = 'Los Angeles, CA: Los Angeles International'

Database: retail_complains
Question: What is the full name of the client whose complaint on 2017/3/27 was received by MICHAL?
Evidence: full names = first, middle, last; on 2017/3/27 refers to "Date received" = '2017-03-27'; MICHAL refers to server = 'MICHAL';
SQL: SELECT T1.first, T1.middle, T1.last FROM client AS T1 INNER JOIN callcenterlogs AS T2 ON T1.client_id = T2.`rand client` WHERE T2.`Date received` = '2017-03-27' AND T2.server = 'MICHAL'

Database: movie_3
Question: How much in total had the customers in Italy spent on film rentals?
Evidence: total = sum(amount); Italy refers to country = 'Italy'
SQL: SELECT SUM(T5.amount) FROM address AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id INNER JOIN country AS T3 ON T2.country_id = T3.country_id INNER JOIN customer AS T4 ON T1.address_id = T4.address_id INNER JOIN payment AS T5 ON T4.customer_id = T5.customer_id WHERE T3.country = 'Italy'

Database: coinmarketcap
Question: When is the highest price of Terracoin?
Evidence: when refers to date; the highest price refers to max(price)
SQL: SELECT T2.date FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T1.name = 'Terracoin' ORDER BY T2.price DESC LIMIT 1

Database: app_store
Question: What is the average rating of Apps falling under the racing genre and what is the percentage ratio of positive sentiment reviews?
Evidence: average rating = AVG(Rating); percentage = MULTIPLY(DIVIDE((SUM(Sentiment = 'Positive')), (COUNT(*)), 100));
SQL: SELECT AVG(T1.Rating), CAST(COUNT(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.Sentiment) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Racing'

Database: movie_3
Question: What is the full name of the customer who rented movies for 7 consecutive days?
Evidence: rented for 7 consecutive days refers to Subtract(return_date, rental_date) = 7; full name refers to first_name, last_name
SQL: SELECT T1.first_name, T1.last_name FROM customer AS T1 INNER JOIN ( SELECT customer_id, COUNT(*) AS num_days FROM ( SELECT *, date(days, '-' || rn || ' day') AS results FROM ( SELECT customer_id, days, row_number() OVER (PARTITION BY customer_id ORDER BY days) AS rn FROM ( SELECT DISTINCT customer_id, date(rental_date) AS days FROM rental ) ) ) GROUP BY customer_id, results HAVING num_days = 7 ) AS T2 ON T1.customer_id = T2.customer_id

Database: car_retails
Question: What is the highest amount of order made by the sales representative in Boston? Please give the name of the product and amount.
Evidence: Boston is a city; amount of order = MULTIPLY(quantityOrdered, priceEach);
SQL: SELECT T2.productName, T1.quantityOrdered * T1.priceEach FROM orderdetails AS T1 INNER JOIN products AS T2 ON T1.productCode = T2.productCode INNER JOIN orders AS T3 ON T1.orderNumber = T3.orderNumber INNER JOIN customers AS T4 ON T3.customerNumber = T4.customerNumber WHERE T4.city = 'Boston' AND T4.salesRepEmployeeNumber IN ( SELECT employeeNumber FROM employees WHERE jobTitle = 'Sales Rep' ) ORDER BY T1.quantityOrdered DESC LIMIT 1

Database: shipping
Question: What is the average annual revenue of customers who have shipment weight of less than 65000 pounds?
Evidence: weight of less than 65000 pounds refers to weight < 65000; average annual revenue refers to AVG(annual_revenue)
SQL: SELECT AVG(T1.annual_revenue) FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id WHERE T2.weight < 65000

Database: movie_3
Question: What is the address of Mary Smith?
SQL: SELECT T1.address FROM address AS T1 INNER JOIN customer AS T2 ON T1.address_id = T2.address_id WHERE T2.first_name = 'MARY' AND T2.last_name = 'SMITH'