Database: world_development_indicators
Question: What is the average value of Adolescent fertility rate in the country whose Alpha2Code is 1A?
Evidence: average value = AVG(Value) where IndicatorName = 'Adolescent fertility rate (births per 1,000 women ages 15-19)'
SQL: SELECT CAST(SUM(T2.Value) AS REAL) * 100 / COUNT(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: car_retails
Question: What is the total value of cancelled orders?
Evidence: total value = SUM(MULTIPLY(quantityOrdered, priceEach)); cancelled orders refers to status = 'Cancelled';
SQL: SELECT SUM(T1.quantityOrdered * T1.priceEach) FROM orderdetails AS T1 INNER JOIN orders AS T2 ON T1.orderNumber = T2.orderNumber WHERE T2.status = 'Cancelled'

Database: beer_factory
Question: What is the precise location of the Sac State American River Courtyard?
Evidence: precise location = Latitude, Longitude; Sac State American River Courtyard refers to LocationName = 'Sac State American River Courtyard';
SQL: SELECT T2.Latitude, T2.Longitude FROM location AS T1 INNER JOIN geolocation AS T2 ON T1.LocationID = T2.LocationID WHERE T1.LocationName = 'Sac State American River Courtyard'

Database: bike_share_1
Question: Convert all temperature recorded at San Francisco city during August 2013 into degree Celsius.
Evidence: temperature refers to max_temperature_f; March 2013 refers to date like '3/%/2013'; conversion to Celcius = DIVIDE(SUBTRACT(max_temperature_f, 32), 1.800) as Celsius1; DIVIDE(SUBTRACT(mean_temperature_f, 32), 1.800) as Celsius2; DIVIDE(SUBTRACT(min_temperature_f, 32), 1.800) as Celcius3;
SQL: SELECT (max_temperature_f - 32) / 1.8000 , (mean_temperature_f - 32) / 1.8000 , (min_temperature_f - 32) / 1.8000 FROM weather WHERE SUBSTR(CAST(date AS TEXT), 1, INSTR(date, '/') - 1) = '8' AND SUBSTR(CAST(date AS TEXT), -4) = '2013' AND zip_code = 94107

Database: airline
Question: What is the total number of flights that flew on August 2, 2018 with air carrier described as Horizon Air?
Evidence: on August 2, 2018 refers to FL_DATE = '2018/8/2'; Horizon Air refers to Description which includs 'Horizon Air';
SQL: SELECT COUNT(*) FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID WHERE T1.Description LIKE '%Horizon Air%' AND T2.FL_DATE = '2018/8/2'

Database: chicago_crime
Question: Where did case No. JB100065 happen? Give the name of the district.
Evidence: case No. JB100065 refers to case_number = 'JB100065'; name of the district refers to district_name
SQL: SELECT T1.district_name FROM District AS T1 INNER JOIN Crime AS T2 ON T1.district_no = T2.district_no WHERE T2.case_number = 'JB100065'

Database: world_development_indicators
Question: Please list the descriptions of the series code SM.POP.TOTL for all the countries that are under the lending category of the International Development Associations.
Evidence: Countries are the Countrycode; International Development Associations refers to lendingcategory = 'IDA'
SQL: SELECT T2.Description FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T1.LendingCategory = 'IDA' AND T2.Seriescode = 'SM.POP.TOTL'

Database: movies_4
Question: How many producers does the movie "The Amityville Horror" have?
Evidence: producers refers to job = 'Producer'; "The Amityville Horror" refers to title = 'The Amityville Horror'
SQL: SELECT COUNT(T2.person_id) FROM movie AS T1 INNER JOIN movie_crew AS T2 ON T1.movie_id = T2.movie_id WHERE T1.title = 'The Amityville Horror' AND T2.job = 'Producer'

Database: language_corpus
Question: For corpus title "Atomium", pick 3 words appear in the title and calculate the total occurence of these words.
Evidence: total occurrences refers to sum(occurrences)
SQL: SELECT T1.word, T1.occurrences FROM words AS T1 INNER JOIN pages_words AS T2 ON T1.wid = T2.wid WHERE T2.pid = ( SELECT pid FROM pages WHERE title = 'Atomium' ) LIMIT 3

Database: ice_hockey_draft
Question: Who is the youngest player to have played during the 1997-1998 season for OHL League?
Evidence: youngest player refers to MAX(birthdate); 1997-1998 season refers to SEASON = '1997-1998'; OHL league refers to LEAGUE = 'OHL';
SQL: SELECT DISTINCT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.SEASON = '1997-1998' AND T1.LEAGUE = 'OHL' ORDER BY T2.birthdate DESC LIMIT 1

Database: address
Question: Provide the zip codes and coordinates of the postal points under Allentown-Bethlehem-Easton, PA-NJ.
Evidence: coordinates refer to latitude and longitude; under Allentown-Bethlehem-Easton, PA-NJ refers to CBSA_name = 'Allentown-Bethlehem-Easton, PA-NJ';
SQL: SELECT T2.zip_code, T2.latitude, T2.longitude FROM CBSA AS T1 INNER JOIN zip_data AS T2 ON T1.CBSA = T2.CBSA WHERE T1.CBSA_name = 'Allentown-Bethlehem-Easton, PA-NJ'

Database: coinmarketcap
Question: When is the best time to purchase Bitcoin?
Evidence: lowest price refers to low; best time refers to date with the low;
SQL: SELECT T2.date FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T1.name = 'Bitcoin' ORDER BY T2.low LIMIT 1

Database: movielens
Question: Who are cast members in an English movie which has a running time equal to 2? Please list their IDs.
Evidence: isEnglish = 'T' means English movie
SQL: SELECT T2.actorid FROM movies AS T1 INNER JOIN movies2actors AS T2 ON T1.movieid = T2.movieid WHERE T1.runningtime = 2 AND T1.isEnglish = 'T'

Database: airline
Question: What are the destinations of the flights with air carrier description "Southeast Alaska Airlines: WEB"?
Evidence: destinations refers to DEST; Southeast Alaska Airlines: WEB refers to Description = 'Southeast Alaska Airlines: WEB';
SQL: SELECT T2.DEST FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID WHERE T1.Description = 'Southeast Alaska Airlines: WEB'

Database: retail_world
Question: Please list the names of all the products whose supplier is in Japan.
Evidence: names of the products refers to ProductName; Japan refers to Country = 'Japan';
SQL: SELECT T1.ProductName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.Country = 'Japan'

Database: movie_3
Question: How many animation film titles are rated for adults only?
Evidence: animation film refers to category.name = 'animation'; for adults only means rating = 'NC-17'
SQL: SELECT COUNT(T1.title) FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T2.category_id = T3.category_id WHERE T3.name = 'animation' AND T1.rating = 'NC-17'

Database: image_and_language
Question: Indicate the bounding box of the image 8.
Evidence: bounding box refers to X, Y, W, H from IMG_OBJ; image 8 refers to IMG_ID = 8;
SQL: SELECT X, Y, W, H FROM IMG_OBJ WHERE IMG_ID = 8

Database: regional_sales
Question: What is the name of the product with the highest net profit?
Evidence: highest net profit = Max(Subtract (Unit Price, Unit Cost)); name of product refers to Product Name
SQL: SELECT T2.`Product Name` FROM `Sales Orders` AS T1 INNER JOIN Products AS T2 ON T2.ProductID = T1._ProductID ORDER BY REPLACE(T1.`Unit Price`, ',', '') - REPLACE(T1.`Unit Cost`, ',', '') DESC LIMIT 1

Database: synthea
Question: Provide the body weight of Elly Koss in every observation.
Evidence: body weight VALUE and UNITS where DESCRIPTION = 'Body Weight' from observations;
SQL: SELECT T2.DESCRIPTION, T2.VALUE, T2.UNITS FROM patients AS T1 INNER JOIN observations AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Elly' AND T1.last = 'Koss' AND T2.DESCRIPTION = 'Body Weight'