target-benchmark/spider-queries huggingface dataset:
Database: tvshow (tables: cartoon, tv_channel)
Question: What is the series name of the TV Channel that shows the cartoon "The Rise of the Blue Beetle"?
SQL: SELECT T1.series_name FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T2.Title = "The Rise of the Blue Beetle!";
Database: tvshow (tables: cartoon, tv_channel)
Question: List the title of all  Cartoons showed on TV Channel with series name "Sky Radio".
SQL: SELECT T2.Title FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio";
Database: tvshow (tables: cartoon, tv_channel)
Question: What is the title of all the cartools that are on the TV Channel with the series name "Sky Radio"?
SQL: SELECT T2.Title FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio";
Database: tvshow (tables: tv_series)
Question: List the Episode of all TV series sorted by rating.
SQL: SELECT Episode FROM TV_series ORDER BY rating
Database: tvshow (tables: tv_series)
Question: What are all of the episodes ordered by ratings?
SQL: SELECT Episode FROM TV_series ORDER BY rating
Database: tvshow (tables: tv_series)
Question: List top 3 highest Rating  TV series. List the TV series's Episode and Rating.
SQL: SELECT Episode ,  Rating FROM TV_series ORDER BY Rating DESC LIMIT 3;
Database: tvshow (tables: tv_series)
Question: What are 3 most highly rated episodes in the TV series table and what were those ratings?
SQL: SELECT Episode ,  Rating FROM TV_series ORDER BY Rating DESC LIMIT 3;
Database: tvshow (tables: tv_series)
Question: What is minimum and maximum share of TV series?
SQL: SELECT max(SHARE) , min(SHARE) FROM TV_series;
Database: tvshow (tables: tv_series)
Question: What is the maximum and minimum share for the TV series?
SQL: SELECT max(SHARE) , min(SHARE) FROM TV_series;
Database: tvshow (tables: tv_series)
Question: What is the air date of TV series with Episode "A Love of a Lifetime"?
SQL: SELECT Air_Date FROM TV_series WHERE Episode = "A Love of a Lifetime";
Database: tvshow (tables: tv_series)
Question: When did the episode "A Love of a Lifetime" air?
SQL: SELECT Air_Date FROM TV_series WHERE Episode = "A Love of a Lifetime";
Database: tvshow (tables: tv_series)
Question: What is Weekly Rank of TV series with Episode "A Love of a Lifetime"?
SQL: SELECT Weekly_Rank FROM TV_series WHERE Episode = "A Love of a Lifetime";
Database: tvshow (tables: tv_series)
Question: What is the weekly rank for the episode "A Love of a Lifetime"?
SQL: SELECT Weekly_Rank FROM TV_series WHERE Episode = "A Love of a Lifetime";
Database: tvshow (tables: tv_series, tv_channel)
Question: What is the TV Channel of TV series with Episode "A Love of a Lifetime"? List the TV Channel's series name.
SQL: SELECT T1.series_name FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T2.Episode = "A Love of a Lifetime";
Database: tvshow (tables: tv_series, tv_channel)
Question: What is the name of the series that has the episode "A Love of a Lifetime"?
SQL: SELECT T1.series_name FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T2.Episode = "A Love of a Lifetime";
Database: tvshow (tables: tv_series, tv_channel)
Question: List the Episode of all  TV series showed on TV Channel with series name "Sky Radio".
SQL: SELECT T2.Episode FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio";
Database: tvshow (tables: tv_series, tv_channel)
Question: What is the episode for the TV series named "Sky Radio"?
SQL: SELECT T2.Episode FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio";
Database: tvshow (tables: cartoon)
Question: Find the number of cartoons directed by each of the listed directors.
SQL: SELECT count(*) ,  Directed_by FROM cartoon GROUP BY Directed_by
Database: tvshow (tables: cartoon)
Question: How many cartoons did each director create?
SQL: SELECT count(*) ,  Directed_by FROM cartoon GROUP BY Directed_by
Database: tvshow (tables: cartoon)
Question: Find the production code and channel of the most recently aired cartoon .
SQL: select production_code ,  channel from cartoon order by original_air_date desc limit 1
Database: tvshow (tables: cartoon)
Question: What is the produdction code and channel of the most recent cartoon ?
SQL: select production_code ,  channel from cartoon order by original_air_date desc limit 1
Database: tvshow (tables: tv_channel)
Question: Find the package choice and series name of the TV channel that has high definition TV.
SQL: SELECT package_option ,  series_name FROM TV_Channel WHERE hight_definition_TV  =  "yes"
Database: tvshow (tables: tv_channel)
Question: What are the package options and the name of the series for the TV Channel that supports high definition TV?
SQL: SELECT package_option ,  series_name FROM TV_Channel WHERE hight_definition_TV  =  "yes"
Database: tvshow (tables: cartoon, tv_channel)
Question: which countries' tv channels are playing some cartoon written by Todd Casey?
SQL: SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by  =  'Todd Casey'
Database: tvshow (tables: cartoon, tv_channel)
Question: What are the countries that have cartoons on TV that were written by Todd Casey?
SQL: SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by  =  'Todd Casey'
Database: tvshow (tables: cartoon, tv_channel)
Question: which countries' tv channels are not playing any cartoon written by Todd Casey?
SQL: SELECT country FROM TV_Channel EXCEPT SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by  =  'Todd Casey'
Database: tvshow (tables: cartoon, tv_channel)
Question: What are the countries that are not playing cartoons written by Todd Casey?
SQL: SELECT country FROM TV_Channel EXCEPT SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by  =  'Todd Casey'
Database: tvshow (tables: cartoon, tv_channel)
Question: Find the series name and country of the tv channel that is playing some cartoons directed by Ben Jones and Michael Chang?
SQL: SELECT T1.series_name ,  T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by  =  'Michael Chang' INTERSECT SELECT T1.series_name ,  T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by  =  'Ben Jones'
Database: tvshow (tables: cartoon, tv_channel)
Question: What is the series name and country of all TV channels that are playing cartoons directed by Ben Jones and cartoons directed by Michael Chang?
SQL: SELECT T1.series_name ,  T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by  =  'Michael Chang' INTERSECT SELECT T1.series_name ,  T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by  =  'Ben Jones'
Database: tvshow (tables: tv_channel)
Question: find the pixel aspect ratio and nation of the tv channels that do not use English.
SQL: SELECT Pixel_aspect_ratio_PAR ,  country FROM tv_channel WHERE LANGUAGE != 'English'
Database: tvshow (tables: tv_channel)
Question: What is the pixel aspect ratio and country of origin for all TV channels that do not use English?
SQL: SELECT Pixel_aspect_ratio_PAR ,  country FROM tv_channel WHERE LANGUAGE != 'English'
Database: tvshow (tables: tv_channel)
Question: find id of the tv channels that from the countries where have more than two tv channels.
SQL: SELECT id FROM tv_channel GROUP BY country HAVING count(*)  >  2
Database: tvshow (tables: tv_channel)
Question: What are the ids of all tv channels that have more than 2 TV channels?
SQL: SELECT id FROM tv_channel GROUP BY country HAVING count(*)  >  2
Database: tvshow (tables: cartoon, tv_channel)
Question: find the id of tv channels that do not play any cartoon directed by Ben Jones.
SQL: SELECT id FROM TV_Channel EXCEPT SELECT channel FROM cartoon WHERE directed_by  =  'Ben Jones'
Database: tvshow (tables: cartoon, tv_channel)
Question: What are the ids of the TV channels that do not have any cartoons directed by Ben Jones?
SQL: SELECT id FROM TV_Channel EXCEPT SELECT channel FROM cartoon WHERE directed_by  =  'Ben Jones'
Database: tvshow (tables: cartoon, tv_channel)
Question: find the package option of the tv channel that do not have any cartoon directed by Ben Jones.
SQL: SELECT package_option FROM TV_Channel WHERE id NOT IN (SELECT channel FROM cartoon WHERE directed_by  =  'Ben Jones')
Database: tvshow (tables: cartoon, tv_channel)
Question: What are the package options of all tv channels that are not playing any cartoons directed by Ben Jones?
SQL: SELECT package_option FROM TV_Channel WHERE id NOT IN (SELECT channel FROM cartoon WHERE directed_by  =  'Ben Jones')
Database: poker_player (tables: poker_player)
Question: How many poker players are there?
SQL: SELECT count(*) FROM poker_player
Database: poker_player (tables: poker_player)
Question: Count the number of poker players.
SQL: SELECT count(*) FROM poker_player
Database: poker_player (tables: poker_player)
Question: List the earnings of poker players in descending order.
SQL: SELECT Earnings FROM poker_player ORDER BY Earnings DESC
Database: poker_player (tables: poker_player)
Question: What are the earnings of poker players, ordered descending by value?
SQL: SELECT Earnings FROM poker_player ORDER BY Earnings DESC
Database: poker_player (tables: poker_player)
Question: List the final tables made and the best finishes of poker players.
SQL: SELECT Final_Table_Made ,  Best_Finish FROM poker_player
Database: poker_player (tables: poker_player)
Question: What are the final tables made and best finishes for all poker players?
SQL: SELECT Final_Table_Made ,  Best_Finish FROM poker_player
Database: poker_player (tables: poker_player)
Question: What is the average earnings of poker players?
SQL: SELECT avg(Earnings) FROM poker_player
Database: poker_player (tables: poker_player)
Question: Return the average earnings across all poker players.
SQL: SELECT avg(Earnings) FROM poker_player
Database: poker_player (tables: poker_player)
Question: What is the money rank of the poker player with the highest earnings?
SQL: SELECT Money_Rank FROM poker_player ORDER BY Earnings DESC LIMIT 1
Database: poker_player (tables: poker_player)
Question: Return the money rank of the player with the greatest earnings.
SQL: SELECT Money_Rank FROM poker_player ORDER BY Earnings DESC LIMIT 1
Database: poker_player (tables: poker_player)
Question: What is the maximum number of final tables made among poker players with earnings less than 200000?
SQL: SELECT max(Final_Table_Made) FROM poker_player WHERE Earnings  <  200000
Database: poker_player (tables: poker_player)
Question: Return the maximum final tables made across all poker players who have earnings below 200000.
SQL: SELECT max(Final_Table_Made) FROM poker_player WHERE Earnings  <  200000
Database: poker_player (tables: poker_player, people)
Question: What are the names of poker players?
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID
Database: poker_player (tables: poker_player, people)
Question: Return the names of all the poker players.
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID
Database: poker_player (tables: poker_player, people)
Question: What are the names of poker players whose earnings is higher than 300000?
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Earnings  >  300000
Database: poker_player (tables: poker_player, people)
Question: Give the names of poker players who have earnings above 300000.
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Earnings  >  300000
Database: poker_player (tables: poker_player, people)
Question: List the names of poker players ordered by the final tables made in ascending order.
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Final_Table_Made
Database: poker_player (tables: poker_player, people)
Question: What are the names of poker players, ordered ascending by the number of final tables they have made?
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Final_Table_Made
Database: poker_player (tables: poker_player, people)
Question: What is the birth date of the poker player with the lowest earnings?
SQL: SELECT T1.Birth_Date FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Earnings ASC LIMIT 1
Database: poker_player (tables: poker_player, people)
Question: Return the birth date of the poker player with the lowest earnings.
SQL: SELECT T1.Birth_Date FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Earnings ASC LIMIT 1
Database: poker_player (tables: poker_player, people)
Question: What is the money rank of the tallest poker player?
SQL: SELECT T2.Money_Rank FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Height DESC LIMIT 1
Database: poker_player (tables: poker_player, people)
Question: Return the money rank of the poker player with the greatest height.
SQL: SELECT T2.Money_Rank FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Height DESC LIMIT 1
Database: poker_player (tables: poker_player, people)
Question: What is the average earnings of poker players with height higher than 200?
SQL: SELECT avg(T2.Earnings) FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Height  >  200
Database: poker_player (tables: poker_player, people)
Question: Give average earnings of poker players who are taller than 200.
SQL: SELECT avg(T2.Earnings) FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Height  >  200
Database: poker_player (tables: poker_player, people)
Question: What are the names of poker players in descending order of earnings?
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Earnings DESC
Database: poker_player (tables: poker_player, people)
Question: Return the names of poker players sorted by their earnings descending.
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Earnings DESC
Database: poker_player (tables: people)
Question: What are different nationalities of people and the corresponding number of people from each nation?
SQL: SELECT Nationality ,  COUNT(*) FROM people GROUP BY Nationality
Database: poker_player (tables: people)
Question: How many people are there of each nationality?
SQL: SELECT Nationality ,  COUNT(*) FROM people GROUP BY Nationality
Database: poker_player (tables: people)
Question: What is the most common nationality of people?
SQL: SELECT Nationality FROM people GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1
Database: poker_player (tables: people)
Question: Give the nationality that is most common across all people.
SQL: SELECT Nationality FROM people GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1
Database: poker_player (tables: people)
Question: What are the nationalities that are shared by at least two people?
SQL: SELECT Nationality FROM people GROUP BY Nationality HAVING COUNT(*)  >=  2
Database: poker_player (tables: people)
Question: Return the nationalities for which there are two or more people.
SQL: SELECT Nationality FROM people GROUP BY Nationality HAVING COUNT(*)  >=  2
Database: poker_player (tables: people)
Question: List the names and birth dates of people in ascending alphabetical order of name.
SQL: SELECT Name ,  Birth_Date FROM people ORDER BY Name ASC
Database: poker_player (tables: people)
Question: What are the names and birth dates of people, ordered by their names in alphabetical order?
SQL: SELECT Name ,  Birth_Date FROM people ORDER BY Name ASC
Database: poker_player (tables: people)
Question: Show names of people whose nationality is not "Russia".
SQL: SELECT Name FROM people WHERE Nationality != "Russia"
Database: poker_player (tables: people)
Question: What are the names of people who are not from Russia?
SQL: SELECT Name FROM people WHERE Nationality != "Russia"
Database: poker_player (tables: poker_player, people)
Question: List the names of people that are not poker players.
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM poker_player)
Database: poker_player (tables: poker_player, people)
Question: What are the names of people who do not play poker?
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM poker_player)
Database: poker_player (tables: people)
Question: How many distinct nationalities are there?
SQL: SELECT count(DISTINCT Nationality) FROM people
Database: poker_player (tables: people)
Question: Count the number of different nationalities.
SQL: SELECT count(DISTINCT Nationality) FROM people
Database: voter_1 (tables: area_code_state)
Question: How many states are there?
SQL: SELECT count(*) FROM area_code_state
Database: voter_1 (tables: contestants)
Question: List the contestant numbers and names, ordered by contestant name descending.
SQL: SELECT contestant_number ,  contestant_name FROM contestants ORDER BY contestant_name DESC
Database: voter_1 (tables: votes)
Question: List the vote ids, phone numbers and states of all votes.
SQL: SELECT vote_id ,  phone_number ,  state FROM votes
Database: voter_1 (tables: area_code_state)
Question: What are the maximum and minimum values of area codes?
SQL: SELECT max(area_code) ,  min(area_code) FROM area_code_state
Database: voter_1 (tables: votes)
Question: What is last date created of votes from the state 'CA'?
SQL: SELECT max(created) FROM votes WHERE state  =  'CA'
Database: voter_1 (tables: contestants)
Question: What are the names of the contestants whose names are not 'Jessie Alloway'
SQL: SELECT contestant_name FROM contestants WHERE contestant_name != 'Jessie Alloway'
Database: voter_1 (tables: votes)
Question: What are the distinct states and create time of all votes?
SQL: SELECT DISTINCT state ,  created FROM votes
Database: voter_1 (tables: contestants, votes)
Question: What are the contestant numbers and names of the contestants who had at least two votes?
SQL: SELECT T1.contestant_number , T1.contestant_name FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number  =  T2.contestant_number GROUP BY T1.contestant_number HAVING count(*)  >=  2
Database: voter_1 (tables: contestants, votes)
Question: Of all the contestants who got voted, what is the contestant number and name of the contestant who got least votes?
SQL: SELECT T1.contestant_number , T1.contestant_name FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number  =  T2.contestant_number GROUP BY T1.contestant_number ORDER BY count(*) ASC LIMIT 1
Database: voter_1 (tables: votes)
Question: What are the number of votes from state 'NY' or 'CA'?
SQL: SELECT count(*) FROM votes WHERE state  =  'NY' OR state  =  'CA'
Database: voter_1 (tables: contestants, votes)
Question: How many contestants did not get voted?
SQL: SELECT count(*) FROM contestants WHERE contestant_number NOT IN ( SELECT contestant_number FROM votes )
Database: voter_1 (tables: votes, area_code_state)
Question: What is the area code in which the most voters voted?
SQL: SELECT T1.area_code FROM area_code_state AS T1 JOIN votes AS T2 ON T1.state  =  T2.state GROUP BY T1.area_code ORDER BY count(*) DESC LIMIT 1
Database: voter_1 (tables: contestants, votes)
Question: What are the create dates, states, and phone numbers of the votes that were for the contestant named 'Tabatha Gehling'?
SQL: SELECT T2.created ,  T2.state ,  T2.phone_number FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number  =  T2.contestant_number WHERE T1.contestant_name  =  'Tabatha Gehling'
Database: voter_1 (tables: contestants, votes, area_code_state)
Question: List the area codes in which voters voted both for the contestant 'Tabatha Gehling' and the contestant 'Kelly Clauss'.
SQL: SELECT T3.area_code FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number  =  T2.contestant_number JOIN area_code_state AS T3 ON T2.state  =  T3.state WHERE T1.contestant_name  =  'Tabatha Gehling' INTERSECT SELECT T3.area_code FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number  =  T2.contestant_number JOIN area_code_state AS T3 ON T2.state  =  T3.state WHERE T1.contestant_name  =  'Kelly Clauss'
Database: voter_1 (tables: contestants)
Question: Return the names of the contestants whose names contain the substring 'Al' .
SQL: select contestant_name from contestants where contestant_name like "%al%"
Database: world_1 (tables: country)
Question: What are the names of all the countries that became independent after 1950?
SQL: SELECT Name FROM country WHERE IndepYear  >  1950
Database: world_1 (tables: country)
Question: Give the names of the nations that were founded after 1950.
SQL: SELECT Name FROM country WHERE IndepYear  >  1950
Database: world_1 (tables: country)
Question: How many countries have a republic as their form of government?
SQL: SELECT count(*) FROM country WHERE GovernmentForm  =  "Republic"
Database: world_1 (tables: country)
Question: How many countries have governments that are republics?
SQL: SELECT count(*) FROM country WHERE GovernmentForm  =  "Republic"
Database: world_1 (tables: country)
Question: What is the total surface area of the countries in the Caribbean region?
SQL: SELECT sum(SurfaceArea) FROM country WHERE Region  =  "Caribbean"
Database: world_1 (tables: country)
Question: How much surface area do the countires in the Carribean cover together?
SQL: SELECT sum(SurfaceArea) FROM country WHERE Region  =  "Caribbean"
Database: world_1 (tables: country)
Question: Which continent is Anguilla in?
SQL: SELECT Continent FROM country WHERE Name  =  "Anguilla"
Database: world_1 (tables: country)
Question: What is the continent name which Anguilla belongs to?
SQL: SELECT Continent FROM country WHERE Name  =  "Anguilla"
Database: world_1 (tables: city, country)
Question: Which region is the city Kabul located in?
SQL: SELECT Region FROM country AS T1 JOIN city AS T2 ON T1.Code  =  T2.CountryCode WHERE T2.Name  =  "Kabul"
Database: world_1 (tables: city, country)
Question: What region is Kabul in?
SQL: SELECT Region FROM country AS T1 JOIN city AS T2 ON T1.Code  =  T2.CountryCode WHERE T2.Name  =  "Kabul"
Database: world_1 (tables: country, countrylanguage)
Question: Which language is the most popular in Aruba?
SQL: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode WHERE T1.Name  =  "Aruba" ORDER BY Percentage DESC LIMIT 1
Database: world_1 (tables: country, countrylanguage)
Question: What language is predominantly spoken in Aruba?
SQL: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode WHERE T1.Name  =  "Aruba" ORDER BY Percentage DESC LIMIT 1
Database: world_1 (tables: country)
Question: What are the population and life expectancies in Brazil?
SQL: SELECT Population ,  LifeExpectancy FROM country WHERE Name  =  "Brazil"
Database: world_1 (tables: country)
Question: Give me Brazil’s population and life expectancies.
SQL: SELECT Population ,  LifeExpectancy FROM country WHERE Name  =  "Brazil"
Database: world_1 (tables: country)
Question: What are the region and population of Angola?
SQL: SELECT Population ,  Region FROM country WHERE Name  =  "Angola"
Database: world_1 (tables: country)
Question: What region does Angola belong to and what is its population?
SQL: SELECT Population ,  Region FROM country WHERE Name  =  "Angola"
Database: world_1 (tables: country)
Question: What is the average expected life expectancy for countries in the region of Central Africa?
SQL: SELECT avg(LifeExpectancy) FROM country WHERE Region  =  "Central Africa"
Database: world_1 (tables: country)
Question: How long is the people’s average life expectancy in Central Africa?
SQL: SELECT avg(LifeExpectancy) FROM country WHERE Region  =  "Central Africa"