Database: world
Question: How many cities are there in England?
Evidence: England refers to District = 'England';
SQL: SELECT COUNT(ID) FROM City WHERE District = 'England'

Database: talkingdata
Question: What is the age group of users who use phone brand of vivo?
Evidence: age group refers to group;
SQL: SELECT T1.`group` FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.phone_brand = 'vivo'

Database: language_corpus
Question: What proportion of a pair of words in the Catalan language have been repeated less than 80 times?
Evidence: Pair is a relationship of two words: w1st and w2nd, where w1st is word id of the first word and w2nd is a word id of the second word; in the Catalan language refers to lid; repeated less than 80 times refers to occurrences < 80; DIVIDE(COUNT(lid where occurrences < 80), COUNT(lid)) as percentage;
SQL: SELECT CAST(COUNT(CASE WHEN occurrences < 80 THEN lid ELSE NULL END) AS REAL) * 100 / COUNT(lid) FROM biwords

Database: trains
Question: What is the total number of short cars on all the trains that run in the east direction?
Evidence: short cars refers to len = 'short'
SQL: SELECT SUM(CASE WHEN T1.len = 'short' then 1 ELSE 0 END)as count FROM cars AS T1 INNER JOIN trains AS T2 ON T1.train_id = T2.id WHERE T2.direction = 'east'

Database: shakespeare
Question: What is the percentage of act number 5 in Titus Andronicus?
Evidence: act number 5 refers to Act = 5; Titus Andronicus refers to Title = 'Titus Andronicus'; percentage = divide(sum(Act = 5), count(Act)) as percentage
SQL: SELECT CAST(SUM(IIF(T2.act = 5, 1, 0)) AS REAL) * 100 / COUNT(T2.act) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T1.Title = 'Titus Andronicus'

Database: bike_share_1
Question: List down the trips in which their start and end station are similar. Give me their trip IDs and location coordinates.
Evidence: start and end station are similar refers to start_station_name = end_station_name; latitude and longitude coordinates can be used to indicate a location;
SQL: SELECT T1.id, T2.lat, T2.long FROM trip AS T1 LEFT JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T1.start_station_name = T1.end_station_name

Database: software_company
Question: Among the geographic ID which has 33.658K of inhabitants, describe the education, occupation and age of female widow.
Evidence: geographic ID which has 33.658K of inhabitants refers to GEOID where INHABITANTS_K = 33.658; education refers to EDUCATIONNUM; female widow refers to SEX = 'Female' where MARITAL_STATUS = 'Widowed';
SQL: SELECT T1.EDUCATIONNUM, T1.OCCUPATION, T1.age FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID WHERE T2.INHABITANTS_K = 33.658 AND T1.SEX = 'Female' AND T1.MARITAL_STATUS = 'Widowed'

Database: books
Question: How many books written by Akira Watanabe are available on Gravity?
Evidence: "Akira Watanabe" is the author_name
SQL: SELECT COUNT(*) FROM author AS T1 INNER JOIN book_author AS T2 ON T1.author_id = T2.author_id WHERE T1.author_name = 'Akira Watanabe'

Database: legislator
Question: What is the current official Instagram handle of current legislator Bob Corker?
Evidence: official Instagram handle refers to instagram;
SQL: SELECT T2.instagram FROM current AS T1 INNER JOIN `social-media` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.official_full_name = 'Bob Corker'

Database: language_corpus
Question: What is the title of corpus with most words?
Evidence: most words refers to max(words)
SQL: SELECT title FROM pages WHERE words = ( SELECT MAX(words) FROM pages )

Database: college_completion
Question: Compare the graduate cohort for Auburn University from 2011 to 2013?
Evidence: graduate cohort for Auburn University refers to grad_cohort is not null WHERE chronname = 'Auburn University', gender = 'B', race = 'X' and cohort = '4y other', '4y bach'; from 2011 to 2013 refers to year in (2011, 2012, 2013);
SQL: SELECT SUM(CASE WHEN T2.year = 2011 THEN T2.grad_cohort ELSE 0 END), SUM(CASE WHEN T2.year = 2012 THEN T2.grad_cohort ELSE 0 END), SUM(CASE WHEN T2.year = 2013 THEN T2.grad_cohort ELSE 0 END) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T1.unitid = T2.unitid WHERE T2.gender = 'B' AND T2.race = 'X' AND T1.chronname = 'Auburn University'

Database: menu
Question: List down name of dishes from menu with menu page ID 1389.
Evidence: FALSE;
SQL: SELECT T2.name FROM MenuItem AS T1 INNER JOIN Dish AS T2 ON T2.id = T1.dish_id WHERE T1.menu_page_id = 1389

Database: legislator
Question: Current legislator Roger F. Wicker has not been a representative for how many terms?
Evidence: Roger F. Wicker is an official_full_name; not a representative refers to district IS NULL OR district = ''
SQL: SELECT SUM(CASE WHEN T1.official_full_name = 'Roger F. Wicker' THEN 1 ELSE 0 END) AS count FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.district IS NULL OR T2.district = ''

Database: simpson_episodes
Question: Please indicate the keywords of the episode that won the Primetime Emmy Award category.
Evidence: Primetime Emmy Award refers to award_category = 'Primetime Emmy'
SQL: SELECT T2.keyword FROM Award AS T1 INNER JOIN Keyword AS T2 ON T2.episode_id = T1.episode_id WHERE T1.award_category = 'Primetime Emmy';

Database: address
Question: Among the cities with alias Ponce, what is the percentage of cities with a country level FIPS code of less than 20?
Evidence: DIVIDE(COUNT(county_fips < 20), COUNT(county_fips)) as percentage where alias = 'Ponce';
SQL: SELECT CAST(COUNT(CASE WHEN T2.county_fips < 20 THEN T2.zip_code ELSE NULL END) AS REAL) * 100 / COUNT(T2.zip_code) FROM alias AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.alias = 'Ponce'

Database: professional_basketball
Question: From 1962 to 2011, how many coaches received both NBA and ABA awards?
Evidence: from 1962 to 2011 refers to year between 1960 and 2011; received both NBA and ABA award refers to coachID where award LIKE 'NBA%' and 'ABA%'
SQL: SELECT COUNT(DISTINCT coachID) FROM awards_coaches WHERE year BETWEEN 1962 AND 2011 AND award = 'ABA Coach of the Year' AND coachID IN ( SELECT coachID FROM awards_coaches WHERE year BETWEEN 1962 AND 2011 AND award = 'NBA Coach of the Year' )

Database: law_episode
Question: What is the difference of 10 stars votes between the first episode and the last episode?
Evidence: the first episode refers to episode = 1; the last episode refers to episode = 24; 10 stars vote refers to stars = 10; the difference = subtract(votes where episode = 1, votes where episode = 24) where stars = 10
SQL: SELECT SUM(CASE WHEN T2.episode = 24 THEN T1.votes ELSE 0 END) - SUM(CASE WHEN T2.episode = 1 THEN T1.votes ELSE 0 END) FROM Vote AS T1 INNER JOIN Episode AS T2 ON T2.episode_id = T1.episode_id WHERE T1.stars = 10

Database: bike_share_1
Question: For all trips which took less 5 minutes, state the station name where the bike were borrowed and returned. Indicate mean temperature of the day.
Evidence: less than 5 minutes refers to duration<300 in seconds; the station where the bike was borrowed refers to start_station_name; the station where the bike was returned refers to end_station_name; mean temperature refers to min_temperature_f;
SQL: SELECT T1.start_station_name, T1.end_station_name, T2.mean_temperature_f FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE T1.duration < 300

Database: retails
Question: What is the nationality of "Customer#000000055"?
Evidence: "Customer#000000055" is the name of the customer which refers to c_name; nationality is the state of belonging to a particular country, therefore nationality refers to n_name;
SQL: SELECT T2.n_name FROM customer AS T1 INNER JOIN nation AS T2 ON T1.c_name = 'Customer#000000055'