Database: cars
Question: Please list the names of all the car models whose origin country is the USA.
Evidence: name of car model refers to car_name; origin country is the USA refers to country = 'USA'
SQL: SELECT DISTINCT T1.car_name FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T2.country = T3.origin WHERE T3.country = 'USA'

Database: bike_share_1
Question: Which trip id had the longest duration and the start station is in Redwood City?
Evidence: longest duration refers to MAX(duration); start station refers to start_station_name;
SQL: SELECT T1.id FROM trip AS T1 LEFT JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T2.city = 'Redwood City' AND T1.duration = ( SELECT MAX(T1.duration) FROM trip AS T1 LEFT JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T2.city = 'Redwood City' )

Database: image_and_language
Question: State the explanation about object class 10.
Evidence: explanation about object class 10 refers to OBJ_CLASS where OBJ_CLASS_ID = 10;
SQL: SELECT OBJ_CLASS FROM OBJ_CLASSES WHERE OBJ_CLASS_ID = 10

Database: codebase_comments
Question: What is the percentage of respositories that receive more than 2,000 stars?
Evidence: stars>2000; percentage = DIVIDE(MULTIPLY(COUNT(Stars>2000), 100), COUNT(Id));
SQL: SELECT CAST(SUM(CASE WHEN Stars > 2000 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(Stars) FROM Repo

Database: sales
Question: List the product ID of the top five products, by descending order, in terms of price.
Evidence: top 5 products in terms of Price refers to MAX(Price) LIMIT 5;
SQL: SELECT ProductID FROM Products ORDER BY Price DESC LIMIT 5

Database: bike_share_1
Question: Among the bike trips started on the days with a fog in 2013, how many of those trips started from the station "2nd at Townsend"?
Evidence: started on the days with a fog refers to start_date where events = 'fog'; in 2013 refers to date LIKE '%2013'; started from station refers to start_station_name; start_station_name = '2nd at Townsend';
SQL: SELECT COUNT(T1.start_station_name) FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE T2.date LIKE '%2013%' AND T2.events = 'Fog' AND T1.start_station_name = '2nd at Townsend' AND T2.zip_code = 94107

Database: movie_platform
Question: Who gave a "4" rating to the movie "Freaks" at 2013/5/4 6:33:32? Give his/her user id.
Evidence: 4 rating refers to rating_score = 4; the movie "Freaks" refers to movie_title = 'Freaks' ; at 2013/5/4 6:33:32 refers to rating_timestamp_utc = '2013-05-04 06:33:32'
SQL: SELECT T1.user_id FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE rating_score = 4 AND rating_timestamp_utc LIKE '2013-05-04 06:33:32' AND T2.movie_title LIKE 'Freaks'

Database: talkingdata
Question: On what date were the most events logged on devices for 40-year-old male users?
Evidence: date refers to timestamp; most events refers to MAX(COUNT(event_id)); 40-year-old  refers to age = 40; male refers to gender = 'M';
SQL: SELECT T.timestamp FROM ( SELECT T2.timestamp, COUNT(T2.event_id) AS num FROM gender_age AS T1 INNER JOIN events_relevant AS T2 ON T1.device_id = T2.device_id WHERE T1.gender = 'M' AND T1.age = 40 GROUP BY T2.timestamp ) AS T ORDER BY T.num DESC LIMIT 1

Database: movie_platform
Question: Show the portrait picture of the user who created the list "Vladimir Vladimirovich Nabokov".
Evidence: the list "Vladimir Vladimirovich Nabokov" refers to list_title = 'Vladimir Vladimirovich Nabokov'; portrait picture refers to user_avatar_image_url
SQL: SELECT T1.user_avatar_image_url FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id WHERE T2.list_title LIKE 'Vladimir Vladimirovich Nabokov'

Database: menu
Question: How many menus were created for lunch?
Evidence: created for lunch refers to event = 'LUNCH';
SQL: SELECT COUNT(*) FROM Menu WHERE event = 'LUNCH'

Database: music_platform_2
Question: State the podcast title, content review and rating for all reviews with titled 'Love it!'
Evidence: "Love it!" is the title of review; content reviewed refers to content
SQL: SELECT DISTINCT T1.title, T2.content, T2.rating FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T2.title = 'Love it!'

Database: chicago_crime
Question: Please list the blocks where all the incidents in the district commanded by Robert A. Rubio took place.
Evidence: "Robert A. Rubio" is the commander
SQL: SELECT T2.block FROM District AS T1 INNER JOIN Crime AS T2 ON T1.district_no = T2.district_no WHERE T1.commander = 'Robert A. Rubio'

Database: authors
Question: What was the topic of the article "A Formal Approach to Service Component Architecture" and when was it published?
Evidence: article "A Formal Approach to Service Component Architecture" refers to Title = 'A Formal Approach to Service Component Architecture'; topic of the article refers to Keyword
SQL: SELECT Keyword, Year FROM Paper WHERE Title = 'A Formal Approach to Service Component Architecture'

Database: retail_world
Question: Calculate the total production for each product which were supplied from Japan
Evidence: from Japan refers to Country = 'Japan'; total production refers to ADD(UnitsInstock, UnitsOnOrder)
SQL: SELECT SUM(T1.UnitsInStock + T1.UnitsOnOrder) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.Country = 'Japan'

Database: books
Question: Name the streets in Dallas.
Evidence: "Dallas" is the city; streets refers to street_name
SQL: SELECT street_name FROM address WHERE city = 'Dallas'

Database: synthea
Question: What is the difference between the number of married patients and the number of single patients with diabetes?
Evidence: difference = SUBTRACT(patients.patient WHERE marital = 'M'), COUNT(patients.patient WHERE marital = 'S') WHERE conditions.DESCRIPTION = 'Diabetes'); married patients refers to marital = 'M'; single patients refers to marital = 'S'; diabetes refers to conditions.DESCRIPTION = 'Diabetes';
SQL: SELECT SUM(CASE WHEN T2.marital = 'M' THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.marital = 'S' THEN 1 ELSE 0 END) FROM conditions AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T1.DESCRIPTION = 'Diabetes'

Database: student_loan
Question: Which male students are unemployed, disable and were absent for 5 month?
Evidence: male students are mentioned in male.name; unemployed and disabled refers to unemployed.name = disabled.name; absent for 5 month refers to month = 5;
SQL: SELECT T1.name FROM unemployed AS T1 INNER JOIN disabled AS T2 ON T2.name = T1.name INNER JOIN longest_absense_from_school AS T3 ON T3.name = T2.name WHERE T3.month = 5

Database: public_review_platform
Question: How many "cool" type compliments does user No. 41717 get?
Evidence: "cool" type compliments refers to compliment_type = 'cool'; user No. 41717 refers to user_id = 41717
SQL: SELECT COUNT(T2.number_of_compliments) FROM Compliments AS T1 INNER JOIN Users_Compliments AS T2 ON T1.compliment_id = T2.compliment_id WHERE T1.compliment_type = 'cool' AND T2.user_id = 41717

Database: retail_world
Question: Among the supplied products from Australia, describe the discontinued products and the category.
Evidence: from Australia refers to Country = 'Australia'; discontinued products refers to Discontinued = 1;
SQL: SELECT T2.ProductName, T3.CategoryName FROM Suppliers AS T1 INNER JOIN Products AS T2 ON T1.SupplierID = T2.SupplierID INNER JOIN Categories AS T3 ON T2.CategoryID = T3.CategoryID WHERE T1.Country = 'Australia' AND T2.Discontinued = 1

Database: address
Question: How many counties are there in Alabama?
Evidence: "Alabama" is the name
SQL: SELECT COUNT(T2.county) FROM state AS T1 INNER JOIN country AS T2 ON T1.abbreviation = T2.state WHERE T1.name = 'Alabama'