Database: public_review_platform
Question: How many businesses operating in the "Accessories" category have received a "wonderful experience" review from users?
Evidence: Accessories category refers to category_name = 'Accessories'; wonderful experience review refers to stars > 3;
SQL: SELECT COUNT(T2.business_id) FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Business AS T3 ON T2.business_id = T3.business_id WHERE T3.stars > 3 AND T1.category_name LIKE 'Accessories'

Database: restaurant
Question: List down the cities with unknown country.
Evidence: unknown county refers to county = 'unknown'
SQL: SELECT city FROM geographic WHERE county = 'unknown'

Database: student_loan
Question: Sum up the number of students enlisted in foreign legion, peace corps and army.
Evidence: enlisted in foreign legion refers to organ = 'foreign_legion'; peace corps refers to organ = 'peace_corps'; army refers to organ = 'army'
SQL: SELECT COUNT(name) FROM enlist WHERE organ IN ('army', 'peace_corps', 'foreign_legion')

Database: public_review_platform
Question: Among the businesses which have short length of review, which one located in Phoenix?
Evidence: short length of review refers to review_length = 'Short'; in Phoenix refers to city = 'Phoenix'
SQL: SELECT DISTINCT T1.business_id FROM Business AS T1 INNER JOIN Reviews AS T2 ON T1.business_id = T2.business_id WHERE T1.city = 'Phoenix' AND T2.review_length = 'Short'

Database: synthea
Question: Indicate the patient's full name with the lowest body mass index in kg/m2.
Evidence: full name refers to first, last; the lowest body mass index in kg/m2 refers to DESCRIPTION = Body Mass Index from observations where MIN(VALUE) and UNITS = 'kg/m2';
SQL: SELECT T1.first, T1.last FROM patients AS T1 INNER JOIN observations AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Body Mass Index' AND T2.UNITS = 'kg/m2' ORDER BY T2.VALUE LIMIT 1

Database: talkingdata
Question: How many devices are of the brand vivo?
Evidence: brand vivo refers to phone_brand = 'vivo';
SQL: SELECT COUNT(device_id) FROM phone_brand_device_model2 WHERE phone_brand = 'vivo'

Database: shakespeare
Question: How many scenes are there in the 5th act of "History of Henry VIII"?
Evidence: 5th act refers to Act = 5; "History of Henry VIII" refers to LongTitle = 'History of Henry VIII'
SQL: SELECT SUM(T2.Scene) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T2.Act = 5 AND T1.LongTitle = 'History of Henry VIII'

Database: movies_4
Question: Which movie did the company 'Radiant Film GmbH' work on?
Evidence: Which movie refers to title; company 'Radiant Film GmbH' refers to company_name = 'Radiant Film GmbH'
SQL: SELECT T3.title FROM production_company AS T1 INNER JOIN movie_company AS T2 ON T1.company_id = T2.company_id INNER JOIN movie AS T3 ON T2.movie_id = T3.movie_id WHERE T1.company_name = 'Radiant Film GmbH'

Database: donor
Question: When did the project "Photojournalists Want to Exhibit Their Best Works" go live?
Evidence: project "Photojournalists Want to Exhibit Their Best Works" refers to title = 'Photojournalists Want to Exhibit Their Best Works'; when project go live refers to datePosted
SQL: SELECT T1.date_posted FROM projects AS T1 INNER JOIN essays AS T2 ON T1.projectid = T2.projectid WHERE T2.title LIKE 'Photojournalists Want to Exhibit Their Best Works'

Database: bike_share_1
Question: Among the rides during the rainy days, which ride was the longest? List the start station, end station, and duration of this ride.
Evidence: rainy days refers to events = 'rain'; longest ride refers to MAX(duration); start station refers to start_station_name; end station refers to end_station_name; duration of the ride refers to duration;
SQL: SELECT T1.start_station_name, T1.end_station_name, T1.duration FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE T2.events = 'Rain' OR T2.events = 'rain' ORDER BY T1.duration DESC LIMIT 1

Database: shakespeare
Question: How many acts are there in Sonnets?
Evidence: Sonnets refers to Title = 'Sonnets'
SQL: SELECT SUM(DISTINCT T2.Act) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T1.Title = 'Sonnets'

Database: ice_hockey_draft
Question: What is the BMI of David Bornhammar?
Evidence: BMI = DIVIDE(weight_in_kg, power(DIVIDE(height_in_cm, 100), 2));
SQL: SELECT CAST(T2.weight_in_kg AS REAL) / (CAST(T3.height_in_cm AS REAL) / 100 * (CAST(T3.height_in_cm AS REAL) / 100)) FROM PlayerInfo AS T1 INNER JOIN weight_info AS T2 ON T1.weight = T2.weight_id INNER JOIN height_info AS T3 ON T1.height = T3.height_id WHERE T1.PlayerName = 'David Bornhammar'

Database: language_corpus
Question: What is the word pair that occured the highest amount of times in Addicio? Indicate how many times such word pair occured.
Evidence: word pair refers to w1st.word w2nd.word; occurred the highest amount of times refers to max(occurrences); Addicio refers to title = 'Addicio'; times occurred refer to occurrences
SQL: SELECT T3.w1st, T3.w2nd, T3.occurrences FROM pages AS T1 INNER JOIN pages_words AS T2 ON T1.pid = T2.pid INNER JOIN biwords AS T3 ON T2.wid = T3.w1st OR T2.wid = T3.w2nd WHERE T1.title = 'Addicio' ORDER BY T3.occurrences DESC LIMIT 1

Database: public_review_platform
Question: What is the correlation between the review starts and business stars?
Evidence: highest review count refers to review_count = 'Uber'; average business review stars = Divide (Sum(review_stars), Count(user_id))
SQL: SELECT CAST(SUM(T2.review_stars) AS REAL) / COUNT(T1.business_id) FROM Business AS T1 INNER JOIN Reviews AS T2 ON T1.business_id = T2.business_id

Database: cars
Question: Give the model year of the heaviest car.
Evidence: the heaviest refers to max(weight)
SQL: SELECT T2.model_year FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID ORDER BY T1.weight DESC LIMIT 1

Database: university
Question: What is the ID of the university with the most students in 2011?
Evidence: in 2011 refers to year 2011; with the most students refers to MAX(num_students); ID of the university refers to university_id
SQL: SELECT university_id FROM university_year WHERE year = 2011 ORDER BY num_students DESC LIMIT 1

Database: cs_semester
Question: For the professors who advise more than 2 students, which professor has a higher teaching ability? Give the full name.
Evidence: professor advising more than 2 students refers to COUNT(student_id) > 2; higher teachability refers to MAX(teachingability); full name refers to f_name and l_name;
SQL: SELECT T.first_name, T.last_name FROM ( SELECT T2.first_name, T2.last_name, T2.teachingability FROM RA AS T1 INNER JOIN prof AS T2 ON T1.prof_id = T2.prof_id GROUP BY T1.prof_id HAVING COUNT(student_id) > 2 ) T ORDER BY T.teachingability DESC LIMIT 1

Database: talkingdata
Question: Provide the locations and times of the events of app ID "8715964299802120000".
Evidence: locations = longitude, latitude; times of the events refers to timestamp;
SQL: SELECT T1.longitude, T1.latitude, T1.timestamp FROM events AS T1 INNER JOIN app_events AS T2 ON T1.event_id = T2.event_id WHERE T2.app_id = 8715964299802120000

Database: soccer_2016
Question: Among the South African players, how many were born before 4/11/1980?
Evidence: South African players refers to Country_Name = 'South Africa'; born before 4/11/1980 refers to DOB < '1980-4-11'
SQL: SELECT SUM(CASE WHEN T1.DOB < '1980-4-11' THEN 1 ELSE 0 END) FROM Player AS T1 INNER JOIN Country AS T2 ON T1.Country_Name = T2.Country_Id WHERE T2.Country_Name = 'South Africa'

Database: restaurant
Question: Among the restaurants on street number below 1000, how many of them are in Railroad St.?
Evidence: street number below 1000 refers to street_num < 1000; Railroad St. refers to street_name = 'railroad'
SQL: SELECT COUNT(city) FROM location WHERE street_name = 'railroad' AND street_num < 1000