kaxap/pg-wikiSQL-sql-instructions-80k

1question,create_table_statement,sql_query,wiki_sql_table_id2What position does the player who played for butler cc (ks) play?,"CREATE TABLE ""l"" (3  ""player"" text,4  ""no"" text,5  ""nationality"" text,6  ""position"" text,7  ""years_in_toronto"" text,8  ""school_club_team"" text9);","SELECT ""position"" FROM ""l"" WHERE ""school_club_team""='Butler CC (KS)';",1-10015132-1110How many schools did player number 3 play at?,"CREATE TABLE ""l"" (11  ""player"" text,12  ""no"" text,13  ""nationality"" text,14  ""position"" text,15  ""years_in_toronto"" text,16  ""school_club_team"" text17);","SELECT COUNT(""school_club_team"") FROM ""l"" WHERE ""no""='3';",1-10015132-1118What school did player number 21 play for?,"CREATE TABLE ""l"" (19  ""player"" text,20  ""no"" text,21  ""nationality"" text,22  ""position"" text,23  ""years_in_toronto"" text,24  ""school_club_team"" text25);","SELECT ""school_club_team"" FROM ""l"" WHERE ""no""='21';",1-10015132-1126Who is the player that wears number 42?,"CREATE TABLE ""l"" (27  ""player"" text,28  ""no"" text,29  ""nationality"" text,30  ""position"" text,31  ""years_in_toronto"" text,32  ""school_club_team"" text33);","SELECT ""player"" FROM ""l"" WHERE ""no""='42';",1-10015132-1134What player played guard for toronto in 1996-97?,"CREATE TABLE ""l"" (35  ""player"" text,36  ""no"" text,37  ""nationality"" text,38  ""position"" text,39  ""years_in_toronto"" text,40  ""school_club_team"" text41);","SELECT ""player"" FROM ""l"" WHERE ""position""='Guard' AND ""years_in_toronto""='1996-97';",1-10015132-1142Who are all of the players on the Westchester High School club team?,"CREATE TABLE ""j"" (43  ""player"" text,44  ""no"" text,45  ""nationality"" text,46  ""position"" text,47  ""years_in_toronto"" text,48  ""school_club_team"" text49);","SELECT ""player"" FROM ""j"" WHERE ""school_club_team""='Westchester High School';",1-10015132-950What school/club team is Amir Johnson on?,"CREATE TABLE ""j"" (51  ""player"" text,52  ""no"" text,53  ""nationality"" text,54  ""position"" text,55  ""years_in_toronto"" text,56  ""school_club_team"" text57);","SELECT ""school_club_team"" FROM ""j"" WHERE ""player""='Amir Johnson';",1-10015132-958What are the total amount of numbers on the Toronto team in 2005-06?,"CREATE TABLE ""j"" (59  ""player"" text,60  ""no"" text,61  ""nationality"" text,62  ""position"" text,63  ""years_in_toronto"" text,64  ""school_club_team"" text65);","SELECT COUNT(""no"") FROM ""j"" WHERE ""years_in_toronto""='2005-06';",1-10015132-966What are the total number of positions on the Toronto team in 2006-07?,"CREATE TABLE ""j"" (67  ""player"" text,68  ""no"" text,69  ""nationality"" text,70  ""position"" text,71  ""years_in_toronto"" text,72  ""school_club_team"" text73);","SELECT COUNT(""position"") FROM ""j"" WHERE ""years_in_toronto""='2006-07';",1-10015132-974What are the nationality of the players on the Fresno State school/club team?,"CREATE TABLE ""j"" (75  ""player"" text,76  ""no"" text,77  ""nationality"" text,78  ""position"" text,79  ""years_in_toronto"" text,80  ""school_club_team"" text81);","SELECT ""nationality"" FROM ""j"" WHERE ""school_club_team""='Fresno State';",1-10015132-982What school/club team is Trey Johnson on?,"CREATE TABLE ""j"" (83  ""player"" text,84  ""no"" text,85  ""nationality"" text,86  ""position"" text,87  ""years_in_toronto"" text,88  ""school_club_team"" text89);","SELECT ""school_club_team"" FROM ""j"" WHERE ""player""='Trey Johnson';",1-10015132-990When did Jacques Chirac stop being a G8 leader?,"CREATE TABLE ""chronology_of_longest_serving_g8_leaders"" (91  ""entered_office_as_head_of_state_or_government"" text,92  ""began_time_as_senior_g8_leader"" text,93  ""ended_time_as_senior_g8_leader"" text,94  ""person"" text,95  ""office"" text96);","SELECT ""ended_time_as_senior_g8_leader"" FROM ""chronology_of_longest_serving_g8_leaders"" WHERE ""person""='Jacques Chirac';",1-10026563-197When did the Prime Minister of Italy take office?,"CREATE TABLE ""chronology_of_longest_serving_g8_leaders"" (98  ""entered_office_as_head_of_state_or_government"" text,99  ""began_time_as_senior_g8_leader"" text,100  ""ended_time_as_senior_g8_leader"" text,101  ""person"" text,102  ""office"" text103);","SELECT ""entered_office_as_head_of_state_or_government"" FROM ""chronology_of_longest_serving_g8_leaders"" WHERE ""office""='Prime Minister of Italy';",1-10026563-1104What is the English name of the country whose official native language is Dutch Papiamento?,"CREATE TABLE ""table1_1008653_1"" (105  ""country_exonym"" text,106  ""capital_exonym"" text,107  ""country_endonym"" text,108  ""capital_endonym"" text,109  ""official_or_native_language_s_alphabet_script"" text110);","SELECT ""country_exonym"" FROM ""table1_1008653_1"" WHERE ""official_or_native_language_s_alphabet_script""='Dutch Papiamento';",1-1008653-1111What official or native languages are spoken in the country whose capital city is Canberra?,"CREATE TABLE ""table1_1008653_1"" (112  ""country_exonym"" text,113  ""capital_exonym"" text,114  ""country_endonym"" text,115  ""capital_endonym"" text,116  ""official_or_native_language_s_alphabet_script"" text117);","SELECT ""official_or_native_language_s_alphabet_script"" FROM ""table1_1008653_1"" WHERE ""capital_exonym""='Canberra';",1-1008653-1118What is the local name given to the city of Canberra?,"CREATE TABLE ""table1_1008653_1"" (119  ""country_exonym"" text,120  ""capital_exonym"" text,121  ""country_endonym"" text,122  ""capital_endonym"" text,123  ""official_or_native_language_s_alphabet_script"" text124);","SELECT ""capital_endonym"" FROM ""table1_1008653_1"" WHERE ""capital_exonym""='Canberra';",1-1008653-1125What is the local name given to the capital of Anguilla?,"CREATE TABLE ""table1_1008653_1"" (126  ""country_exonym"" text,127  ""capital_exonym"" text,128  ""country_endonym"" text,129  ""capital_endonym"" text,130  ""official_or_native_language_s_alphabet_script"" text131);","SELECT ""capital_endonym"" FROM ""table1_1008653_1"" WHERE ""country_endonym""='Anguilla';",1-1008653-1132What is the English name given to the city of St. John's?,"CREATE TABLE ""table1_1008653_1"" (133  ""country_exonym"" text,134  ""capital_exonym"" text,135  ""country_endonym"" text,136  ""capital_endonym"" text,137  ""official_or_native_language_s_alphabet_script"" text138);","SELECT ""capital_exonym"" FROM ""table1_1008653_1"" WHERE ""capital_endonym""='St. John''s';",1-1008653-1139How many capital cities does Australia have?,"CREATE TABLE ""table1_1008653_1"" (140  ""country_exonym"" text,141  ""capital_exonym"" text,142  ""country_endonym"" text,143  ""capital_endonym"" text,144  ""official_or_native_language_s_alphabet_script"" text145);","SELECT COUNT(""capital_endonym"") FROM ""table1_1008653_1"" WHERE ""country_endonym""='Australia';",1-1008653-1146The episode with production code 9abx02 was originally aired on what date?,"CREATE TABLE ""table1_10088101_1"" (147  ""no_in_set"" real,148  ""no_in_series"" real,149  ""title"" text,150  ""directed_by"" text,151  ""written_by"" text,152  ""original_air_date"" text,153  ""production_code"" text154);","SELECT ""original_air_date"" FROM ""table1_10088101_1"" WHERE ""production_code""='9ABX02';",1-10088101-1155What is the episode number that has production code 8abx15?,"CREATE TABLE ""table1_10088101_1"" (156  ""no_in_set"" real,157  ""no_in_series"" real,158  ""title"" text,159  ""directed_by"" text,160  ""written_by"" text,161  ""original_air_date"" text,162  ""production_code"" text163);","SELECT MIN(""no_in_series"") FROM ""table1_10088101_1"" WHERE ""production_code""='8ABX15';",1-10088101-1164Name the minimum tiesplayed for 6 years,"CREATE TABLE ""all_players"" (165  ""player"" text,166  ""highest_singles_ranking"" text,167  ""highest_doubles_ranking"" text,168  ""first_year_played"" real,169  ""years_played"" real,170  ""ties_played"" real,171  ""total_w_l"" text,172  ""singles_w_l"" text,173  ""doubles_w_l"" text174);","SELECT MIN(""ties_played"") FROM ""all_players"" WHERE ""years_played""=6;",1-10295819-2175"What is the amount of trees, that require replacement when prevailing types, % is pine — 29.37 poplar — 26.12 acer negundo — 13.2?","CREATE TABLE ""table1_10342194_3"" (176  ""district"" text,177  ""total_amount_of_trees"" real,178  ""prevailing_types_pct"" text,179  ""amount_of_old_trees"" text,180  ""amount_of_trees_that_require_replacement"" text181);","SELECT ""amount_of_trees_that_require_replacement"" FROM ""table1_10342194_3"" WHERE ""prevailing_types_pct""='Pine — 29.37 Poplar — 26.12 Acer negundo — 13.2';",1-10342194-3182"What is the amount of trees, that require replacement when district is leninsky?","CREATE TABLE ""table1_10342194_3"" (183  ""district"" text,184  ""total_amount_of_trees"" real,185  ""prevailing_types_pct"" text,186  ""amount_of_old_trees"" text,187  ""amount_of_trees_that_require_replacement"" text188);","SELECT ""amount_of_trees_that_require_replacement"" FROM ""table1_10342194_3"" WHERE ""district""='Leninsky';",1-10342194-3189"What is the district when the total amount of trees is smaller than 150817.6878461314 and amount of old trees is 1,928 (1.89%)?","CREATE TABLE ""table1_10342194_3"" (190  ""district"" text,191  ""total_amount_of_trees"" real,192  ""prevailing_types_pct"" text,193  ""amount_of_old_trees"" text,194  ""amount_of_trees_that_require_replacement"" text195);","SELECT ""district"" FROM ""table1_10342194_3"" WHERE ""total_amount_of_trees""<150817.6878461314 AND ""amount_of_old_trees""='1,928 (1.89%)';",1-10342194-3196"What is the amount of trees, that require replacement when the district is motovilikhinsky?","CREATE TABLE ""table1_10342194_3"" (197  ""district"" text,198  ""total_amount_of_trees"" real,199  ""prevailing_types_pct"" text,200  ""amount_of_old_trees"" text,201  ""amount_of_trees_that_require_replacement"" text202);","SELECT ""amount_of_trees_that_require_replacement"" FROM ""table1_10342194_3"" WHERE ""district""='Motovilikhinsky';",1-10342194-3203What is the total amount of trees when district is leninsky?,"CREATE TABLE ""table1_10342194_3"" (204  ""district"" text,205  ""total_amount_of_trees"" real,206  ""prevailing_types_pct"" text,207  ""amount_of_old_trees"" text,208  ""amount_of_trees_that_require_replacement"" text209);","SELECT MAX(""total_amount_of_trees"") FROM ""table1_10342194_3"" WHERE ""district""='Leninsky';",1-10342194-3210"What is the district when prevailing types, % is acer negundo — 30.22 tilia — 18.6 poplar — 15.23?","CREATE TABLE ""table1_10342194_3"" (211  ""district"" text,212  ""total_amount_of_trees"" real,213  ""prevailing_types_pct"" text,214  ""amount_of_old_trees"" text,215  ""amount_of_trees_that_require_replacement"" text216);","SELECT ""district"" FROM ""table1_10342194_3"" WHERE ""prevailing_types_pct""='Acer negundo — 30.22 Tilia — 18.6 Poplar — 15.23';",1-10342194-3217"When the value of ""since beginning of big 12"" is synonymous with its' category, what are the in Ames values?","CREATE TABLE ""record_vs_big_12_opponents"" (218  ""iowa_state_vs"" text,219  ""overall_record"" text,220  ""in_ames"" text,221  ""at_opponents_venue"" text,222  ""at_neutral_site"" text,223  ""last_5_meetings"" text,224  ""last_10_meetings"" text,225  ""current_streak"" text,226  ""since_beginning_of_big_12"" text227);","SELECT ""in_ames"" FROM ""record_vs_big_12_opponents"" WHERE ""since_beginning_of_big_12""='Since Beginning of Big 12';",1-10429820-13228"what's the u.s. open cup status for regular season of 4th, atlantic division ","CREATE TABLE ""year_by_year"" (229  ""year"" real,230  ""division"" text,231  ""league"" text,232  ""regular_season"" text,233  ""playoffs"" text,234  ""u_s_open_cup"" text235);","SELECT ""u_s_open_cup"" FROM ""year_by_year"" WHERE ""regular_season""='4th, Atlantic Division';",1-1046170-5236how many division  did not qualify for u.s. open cup in 2003,"CREATE TABLE ""year_by_year"" (237  ""year"" real,238  ""division"" text,239  ""league"" text,240  ""regular_season"" text,241  ""playoffs"" text,242  ""u_s_open_cup"" text243);","SELECT ""division"" FROM ""year_by_year"" WHERE ""u_s_open_cup""='Did Not Qualify' AND ""year""=2003;",1-1046170-5244which round is u.s. open cup division semifinals,"CREATE TABLE ""year_by_year"" (245  ""year"" real,246  ""division"" text,247  ""league"" text,248  ""regular_season"" text,249  ""playoffs"" text,250  ""u_s_open_cup"" text251);","SELECT ""u_s_open_cup"" FROM ""year_by_year"" WHERE ""playoffs""='Division Semifinals';",1-1046170-5252"what are all the playoffs for regular season is 1st, atlantic division","CREATE TABLE ""year_by_year"" (253  ""year"" real,254  ""division"" text,255  ""league"" text,256  ""regular_season"" text,257  ""playoffs"" text,258  ""u_s_open_cup"" text259);","SELECT ""playoffs"" FROM ""year_by_year"" WHERE ""regular_season""='1st, Atlantic Division';",1-1046170-5260what are all the playoffs for u.s. open cup in 1st round,"CREATE TABLE ""year_by_year"" (261  ""year"" real,262  ""division"" text,263  ""league"" text,264  ""regular_season"" text,265  ""playoffs"" text,266  ""u_s_open_cup"" text267);","SELECT ""playoffs"" FROM ""year_by_year"" WHERE ""u_s_open_cup""='1st Round';",1-1046170-5268what is the total number of 2nd leg where aggregate is 7-2,"CREATE TABLE ""european_record"" (269  ""season"" text,270  ""competition"" text,271  ""round"" text,272  ""opponents"" text,273  ""1st_leg"" text,274  ""2nd_leg"" text,275  ""aggregate"" text276);","SELECT COUNT(""2nd_leg"") FROM ""european_record"" WHERE ""aggregate""='7-2';",1-1061075-1277 what's the aggregate where 1st leg is 3–2,"CREATE TABLE ""european_record"" (278  ""season"" text,279  ""competition"" text,280  ""round"" text,281  ""opponents"" text,282  ""1st_leg"" text,283  ""2nd_leg"" text,284  ""aggregate"" text285);","SELECT ""aggregate"" FROM ""european_record"" WHERE ""1st_leg""='3–2';",1-1061075-1286 what's the competition where aggregate is 4–7,"CREATE TABLE ""european_record"" (287  ""season"" text,288  ""competition"" text,289  ""round"" text,290  ""opponents"" text,291  ""1st_leg"" text,292  ""2nd_leg"" text,293  ""aggregate"" text294);","SELECT ""competition"" FROM ""european_record"" WHERE ""aggregate""='4–7';",1-1061075-1295 what's the competition where 1st leg is 4-1 (h),"CREATE TABLE ""european_record"" (296  ""season"" text,297  ""competition"" text,298  ""round"" text,299  ""opponents"" text,300  ""1st_leg"" text,301  ""2nd_leg"" text,302  ""aggregate"" text303);","SELECT ""competition"" FROM ""european_record"" WHERE ""1st_leg""='4-1 (h)';",1-1061075-1304what is the total number of round where opponents is haugar,"CREATE TABLE ""european_record"" (305  ""season"" text,306  ""competition"" text,307  ""round"" text,308  ""opponents"" text,309  ""1st_leg"" text,310  ""2nd_leg"" text,311  ""aggregate"" text312);","SELECT COUNT(""round"") FROM ""european_record"" WHERE ""opponents""='Haugar';",1-1061075-1313 what's the 1st leg where opponents is galatasaray,"CREATE TABLE ""european_record"" (314  ""season"" text,315  ""competition"" text,316  ""round"" text,317  ""opponents"" text,318  ""1st_leg"" text,319  ""2nd_leg"" text,320  ""aggregate"" text321);","SELECT ""1st_leg"" FROM ""european_record"" WHERE ""opponents""='Galatasaray';",1-1061075-1322What is the highest Rd that Tom Sneva had the pole position in?,"CREATE TABLE ""race_results"" (323  ""rd"" real,324  ""name"" text,325  ""pole_position"" text,326  ""fastest_lap"" text,327  ""winning_driver"" text,328  ""winning_team"" text,329  ""report"" text330);","SELECT MAX(""rd"") FROM ""race_results"" WHERE ""pole_position""='Tom Sneva';",1-10706961-2331How many winning drivers were there in the race that had a fastest lap time of 56.920?,"CREATE TABLE ""race_results"" (332  ""rd"" real,333  ""name"" text,334  ""pole_position"" text,335  ""fastest_lap"" text,336  ""winning_driver"" text,337  ""winning_team"" text,338  ""report"" text339);","SELECT COUNT(""winning_driver"") FROM ""race_results"" WHERE ""fastest_lap""='56.920';",1-10706961-2340How many reports are there in the race that Forsythe Racing won and Teo Fabi had the pole position in?,"CREATE TABLE ""race_results"" (341  ""rd"" real,342  ""name"" text,343  ""pole_position"" text,344  ""fastest_lap"" text,345  ""winning_driver"" text,346  ""winning_team"" text,347  ""report"" text348);","SELECT COUNT(""report"") FROM ""race_results"" WHERE ""winning_team""='Forsythe Racing' AND ""pole_position""='Teo Fabi';",1-10706961-2349Which Rd took place at the Indianapolis 500?,"CREATE TABLE ""race_results"" (350  ""rd"" real,351  ""name"" text,352  ""pole_position"" text,353  ""fastest_lap"" text,354  ""winning_driver"" text,355  ""winning_team"" text,356  ""report"" text357);","SELECT ""rd"" FROM ""race_results"" WHERE ""name""='Indianapolis 500';",1-10706961-2358Which teams won when Bobby Rahal was their winning driver?,"CREATE TABLE ""race_results"" (359  ""rd"" real,360  ""name"" text,361  ""pole_position"" text,362  ""fastest_lap"" text,363  ""winning_driver"" text,364  ""winning_team"" text,365  ""report"" text366);","SELECT ""winning_team"" FROM ""race_results"" WHERE ""winning_driver""='Bobby Rahal';",1-10706961-2367What was the fastest lap time in the Escort Radar Warning 200?,"CREATE TABLE ""race_results"" (368  ""rd"" real,369  ""name"" text,370  ""pole_position"" text,371  ""fastest_lap"" text,372  ""winning_driver"" text,373  ""winning_team"" text,374  ""report"" text375);","SELECT ""fastest_lap"" FROM ""race_results"" WHERE ""name""='Escort Radar Warning 200';",1-10706961-2376What report was there for the porsche north america?,"CREATE TABLE ""races"" (377  ""rnd"" text,378  ""race_name"" text,379  ""circuit"" text,380  ""city_location"" text,381  ""date"" text,382  ""pole_position"" text,383  ""winning_driver"" text,384  ""winning_team"" text,385  ""report"" text386);","SELECT ""report"" FROM ""races"" WHERE ""winning_team""='Porsche North America';",1-10707176-2387What rnds were there for the phoenix international raceway?,"CREATE TABLE ""races"" (388  ""rnd"" text,389  ""race_name"" text,390  ""circuit"" text,391  ""city_location"" text,392  ""date"" text,393  ""pole_position"" text,394  ""winning_driver"" text,395  ""winning_team"" text,396  ""report"" text397);","SELECT ""rnd"" FROM ""races"" WHERE ""circuit""='Phoenix International Raceway';",1-10707176-2398Who was the pole position for the rnd equalling 12?,"CREATE TABLE ""races"" (399  ""rnd"" text,400  ""race_name"" text,401  ""circuit"" text,402  ""city_location"" text,403  ""date"" text,404  ""pole_position"" text,405  ""winning_driver"" text,406  ""winning_team"" text,407  ""report"" text408);","SELECT ""pole_position"" FROM ""races"" WHERE ""rnd""='12';",1-10707176-2409How many reports were the for the cleveland burke lakefront airport circut?,"CREATE TABLE ""races"" (410  ""rnd"" text,411  ""race_name"" text,412  ""circuit"" text,413  ""city_location"" text,414  ""date"" text,415  ""pole_position"" text,416  ""winning_driver"" text,417  ""winning_team"" text,418  ""report"" text419);","SELECT COUNT(""report"") FROM ""races"" WHERE ""circuit""='Cleveland Burke Lakefront Airport';",1-10707176-2420How many winning drivers were the for the rnd equalling 5?,"CREATE TABLE ""races"" (421  ""rnd"" text,422  ""race_name"" text,423  ""circuit"" text,424  ""city_location"" text,425  ""date"" text,426  ""pole_position"" text,427  ""winning_driver"" text,428  ""winning_team"" text,429  ""report"" text430);","SELECT COUNT(""winning_driver"") FROM ""races"" WHERE ""rnd""='5';",1-10707176-2431The race tony bettenhausen 200 has what smallest rd?,"CREATE TABLE ""race_results"" (432  ""rd"" real,433  ""name"" text,434  ""pole_position"" text,435  ""fastest_lap"" text,436  ""winning_driver"" text,437  ""winning_team"" text,438  ""report"" text439);","SELECT MIN(""rd"") FROM ""race_results"" WHERE ""name""='Tony Bettenhausen 200';",1-10706879-3440"The winning team of the race, los angeles times 500 is who?","CREATE TABLE ""race_results"" (441  ""rd"" real,442  ""name"" text,443  ""pole_position"" text,444  ""fastest_lap"" text,445  ""winning_driver"" text,446  ""winning_team"" text,447  ""report"" text448);","SELECT ""winning_team"" FROM ""race_results"" WHERE ""name""='Los Angeles Times 500';",1-10706879-3449How many winning drivers in the kraco twin 125 (r2) race were there?,"CREATE TABLE ""race_results"" (450  ""rd"" real,451  ""name"" text,452  ""pole_position"" text,453  ""fastest_lap"" text,454  ""winning_driver"" text,455  ""winning_team"" text,456  ""report"" text457);","SELECT COUNT(""winning_driver"") FROM ""race_results"" WHERE ""name""='Kraco Twin 125 (R2)';",1-10706879-3458What are the races that johnny rutherford has won?,"CREATE TABLE ""race_results"" (459  ""rd"" real,460  ""name"" text,461  ""pole_position"" text,462  ""fastest_lap"" text,463  ""winning_driver"" text,464  ""winning_team"" text,465  ""report"" text466);","SELECT ""name"" FROM ""race_results"" WHERE ""winning_driver""='Johnny Rutherford';",1-10706879-3467How many fastest laps were there for a rd that equals 10?,"CREATE TABLE ""race_results"" (468  ""rd"" real,469  ""name"" text,470  ""pole_position"" text,471  ""fastest_lap"" text,472  ""winning_driver"" text,473  ""winning_team"" text,474  ""report"" text475);","SELECT COUNT(""fastest_lap"") FROM ""race_results"" WHERE ""rd""=10;",1-10706879-3476What is the license award date for North East England?,"CREATE TABLE ""regional_ensembles"" (477  ""region"" text,478  ""operator"" text,479  ""licence_award_date"" text,480  ""on_air_date"" text,481  ""closure_date"" text482);","SELECT ""licence_award_date"" FROM ""regional_ensembles"" WHERE ""region""='North East England';",1-10712301-5483What is the percentage of growth in 2000-2008 in ethiopia?,"CREATE TABLE ""internet_availability"" (484  ""nation"" text,485  ""population_thousands"" real,486  ""internet_subscriptions_2000_thousands_of_users"" real,487  ""internet_subscriptions_2008_thousands_of_users"" real,488  ""pct_growth_2000_2008"" real,489  ""pct_internet_users"" real490);","SELECT ""pct_growth_2000_2008"" FROM ""internet_availability"" WHERE ""nation""='Ethiopia';",1-10733530-3491Name the total number of percentage growth 2000-2008 of uganda?,"CREATE TABLE ""internet_availability"" (492  ""nation"" text,493  ""population_thousands"" real,494  ""internet_subscriptions_2000_thousands_of_users"" real,495  ""internet_subscriptions_2008_thousands_of_users"" real,496  ""pct_growth_2000_2008"" real,497  ""pct_internet_users"" real498);","SELECT COUNT(""pct_growth_2000_2008"") FROM ""internet_availability"" WHERE ""nation""='Uganda';",1-10733530-3499What is the maximum percentage grown 2000-2008 in burundi,"CREATE TABLE ""internet_availability"" (500  ""nation"" text,501  ""population_thousands"" real,502  ""internet_subscriptions_2000_thousands_of_users"" real,503  ""internet_subscriptions_2008_thousands_of_users"" real,504  ""pct_growth_2000_2008"" real,505  ""pct_internet_users"" real506);","SELECT MAX(""pct_growth_2000_2008"") FROM ""internet_availability"" WHERE ""nation""='Burundi';",1-10733530-3507Provide me with the names of all the villages (German) that has 76.3% of Slovenes in 1951.,"CREATE TABLE ""politics"" (508  ""village_german"" text,509  ""village_slovenian"" text,510  ""number_of_people_1991"" real,511  ""percent_of_slovenes_1991"" text,512  ""percent_of_slovenes_1951"" text513);","SELECT ""village_german"" FROM ""politics"" WHERE ""percent_of_slovenes_1951""='76.3%';",1-10798421-1514Give me the minimum number of people in 1991 with 92.5% of Slovenes in 1991.,"CREATE TABLE ""politics"" (515  ""village_german"" text,516  ""village_slovenian"" text,517  ""number_of_people_1991"" real,518  ""percent_of_slovenes_1991"" text,519  ""percent_of_slovenes_1951"" text520);","SELECT MIN(""number_of_people_1991"") FROM ""politics"" WHERE ""percent_of_slovenes_1991""='92.5%';",1-10798421-1521Provide me with the name of all the village (German) that are part of the village (Slovenian) with sele srednji kot. ,"CREATE TABLE ""politics"" (522  ""village_german"" text,523  ""village_slovenian"" text,524  ""number_of_people_1991"" real,525  ""percent_of_slovenes_1991"" text,526  ""percent_of_slovenes_1951"" text527);","SELECT ""village_german"" FROM ""politics"" WHERE ""village_slovenian""='Sele Srednji Kot';",1-10798421-1528Provide me with the name of all the village (German) that are part of the village (Slovenian) with sele borovnica.,"CREATE TABLE ""politics"" (529  ""village_german"" text,530  ""village_slovenian"" text,531  ""number_of_people_1991"" real,532  ""percent_of_slovenes_1991"" text,533  ""percent_of_slovenes_1951"" text534);","SELECT ""village_german"" FROM ""politics"" WHERE ""village_slovenian""='Sele Borovnica';",1-10798421-1535Provide me with the name of the village (German) where there is 96.9% Slovenes in 1951. ,"CREATE TABLE ""politics"" (536  ""village_german"" text,537  ""village_slovenian"" text,538  ""number_of_people_1991"" real,539  ""percent_of_slovenes_1991"" text,540  ""percent_of_slovenes_1951"" text541);","SELECT ""village_german"" FROM ""politics"" WHERE ""percent_of_slovenes_1951""='96.9%';",1-10798421-1542Provide with the names of the village (German) that is part of village (Slovenian) with sele srednji kot.,"CREATE TABLE ""politics"" (543  ""village_german"" text,544  ""village_slovenian"" text,545  ""number_of_people_1991"" real,546  ""percent_of_slovenes_1991"" text,547  ""percent_of_slovenes_1951"" text548);","SELECT ""village_german"" FROM ""politics"" WHERE ""village_slovenian""='Sele Srednji Kot';",1-10798421-1549What was the score of the game on November 12?,"CREATE TABLE ""game_log"" (550  ""game"" real,551  ""date"" text,552  ""team"" text,553  ""score"" text,554  ""high_points"" text,555  ""high_rebounds"" text,556  ""high_assists"" text,557  ""location_attendance"" text,558  ""record"" text559);","SELECT ""score"" FROM ""game_log"" WHERE ""date""='November 12';",1-10812293-3560Who had high assists when they played against San Antonio?,"CREATE TABLE ""game_log"" (561  ""game"" real,562  ""date"" text,563  ""team"" text,564  ""score"" text,565  ""high_points"" text,566  ""high_rebounds"" text,567  ""high_assists"" text,568  ""location_attendance"" text,569  ""record"" text570);","SELECT ""high_assists"" FROM ""game_log"" WHERE ""team""='San Antonio';",1-10812293-3571Who scored the most points in game 4?,"CREATE TABLE ""game_log"" (572  ""game"" real,573  ""date"" text,574  ""team"" text,575  ""score"" text,576  ""high_points"" text,577  ""high_rebounds"" text,578  ""high_assists"" text,579  ""location_attendance"" text,580  ""record"" text581);","SELECT ""high_points"" FROM ""game_log"" WHERE ""game""=4;",1-10812293-3582Where was the game on November 20?,"CREATE TABLE ""game_log"" (583  ""game"" real,584  ""date"" text,585  ""team"" text,586  ""score"" text,587  ""high_points"" text,588  ""high_rebounds"" text,589  ""high_assists"" text,590  ""location_attendance"" text,591  ""record"" text592);","SELECT ""location_attendance"" FROM ""game_log"" WHERE ""date""='November 20';",1-10812293-3593The canadian airdate of 11 february 2008 applied to what series number?,"CREATE TABLE ""table1_10935205_1"" (594  ""no_in_season"" real,595  ""no_in_series"" real,596  ""title"" text,597  ""canadian_airdate"" text,598  ""us_airdate"" text,599  ""production_code"" real600);","SELECT COUNT(""no_in_series"") FROM ""table1_10935205_1"" WHERE ""canadian_airdate""='11 February 2008';",1-10935205-1601The U.S. airdate of 4 april 2008 had a production code of what?,"CREATE TABLE ""table1_10935205_1"" (602  ""no_in_season"" real,603  ""no_in_series"" real,604  ""title"" text,605  ""canadian_airdate"" text,606  ""us_airdate"" text,607  ""production_code"" real608);","SELECT MAX(""production_code"") FROM ""table1_10935205_1"" WHERE ""us_airdate""='4 April 2008';",1-10935205-1609"The episode titled ""don't stop believin'"" was what highest number of the season?","CREATE TABLE ""table1_10935205_1"" (610  ""no_in_season"" real,611  ""no_in_series"" real,612  ""title"" text,613  ""canadian_airdate"" text,614  ""us_airdate"" text,615  ""production_code"" real616);","SELECT MAX(""no_in_season"") FROM ""table1_10935205_1"" WHERE ""title""='\""Don''t Stop Believin''\""';",1-10935205-1617The U.S. airdate of 8 august 2008 also had canadian airdates of what?,"CREATE TABLE ""table1_10935205_1"" (618  ""no_in_season"" real,619  ""no_in_series"" real,620  ""title"" text,621  ""canadian_airdate"" text,622  ""us_airdate"" text,623  ""production_code"" real624);","SELECT ""canadian_airdate"" FROM ""table1_10935205_1"" WHERE ""us_airdate""='8 August 2008';",1-10935205-1625The canadian airdate of 17 march 2008 had how many numbers in the season?,"CREATE TABLE ""table1_10935205_1"" (626  ""no_in_season"" real,627  ""no_in_series"" real,628  ""title"" text,629  ""canadian_airdate"" text,630  ""us_airdate"" text,631  ""production_code"" real632);","SELECT COUNT(""no_in_season"") FROM ""table1_10935205_1"" WHERE ""canadian_airdate""='17 March 2008';",1-10935205-1633"For the episode(s) aired in the U.S. on 4 april 2008, what were the names?","CREATE TABLE ""table1_10935205_1"" (634  ""no_in_season"" real,635  ""no_in_series"" real,636  ""title"" text,637  ""canadian_airdate"" text,638  ""us_airdate"" text,639  ""production_code"" real640);","SELECT ""title"" FROM ""table1_10935205_1"" WHERE ""us_airdate""='4 April 2008';",1-10935205-1641"Who directed the episode ""Great Sexpectations (2)""?","CREATE TABLE ""season_5_1996_1997"" (642  ""no_in_series"" real,643  ""no_in_season"" real,644  ""title"" text,645  ""director"" text,646  ""writer_s"" text,647  ""original_air_date"" text,648  ""production_code"" text649);","SELECT ""director"" FROM ""season_5_1996_1997"" WHERE ""title""='\""Great Sexpectations (2)\""';",1-10953197-5650Which player from the 2004 CFL draft attended Wilfrid Laurier?,"CREATE TABLE ""round_two"" (651  ""pick_num"" real,652  ""cfl_team"" text,653  ""player"" text,654  ""position"" text,655  ""college"" text656);","SELECT ""player"" FROM ""round_two"" WHERE ""college""='Wilfrid Laurier';",1-10975034-2657What position does Christian Leibl-Cote play?,"CREATE TABLE ""round_two"" (658  ""pick_num"" real,659  ""cfl_team"" text,660  ""player"" text,661  ""position"" text,662  ""college"" text663);","SELECT ""position"" FROM ""round_two"" WHERE ""player""='Christian Leibl-Cote';",1-10975034-2664What is the pick number for Northwestern college?,"CREATE TABLE ""round_two"" (665  ""pick_num"" real,666  ""cfl_team"" text,667  ""player"" text,668  ""position"" text,669  ""college"" text670);","SELECT MAX(""pick_num"") FROM ""round_two"" WHERE ""college""='Northwestern';",1-10975034-2671How many foreigners in percentage terms had a population of 4.911?,"CREATE TABLE ""population_of_the_46_city_districts_on_3"" (672  ""no"" text,673  ""city_district_stadtteil"" text,674  ""area_in_km"" text,675  ""population"" text,676  ""foreign_nationals"" text,677  ""foreign_nationals_in_pct"" text,678  ""area_district_ortsbezirk"" text679);","SELECT COUNT(""foreign_nationals_in_pct"") FROM ""population_of_the_46_city_districts_on_3"" WHERE ""population""='4.911';",1-10992-3680What is the number of the city district of stadtteil where foreigners are 5.162?,"CREATE TABLE ""population_of_the_46_city_districts_on_3"" (681  ""no"" text,682  ""city_district_stadtteil"" text,683  ""area_in_km"" text,684  ""population"" text,685  ""foreign_nationals"" text,686  ""foreign_nationals_in_pct"" text,687  ""area_district_ortsbezirk"" text688);","SELECT COUNT(""city_district_stadtteil"") FROM ""population_of_the_46_city_districts_on_3"" WHERE ""foreign_nationals""='5.162';",1-10992-3689What is the city where the number is 47?,"CREATE TABLE ""population_of_the_46_city_districts_on_3"" (690  ""no"" text,691  ""city_district_stadtteil"" text,692  ""area_in_km"" text,693  ""population"" text,694  ""foreign_nationals"" text,695  ""foreign_nationals_in_pct"" text,696  ""area_district_ortsbezirk"" text697);","SELECT ""city_district_stadtteil"" FROM ""population_of_the_46_city_districts_on_3"" WHERE ""no""='47';",1-10992-3698Which leagues have Raiders as their mascot?,"CREATE TABLE ""current_members"" (699  ""school"" text,700  ""mascot"" text,701  ""location"" text,702  ""league"" text,703  ""enrollment"" real704);","SELECT ""league"" FROM ""current_members"" WHERE ""mascot""='Raiders';",1-11044765-1705Which leagues is the Galena school in?,"CREATE TABLE ""current_members"" (706  ""school"" text,707  ""mascot"" text,708  ""location"" text,709  ""league"" text,710  ""enrollment"" real711);","SELECT ""league"" FROM ""current_members"" WHERE ""school""='Galena';",1-11044765-1712What city and state is the Lancers mascot located?,"CREATE TABLE ""current_members"" (713  ""school"" text,714  ""mascot"" text,715  ""location"" text,716  ""league"" text,717  ""enrollment"" real718);","SELECT ""location"" FROM ""current_members"" WHERE ""mascot""='Lancers';",1-11044765-1719What city and state are the miners located in?,"CREATE TABLE ""current_members"" (720  ""school"" text,721  ""mascot"" text,722  ""location"" text,723  ""league"" text,724  ""enrollment"" real725);","SELECT ""location"" FROM ""current_members"" WHERE ""mascot""='Miners';",1-11044765-1726Which school has the Raiders as their mascot?,"CREATE TABLE ""current_members"" (727  ""school"" text,728  ""mascot"" text,729  ""location"" text,730  ""league"" text,731  ""enrollment"" real732);","SELECT ""school"" FROM ""current_members"" WHERE ""mascot""='Raiders';",1-11044765-1733"Where was the tournament dated nov 3, 2002?","CREATE TABLE ""lpga_tour_6"" (734  ""no"" real,735  ""date"" text,736  ""tournament"" text,737  ""winning_score"" text,738  ""to_par"" text,739  ""margin_of_victory"" text,740  ""runner_s_up"" text741);","SELECT ""tournament"" FROM ""lpga_tour_6"" WHERE ""date""='Nov 3, 2002';",1-1121352-2742"Where is the margin of victory dated mar 28, 2004?","CREATE TABLE ""lpga_tour_6"" (743  ""no"" real,744  ""date"" text,745  ""tournament"" text,746  ""winning_score"" text,747  ""to_par"" text,748  ""margin_of_victory"" text,749  ""runner_s_up"" text750);","SELECT ""margin_of_victory"" FROM ""lpga_tour_6"" WHERE ""date""='Mar 28, 2004';",1-1121352-2751"What is the to par dated may 4, 2003?","CREATE TABLE ""lpga_tour_6"" (752  ""no"" real,753  ""date"" text,754  ""tournament"" text,755  ""winning_score"" text,756  ""to_par"" text,757  ""margin_of_victory"" text,758  ""runner_s_up"" text759);","SELECT ""to_par"" FROM ""lpga_tour_6"" WHERE ""date""='May 4, 2003';",1-1121352-2760What date were the runner ups pat hurst juli inkster?,"CREATE TABLE ""lpga_tour_6"" (761  ""no"" real,762  ""date"" text,763  ""tournament"" text,764  ""winning_score"" text,765  ""to_par"" text,766  ""margin_of_victory"" text,767  ""runner_s_up"" text768);","SELECT ""date"" FROM ""lpga_tour_6"" WHERE ""runner_s_up""='Pat Hurst Juli Inkster';",1-1121352-2769what's the total number of final epbeingode count with character being rick stetler,"CREATE TABLE ""notable_enemies"" (770  ""character"" text,771  ""fate"" text,772  ""actor"" text,773  ""first_episode"" text,774  ""final_episode"" text,775  ""duration"" text,776  ""final_episode_count"" real777);","SELECT COUNT(""final_episode_count"") FROM ""notable_enemies"" WHERE ""character""='Rick Stetler';",1-11210576-4778"what are all the actor where first episode is ""ambush""","CREATE TABLE ""notable_enemies"" (779  ""character"" text,780  ""fate"" text,781  ""actor"" text,782  ""first_episode"" text,783  ""final_episode"" text,784  ""duration"" text,785  ""final_episode_count"" real786);","SELECT ""actor"" FROM ""notable_enemies"" WHERE ""first_episode""='\""Ambush\""';",1-11210576-4787what's the character with fate being deceased: knife wound,"CREATE TABLE ""notable_enemies"" (788  ""character"" text,789  ""fate"" text,790  ""actor"" text,791  ""first_episode"" text,792  ""final_episode"" text,793  ""duration"" text,794  ""final_episode_count"" real795);","SELECT ""character"" FROM ""notable_enemies"" WHERE ""fate""='Deceased: Knife Wound';",1-11210576-4796"what's the total number of final epbeingode count with first epbeingode being ""l.a.""","CREATE TABLE ""notable_enemies"" (797  ""character"" text,798  ""fate"" text,799  ""actor"" text,800  ""first_episode"" text,801  ""final_episode"" text,802  ""duration"" text,803  ""final_episode_count"" real804);","SELECT COUNT(""final_episode_count"") FROM ""notable_enemies"" WHERE ""first_episode""='\""L.A.\""';",1-11210576-4805what's the actor with character being judge joseph ratner,"CREATE TABLE ""notable_enemies"" (806  ""character"" text,807  ""fate"" text,808  ""actor"" text,809  ""first_episode"" text,810  ""final_episode"" text,811  ""duration"" text,812  ""final_episode_count"" real813);","SELECT ""actor"" FROM ""notable_enemies"" WHERE ""character""='Judge Joseph Ratner';",1-11210576-4814"what's the first epbeingode with final epbeingode being ""rio""","CREATE TABLE ""notable_enemies"" (815  ""character"" text,816  ""fate"" text,817  ""actor"" text,818  ""first_episode"" text,819  ""final_episode"" text,820  ""duration"" text,821  ""final_episode_count"" real822);","SELECT ""first_episode"" FROM ""notable_enemies"" WHERE ""final_episode""='\""Rio\""';",1-11210576-4823Which team was the second semi finalist in 2007?,"CREATE TABLE ""division_ii"" (824  ""year"" real,825  ""champion"" text,826  ""score"" text,827  ""runner_up"" text,828  ""location"" text,829  ""semi_finalist_num1"" text,830  ""semi_finalist_num2"" text831);","SELECT ""semi_finalist_num2"" FROM ""division_ii"" WHERE ""year""=2007;",1-11214772-2832How many teams were listed as runner up in 2005 and there the first semi finalist was Western Carolina?,"CREATE TABLE ""division_ii"" (833  ""year"" real,834  ""champion"" text,835  ""score"" text,836  ""runner_up"" text,837  ""location"" text,838  ""semi_finalist_num1"" text,839  ""semi_finalist_num2"" text840);","SELECT COUNT(""runner_up"") FROM ""division_ii"" WHERE ""semi_finalist_num1""='Western Carolina' AND ""year""=2005;",1-11214772-2841List the scores of all games when Miami were listed as the first Semi finalist,"CREATE TABLE ""division_ii"" (842  ""year"" real,843  ""champion"" text,844  ""score"" text,845  ""runner_up"" text,846  ""location"" text,847  ""semi_finalist_num1"" text,848  ""semi_finalist_num2"" text849);","SELECT ""score"" FROM ""division_ii"" WHERE ""semi_finalist_num1""='Miami';",1-11214772-2850"When Embry-Riddle made it to the first semi finalist slot, list all the runners up.","CREATE TABLE ""division_ii"" (851  ""year"" real,852  ""champion"" text,853  ""score"" text,854  ""runner_up"" text,855  ""location"" text,856  ""semi_finalist_num1"" text,857  ""semi_finalist_num2"" text858);","SELECT ""runner_up"" FROM ""division_ii"" WHERE ""semi_finalist_num1""='Embry-Riddle';",1-11214772-2859Where was the final game played in 2007,"CREATE TABLE ""division_ii"" (860  ""year"" real,861  ""champion"" text,862  ""score"" text,863  ""runner_up"" text,864  ""location"" text,865  ""semi_finalist_num1"" text,866  ""semi_finalist_num2"" text867);","SELECT ""location"" FROM ""division_ii"" WHERE ""year""=2007;",1-11214772-2868"Which round had Michael Schumacher in the pole position, David Coulthard with the fastest lap, and McLaren - Mercedes as the winning constructor?","CREATE TABLE ""grands_prix"" (869  ""round"" real,870  ""grand_prix"" text,871  ""pole_position"" text,872  ""fastest_lap"" text,873  ""winning_driver"" text,874  ""winning_constructor"" text,875  ""report"" text876);","SELECT COUNT(""round"") FROM ""grands_prix"" WHERE ""pole_position""='Michael Schumacher' AND ""fastest_lap""='David Coulthard' AND ""winning_constructor""='McLaren - Mercedes';",1-1132600-3877How many drivers won the Italian Grand Prix?,"CREATE TABLE ""grands_prix"" (878  ""round"" real,879  ""grand_prix"" text,880  ""pole_position"" text,881  ""fastest_lap"" text,882  ""winning_driver"" text,883  ""winning_constructor"" text,884  ""report"" text885);","SELECT COUNT(""winning_driver"") FROM ""grands_prix"" WHERE ""grand_prix""='Italian Grand Prix';",1-1132600-3886What was the report of the Belgian Grand Prix?,"CREATE TABLE ""grands_prix"" (887  ""round"" real,888  ""grand_prix"" text,889  ""pole_position"" text,890  ""fastest_lap"" text,891  ""winning_driver"" text,892  ""winning_constructor"" text,893  ""report"" text894);","SELECT ""report"" FROM ""grands_prix"" WHERE ""grand_prix""='Belgian Grand Prix';",1-1132600-3895Who had the fastest lap in the Belgian Grand Prix?,"CREATE TABLE ""grands_prix"" (896  ""round"" real,897  ""grand_prix"" text,898  ""pole_position"" text,899  ""fastest_lap"" text,900  ""winning_driver"" text,901  ""winning_constructor"" text,902  ""report"" text903);","SELECT ""fastest_lap"" FROM ""grands_prix"" WHERE ""grand_prix""='Belgian Grand Prix';",1-1132600-3904When was the date successor seated when the vacator was charles e. chamberlain (r)?,"CREATE TABLE ""table1_1134091_4"" (905  ""district"" text,906  ""vacator"" text,907  ""reason_for_change"" text,908  ""successor"" text,909  ""date_successor_seated"" text910);","SELECT ""date_successor_seated"" FROM ""table1_1134091_4"" WHERE ""vacator""='Charles E. Chamberlain (R)';",1-1134091-4911Who was the successor when the vacator was chester e. holifield (d)?,"CREATE TABLE ""table1_1134091_4"" (912  ""district"" text,913  ""vacator"" text,914  ""reason_for_change"" text,915  ""successor"" text,916  ""date_successor_seated"" text917);","SELECT ""successor"" FROM ""table1_1134091_4"" WHERE ""vacator""='Chester E. Holifield (D)';",1-1134091-4918When was the successor seated when the district was California 10th?,"CREATE TABLE ""table1_1134091_4"" (919  ""district"" text,920  ""vacator"" text,921  ""reason_for_change"" text,922  ""successor"" text,923  ""date_successor_seated"" text924);","SELECT ""date_successor_seated"" FROM ""table1_1134091_4"" WHERE ""district""='California 10th';",1-1134091-4925"Who was the vacator when the date successor seated was august 21, 1973?","CREATE TABLE ""table1_1134091_4"" (926  ""district"" text,927  ""vacator"" text,928  ""reason_for_change"" text,929  ""successor"" text,930  ""date_successor_seated"" text931);","SELECT ""vacator"" FROM ""table1_1134091_4"" WHERE ""date_successor_seated""='August 21, 1973';",1-1134091-4932"What was the district when the reason for change was died January 1, 1974?","CREATE TABLE ""table1_1134091_4"" (933  ""district"" text,934  ""vacator"" text,935  ""reason_for_change"" text,936  ""successor"" text,937  ""date_successor_seated"" text938);","SELECT ""district"" FROM ""table1_1134091_4"" WHERE ""reason_for_change""='Died January 1, 1974';",1-1134091-4939"Which routes have  ""replaced by US 81"" listed in their remarks section?","CREATE TABLE ""decommissioned_highways"" (940  ""route_name"" text,941  ""direction"" text,942  ""termini"" text,943  ""junctions"" text,944  ""length"" text,945  ""population_area"" text,946  ""remarks"" text947);","SELECT ""route_name"" FROM ""decommissioned_highways"" WHERE ""remarks""='Replaced by US 81';",1-11336756-6948"Which junctions have ""replaced by bsi-35"" listed in their remarks section?","CREATE TABLE ""decommissioned_highways"" (949  ""route_name"" text,950  ""direction"" text,951  ""termini"" text,952  ""junctions"" text,953  ""length"" text,954  ""population_area"" text,955  ""remarks"" text956);","SELECT ""junctions"" FROM ""decommissioned_highways"" WHERE ""remarks""='Replaced by BSI-35';",1-11336756-6957"How many junctions have ""replaced by bsi-35"" listed in their remarks section?","CREATE TABLE ""decommissioned_highways"" (958  ""route_name"" text,959  ""direction"" text,960  ""termini"" text,961  ""junctions"" text,962  ""length"" text,963  ""population_area"" text,964  ""remarks"" text965);","SELECT COUNT(""junctions"") FROM ""decommissioned_highways"" WHERE ""remarks""='Replaced by BSI-35';",1-11336756-6966"What unit of length is being used for the route with ""replaced by us 81"" in their remarks section?","CREATE TABLE ""decommissioned_highways"" (967  ""route_name"" text,968  ""direction"" text,969  ""termini"" text,970  ""junctions"" text,971  ""length"" text,972  ""population_area"" text,973  ""remarks"" text974);","SELECT ""length"" FROM ""decommissioned_highways"" WHERE ""remarks""='Replaced by US 81';",1-11336756-6975"Which population areas have ""replaced by us 83"" listed in their remarks section?","CREATE TABLE ""decommissioned_highways"" (976  ""route_name"" text,977  ""direction"" text,978  ""termini"" text,979  ""junctions"" text,980  ""length"" text,981  ""population_area"" text,982  ""remarks"" text983);","SELECT ""population_area"" FROM ""decommissioned_highways"" WHERE ""remarks""='Replaced by US 83';",1-11336756-6984"How many termini are there that have ""east west"" listed in their direction section, ""none"" listed in their junction section, and have a route name of ""sh 202""?","CREATE TABLE ""decommissioned_highways"" (985  ""route_name"" text,986  ""direction"" text,987  ""termini"" text,988  ""junctions"" text,989  ""length"" text,990  ""population_area"" text,991  ""remarks"" text992);","SELECT COUNT(""termini"") FROM ""decommissioned_highways"" WHERE ""direction""='East West' AND ""junctions""='none' AND ""route_name""='SH 202';",1-11336756-6993Give me the kickoff time of the game that was aired on CBS against the St. Louis Cardinals. ,"CREATE TABLE ""schedule"" (994  ""week"" text,995  ""date"" text,996  ""opponent"" text,997  ""result"" text,998  ""kickoff_a"" text,999  ""game_site"" text,1000  ""tv"" text,1001  ""attendance"" text,1002  ""record"" text1003);","SELECT ""kickoff_a"" FROM ""schedule"" WHERE ""tv""='CBS' AND ""opponent""='St. Louis Cardinals';",1-11449311-21004Find all the result(s) with the record of 2-13.,"CREATE TABLE ""schedule"" (1005  ""week"" text,1006  ""date"" text,1007  ""opponent"" text,1008  ""result"" text,1009  ""kickoff_a"" text,1010  ""game_site"" text,1011  ""tv"" text,1012  ""attendance"" text,1013  ""record"" text1014);","SELECT ""result"" FROM ""schedule"" WHERE ""record""='2-13';",1-11449311-21015What is the vault score for the total of 56.635?,"CREATE TABLE ""individual_all_around"" (1016  ""rank"" real,1017  ""gymnast"" text,1018  ""floor_exercise"" text,1019  ""pommel_horse"" text,1020  ""rings"" text,1021  ""vault"" text,1022  ""parallel_bars"" text,1023  ""horizontal_bar"" text,1024  ""total"" text1025);","SELECT ""vault"" FROM ""individual_all_around"" WHERE ""total""='56.635';",1-11542215-31026What is the total score when the score for floor exercise was 9.287?,"CREATE TABLE ""individual_all_around"" (1027  ""rank"" real,1028  ""gymnast"" text,1029  ""floor_exercise"" text,1030  ""pommel_horse"" text,1031  ""rings"" text,1032  ""vault"" text,1033  ""parallel_bars"" text,1034  ""horizontal_bar"" text,1035  ""total"" text1036);","SELECT ""total"" FROM ""individual_all_around"" WHERE ""floor_exercise""='9.287';",1-11542215-31037 what's the margin where runner(s)-up is phil mickelson,"CREATE TABLE ""wins_14"" (1038  ""year"" real,1039  ""championship"" text,1040  ""54_holes"" text,1041  ""winning_score"" text,1042  ""margin"" text,1043  ""runner_s_up"" text1044);","SELECT ""margin"" FROM ""wins_14"" WHERE ""runner_s_up""='Phil Mickelson';",1-11570261-11045 who is the runner(s)-up where 54 holes is tied for lead and margin is 5 strokes,"CREATE TABLE ""wins_14"" (1046  ""year"" real,1047  ""championship"" text,1048  ""54_holes"" text,1049  ""winning_score"" text,1050  ""margin"" text,1051  ""runner_s_up"" text1052);","SELECT ""runner_s_up"" FROM ""wins_14"" WHERE ""54_holes""='Tied for lead' AND ""margin""='5 strokes';",1-11570261-11053 what's the championship where 54 holes is 1 shot lead and runner(s)-up is chris dimarco,"CREATE TABLE ""wins_14"" (1054  ""year"" real,1055  ""championship"" text,1056  ""54_holes"" text,1057  ""winning_score"" text,1058  ""margin"" text,1059  ""runner_s_up"" text1060);","SELECT ""championship"" FROM ""wins_14"" WHERE ""54_holes""='1 shot lead' AND ""runner_s_up""='Chris DiMarco';",1-11570261-11061what is the minimum year where winning score is −8 (71-63-69-69=272),"CREATE TABLE ""wins_14"" (1062  ""year"" real,1063  ""championship"" text,1064  ""54_holes"" text,1065  ""winning_score"" text,1066  ""margin"" text,1067  ""runner_s_up"" text1068);","SELECT MIN(""year"") FROM ""wins_14"" WHERE ""winning_score""='−8 (71-63-69-69=272)';",1-11570261-11069 what's the championship where winning score is −12 (74-66-65-71=276),"CREATE TABLE ""wins_14"" (1070  ""year"" real,1071  ""championship"" text,1072  ""54_holes"" text,1073  ""winning_score"" text,1074  ""margin"" text,1075  ""runner_s_up"" text1076);","SELECT ""championship"" FROM ""wins_14"" WHERE ""winning_score""='−12 (74-66-65-71=276)';",1-11570261-11077 what's the 54 holes where winning score is −19 (67-66-67-69=269),"CREATE TABLE ""wins_14"" (1078  ""year"" real,1079  ""championship"" text,1080  ""54_holes"" text,1081  ""winning_score"" text,1082  ""margin"" text,1083  ""runner_s_up"" text1084);","SELECT ""54_holes"" FROM ""wins_14"" WHERE ""winning_score""='−19 (67-66-67-69=269)';",1-11570261-11085" what's the title where original air date is january18,2009","CREATE TABLE ""table1_11589522_3"" (1086  ""no_in_series"" real,1087  ""no_in_season"" real,1088  ""title"" text,1089  ""directed_by"" text,1090  ""written_by"" text,1091  ""original_air_date"" text1092);","SELECT ""title"" FROM ""table1_11589522_3"" WHERE ""original_air_date""='January18,2009';",1-11589522-31093 what's the original air date where written by is iain morris & damon beesley,"CREATE TABLE ""table1_11589522_3"" (1094  ""no_in_series"" real,1095  ""no_in_season"" real,1096  ""title"" text,1097  ""directed_by"" text,1098  ""written_by"" text,1099  ""original_air_date"" text1100);","SELECT ""original_air_date"" FROM ""table1_11589522_3"" WHERE ""written_by""='Iain Morris & Damon Beesley';",1-11589522-31101Which Allied Force targetted Woensdrecht?,"CREATE TABLE ""table1_1160161_12"" (1102  ""target"" text,1103  ""target_code_allied"" text,1104  ""luftwaffe_unit_wing"" text,1105  ""allied_forces"" text,1106  ""effect_on_allied_squadrons_according_to_official_figures"" text1107);","SELECT ""allied_forces"" FROM ""table1_1160161_12"" WHERE ""target""='Woensdrecht';",1-1160161-121108What is the allied target code of the group that targetted ghent/sint-denijs-westrem?,"CREATE TABLE ""table1_1160161_12"" (1109  ""target"" text,1110  ""target_code_allied"" text,1111  ""luftwaffe_unit_wing"" text,1112  ""allied_forces"" text,1113  ""effect_on_allied_squadrons_according_to_official_figures"" text1114);","SELECT ""target_code_allied"" FROM ""table1_1160161_12"" WHERE ""target""='Ghent/Sint-Denijs-Westrem';",1-1160161-121115What is the date of entry for the UK Albums Top 75 chart?,"CREATE TABLE ""table1_1160304_2"" (1116  ""chart"" text,1117  ""date_of_entry"" text,1118  ""entry_position"" real,1119  ""peak_position"" real,1120  ""weeks_on_peak"" real,1121  ""weeks_on_chart"" real,1122  ""date_of_exit"" text1123);","SELECT ""date_of_entry"" FROM ""table1_1160304_2"" WHERE ""chart""='UK Albums Top 75';",1-1160304-21124What was the total number of weeks on peak for the Ireland Albums Top 75 chart?,"CREATE TABLE ""table1_1160304_2"" (1125  ""chart"" text,1126  ""date_of_entry"" text,1127  ""entry_position"" real,1128  ""peak_position"" real,1129  ""weeks_on_peak"" real,1130  ""weeks_on_chart"" real,1131  ""date_of_exit"" text1132);","SELECT COUNT(""weeks_on_peak"") FROM ""table1_1160304_2"" WHERE ""chart""='Ireland Albums Top 75';",1-1160304-21133What is the exit date for the Dutch Albums Top 100 Chart?,"CREATE TABLE ""table1_1160304_2"" (1134  ""chart"" text,1135  ""date_of_entry"" text,1136  ""entry_position"" real,1137  ""peak_position"" real,1138  ""weeks_on_peak"" real,1139  ""weeks_on_chart"" real,1140  ""date_of_exit"" text1141);","SELECT ""date_of_exit"" FROM ""table1_1160304_2"" WHERE ""chart""='Dutch Albums Top 100';",1-1160304-21142what is the total number of constancy where purity is falling,"CREATE TABLE ""overview"" (1143  ""acquisition"" text,1144  ""knowledge"" text,1145  ""penance"" text,1146  ""permanence_of_the_body"" text,1147  ""constancy"" text,1148  ""purity"" text1149);","SELECT COUNT(""constancy"") FROM ""overview"" WHERE ""purity""='falling';",1-11609814-11150 what's the permanence of the body where purity is rudra,"CREATE TABLE ""overview"" (1151  ""acquisition"" text,1152  ""knowledge"" text,1153  ""penance"" text,1154  ""permanence_of_the_body"" text,1155  ""constancy"" text,1156  ""purity"" text1157);","SELECT ""permanence_of_the_body"" FROM ""overview"" WHERE ""purity""='Rudra';",1-11609814-11158 what's the permanence of the body where purity is apprehension,"CREATE TABLE ""overview"" (1159  ""acquisition"" text,1160  ""knowledge"" text,1161  ""penance"" text,1162  ""permanence_of_the_body"" text,1163  ""constancy"" text,1164  ""purity"" text1165);","SELECT ""permanence_of_the_body"" FROM ""overview"" WHERE ""purity""='apprehension';",1-11609814-11166 what's the permanence of the body where penance is the undifferenced,"CREATE TABLE ""overview"" (1167  ""acquisition"" text,1168  ""knowledge"" text,1169  ""penance"" text,1170  ""permanence_of_the_body"" text,1171  ""constancy"" text,1172  ""purity"" text1173);","SELECT ""permanence_of_the_body"" FROM ""overview"" WHERE ""penance""='the undifferenced';",1-11609814-11174 what's the constancy where permanence of the body is meditation,"CREATE TABLE ""overview"" (1175  ""acquisition"" text,1176  ""knowledge"" text,1177  ""penance"" text,1178  ""permanence_of_the_body"" text,1179  ""constancy"" text,1180  ""purity"" text1181);","SELECT ""constancy"" FROM ""overview"" WHERE ""permanence_of_the_body""='meditation';",1-11609814-11182 what's the permanence of the body where constancy is interestedness,"CREATE TABLE ""overview"" (1183  ""acquisition"" text,1184  ""knowledge"" text,1185  ""penance"" text,1186  ""permanence_of_the_body"" text,1187  ""constancy"" text,1188  ""purity"" text1189);","SELECT ""permanence_of_the_body"" FROM ""overview"" WHERE ""constancy""='interestedness';",1-11609814-11190"What is the original air dates for the title ""firestorm""?","CREATE TABLE ""season_6_2009_11"" (1191  ""series_num"" real,1192  ""season_num"" real,1193  ""title"" text,1194  ""directed_by"" text,1195  ""written_by"" text,1196  ""original_air_date"" text,1197  ""production_code"" real1198);","SELECT ""original_air_date"" FROM ""season_6_2009_11"" WHERE ""title""='\""Firestorm\""';",1-11630008-81199What is the title of the episode with the production code 624?,"CREATE TABLE ""season_6_2009_11"" (1200  ""series_num"" real,

Showing the first 1,200 of 70135 lines. Download the file for the rest.