Database: image_and_language
Question: How many prediction classes with "has" captions are there for image id 3050?
Evidence: prediction classes with "has" captions refers to PRED_CLASS = 'has'; image id 3050 refers to IMG_ID = 3050
SQL: SELECT COUNT(T2.PRED_CLASS_ID) FROM IMG_REL AS T1 INNER JOIN PRED_CLASSES AS T2 ON T1.PRED_CLASS_ID = T2.PRED_CLASS_ID WHERE T1.IMG_ID = 3050 AND T2.PRED_CLASS = 'has'

Database: synthea
Question: The highest Systolic Blood Pressure was observed in which patient? Please give his or her full name.
Evidence: the highest Systolic Blood Pressure refers to MAX(DESCRIPTION = 'Systolic Blood Pressure') from observations; full name refers to first, last;
SQL: SELECT T1.first, T1.last FROM patients AS T1 INNER JOIN observations AS T2 ON T1.patient = T2.PATIENT WHERE T2.VALUE = ( SELECT MAX(VALUE) FROM observations WHERE description = 'Systolic Blood Pressure' ) LIMIT 1

Database: shakespeare
Question: How many paragraphs are there in the longest chapter where Sir Richard Ratcliff appeared?
Evidence: longest chapter refers to max(ParagraphNum); Sir Richard Ratcliff  refers to CharName = 'Sir Richard Ratcliff'
SQL: SELECT MAX(T2.ParagraphNum) FROM characters AS T1 INNER JOIN paragraphs AS T2 ON T1.id = T2.character_id WHERE T1.CharName = 'Sir Richard Ratcliff'

Database: image_and_language
Question: How many images have at least 5 "black" classes?
Evidence: images refers to IMG_ID; have at least 5 "black" classes refers to count(ATT_CLASS_ID) where ATT_CLASS = 'black' > = 5
SQL: SELECT COUNT(IMGID) FROM ( SELECT T1.IMG_ID AS IMGID FROM IMG_OBJ_att AS T1 INNER JOIN ATT_CLASSES AS T2 ON T1.ATT_CLASS_ID = T2.ATT_CLASS_ID WHERE T2.ATT_CLASS = 'black' GROUP BY T1.IMG_ID HAVING COUNT(T1.ATT_CLASS_ID) >= 5 ) T3

Database: world_development_indicators
Question: In which years does the country whose Alpha2Code is 1A have a result of the indicator Adolescent fertility rate?
Evidence: indicator Adolescent fertility rate refers to IndicatorName = 'Adolescent fertility rate (births per 1,000 women ages 15-19)'


SQL: SELECT T2.Year FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.Alpha2Code = '1A' AND T2.IndicatorName = 'Adolescent fertility rate (births per 1,000 women ages 15-19)'

Database: ice_hockey_draft
Question: How many players weigh more than 90 kg?
Evidence: weigh more than 90 kg refers to weight_in_kg > 90;
SQL: SELECT COUNT(T1.ELITEID) FROM PlayerInfo AS T1 INNER JOIN weight_info AS T2 ON T1.weight = T2.weight_id WHERE T2.weight_in_kg > 90

Database: simpson_episodes
Question: What is the name of actor who took the role Smithers?
Evidence: name refers to person; the role Smithers refers to character = 'Smithers'
SQL: SELECT DISTINCT T1.person FROM Award AS T1 INNER JOIN Character_Award AS T2 ON T1.award_id = T2.award_id WHERE T2.character = 'Smithers';

Database: movie_3
Question: What is the language of the film ACADEMY DINOSAUR?
Evidence: "ACADEMY DINOSAUR" is the title of film; language refers to language.name
SQL: SELECT T2.name FROM film AS T1 INNER JOIN language AS T2 ON T1.language_id = T2.language_id WHERE T1.title = 'ACADEMY DINOSAUR'

Database: student_loan
Question: Is student281 disabled and which school is the student enrolled in?
SQL: SELECT T2.name, T1.school FROM enrolled AS T1 INNER JOIN disabled AS T2 ON T1.`name` = T2.`name` WHERE T1.name = 'student281'

Database: language_corpus
Question: What percentage of Catalan-language Wikipedia pages have more than 10,000 words?
Evidence: Catalan-language refers to lang = 'ca'; more than 10,000 words refer to words > 10000; DIVIDE(COUNT(pages WHERE words > 10000 and lang = 'ca'), COUNT(pages WHERE lang = 'ca')) as percentage;
SQL: SELECT CAST(COUNT(CASE WHEN T2.words > 10000 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.page) FROM langs AS T1 INNER JOIN pages AS T2 ON T1.lid = T2.lid WHERE T1.lang = 'ca'

Database: human_resources
Question: Please list the full names of the employees who are working as a Trainee.
Evidence: full name = firstname, lastname; trainees is a position title
SQL: SELECT T1.firstname, T1.lastname FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T2.positiontitle = 'Trainee'

Database: bike_share_1
Question: How many subscribers have ended their trip at MLK Library and how many docks does that station have?
Evidence: subscribers refers to subscription_type = 'subscribers'; ended their trip at refers to end_station_name; end_station_name = 'MLK Library'; number of docks a station have refers to dock_count;
SQL: SELECT COUNT(T1.id), T2.dock_count FROM trip AS T1 INNER JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T1.end_station_name = 'MLK Library' AND T1.subscription_type = 'Subscriber' AND T2.dock_count = 19

Database: movie_3
Question: What is the percentage more for the rental payment for store No.2 than store No.1?
Evidence: store no. 1 refers to store_id = 1; store no.2 refers to store_id = 2; rental payment refers to amount; percent more = Divide (Subtract(amount where store_id = 2, amount where store_id = 1), amount where store_id = 1) *100
SQL: SELECT CAST((SUM(IIF(T2.store_id = 2, T1.amount, 0)) - SUM(IIF(T2.store_id = 1, T1.amount, 0))) AS REAL) * 100 / SUM(IIF(T2.store_id = 1, T1.amount, 0)) FROM payment AS T1 INNER JOIN customer AS T2 ON T1.customer_id = T2.customer_id INNER JOIN store AS T3 ON T2.store_id = T3.store_id

Database: movie_3
Question: How many times has Mary Smith rented a film?
SQL: SELECT COUNT(T1.customer_id) FROM payment AS T1 INNER JOIN customer AS T2 ON T1.customer_id = T2.customer_id WHERE T2.first_name = 'MARY' AND T2.last_name = 'SMITH'

Database: codebase_comments
Question: How many path does the github address "https://github.com/jeffdik/tachy.git" have?
Evidence: github address refers to Url; Url = 'https://github.com/jeffdik/tachy.git';
SQL: SELECT COUNT(DISTINCT T2.Path) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Url = 'https://github.com/jeffdik/tachy.git'

Database: movie_3
Question: What is the most common first name among the customers?
Evidence: the most common first name refers to MAX(COUNT(first_name))
SQL: SELECT first_name FROM customer GROUP BY first_name ORDER BY COUNT(first_name) DESC LIMIT 1

Database: public_review_platform
Question: What is the opening time of the active businesses in Surprise that has a low review count.
Evidence: active business refers to active = 'true'; 'Surprise' is the name of city;  low review count refers to review_count = 'Low'
SQL: SELECT T2.opening_time FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id INNER JOIN Days AS T3 ON T2.day_id = T3.day_id WHERE T1.city LIKE 'Surprise' AND T1.active LIKE 'TRUE' AND T1.review_count LIKE 'Low' GROUP BY T2.opening_time

Database: retail_world
Question: Name the suppliers that supply products under the category 'cheeses.'
Evidence: suppliers refers to CompanyName; 'cheeses' is a Description
SQL: SELECT DISTINCT T1.CompanyName 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 T3.Description = 'Cheeses'

Database: movie_platform
Question: How many movie lists were created by user 83373278 when he or she was a subscriber?
Evidence: the user was a subscriber when he created the list refers to user_subscriber = 1; user 83373278 refers to user_id = 83373278;
SQL: SELECT COUNT(*) FROM lists_users WHERE user_id = 83373278 AND user_subscriber = 1

Database: movie_3
Question: What is the phone number of address No.72?
Evidence: address no. 72 refers to address_id = 72; phone number refers to phone
SQL: SELECT phone FROM address WHERE address_id = '72'