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

1question,create_table_statement,sql_query,wiki_sql_table_id2What is terrence ross' nationality,"CREATE TABLE ""r"" (3  ""player"" text,4  ""no"" text,5  ""nationality"" text,6  ""position"" text,7  ""years_in_toronto"" text,8  ""school_club_team"" text9);","SELECT ""nationality"" FROM ""r"" WHERE ""player""='Terrence Ross';",1-10015132-1610What clu was in toronto 1995-96,"CREATE TABLE ""r"" (11  ""player"" text,12  ""no"" text,13  ""nationality"" text,14  ""position"" text,15  ""years_in_toronto"" text,16  ""school_club_team"" text17);","SELECT ""school_club_team"" FROM ""r"" WHERE ""years_in_toronto""='1995-96';",1-10015132-1618which club was in toronto 2003-06,"CREATE TABLE ""r"" (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 ""r"" WHERE ""years_in_toronto""='2003-06';",1-10015132-1626how many schools or teams had jalen rose,"CREATE TABLE ""r"" (27  ""player"" text,28  ""no"" text,29  ""nationality"" text,30  ""position"" text,31  ""years_in_toronto"" text,32  ""school_club_team"" text33);","SELECT COUNT(""school_club_team"") FROM ""r"" WHERE ""player""='Jalen Rose';",1-10015132-1634Where was Assen held?,"CREATE TABLE ""season_calendar"" (35  ""no"" real,36  ""date"" text,37  ""round"" text,38  ""circuit"" text,39  ""pole_position"" text,40  ""fastest_lap"" text,41  ""race_winner"" text,42  ""report"" text43);","SELECT ""round"" FROM ""season_calendar"" WHERE ""circuit""='Assen';",1-10083598-144What was the number of race that Kevin Curtain won?,"CREATE TABLE ""season_calendar"" (45  ""no"" real,46  ""date"" text,47  ""round"" text,48  ""circuit"" text,49  ""pole_position"" text,50  ""fastest_lap"" text,51  ""race_winner"" text,52  ""report"" text53);","SELECT COUNT(""no"") FROM ""season_calendar"" WHERE ""pole_position""='Kevin Curtain';",1-10083598-154What was the date of the race in Misano?,"CREATE TABLE ""season_calendar"" (55  ""no"" real,56  ""date"" text,57  ""round"" text,58  ""circuit"" text,59  ""pole_position"" text,60  ""fastest_lap"" text,61  ""race_winner"" text,62  ""report"" text63);","SELECT ""date"" FROM ""season_calendar"" WHERE ""circuit""='Misano';",1-10083598-164How many different positions did Sherbrooke Faucons (qmjhl) provide in the draft?,"CREATE TABLE ""round_two"" (65  ""pick"" real,66  ""player"" text,67  ""position"" text,68  ""nationality"" text,69  ""nhl_team"" text,70  ""college_junior_club_team"" text71);","SELECT COUNT(""position"") FROM ""round_two"" WHERE ""college_junior_club_team""='Sherbrooke Faucons (QMJHL)';",1-1013129-272What are the nationalities of the player picked from Thunder Bay Flyers (ushl),"CREATE TABLE ""round_two"" (73  ""pick"" real,74  ""player"" text,75  ""position"" text,76  ""nationality"" text,77  ""nhl_team"" text,78  ""college_junior_club_team"" text79);","SELECT ""nationality"" FROM ""round_two"" WHERE ""college_junior_club_team""='Thunder Bay Flyers (USHL)';",1-1013129-280How many different college/junior/club teams provided a player to the Washington Capitals NHL Team?,"CREATE TABLE ""round_two"" (81  ""pick"" real,82  ""player"" text,83  ""position"" text,84  ""nationality"" text,85  ""nhl_team"" text,86  ""college_junior_club_team"" text87);","SELECT COUNT(""college_junior_club_team"") FROM ""round_two"" WHERE ""nhl_team""='Washington Capitals';",1-1013129-288How many different nationalities do the players of New Jersey Devils come from?,"CREATE TABLE ""round_three"" (89  ""pick"" real,90  ""player"" text,91  ""position"" text,92  ""nationality"" text,93  ""nhl_team"" text,94  ""college_junior_club_team"" text95);","SELECT COUNT(""nationality"") FROM ""round_three"" WHERE ""nhl_team""='New Jersey Devils';",1-1013129-396What's Dorain Anneck's pick number?,"CREATE TABLE ""round_three"" (97  ""pick"" real,98  ""player"" text,99  ""position"" text,100  ""nationality"" text,101  ""nhl_team"" text,102  ""college_junior_club_team"" text103);","SELECT ""pick"" FROM ""round_three"" WHERE ""player""='Dorain Anneck';",1-1013129-3104What is the nationality of the player from Vancouver Canucks?,"CREATE TABLE ""round_three"" (105  ""pick"" real,106  ""player"" text,107  ""position"" text,108  ""nationality"" text,109  ""nhl_team"" text,110  ""college_junior_club_team"" text111);","SELECT ""nationality"" FROM ""round_three"" WHERE ""nhl_team""='Vancouver Canucks';",1-1013129-3112What's the pick number of the player from Springfield Olympics (Nejhl)?,"CREATE TABLE ""round_three"" (113  ""pick"" real,114  ""player"" text,115  ""position"" text,116  ""nationality"" text,117  ""nhl_team"" text,118  ""college_junior_club_team"" text119);","SELECT ""pick"" FROM ""round_three"" WHERE ""college_junior_club_team""='Springfield Olympics (NEJHL)';",1-1013129-3120"When were the ships launched that were laid down on september 1, 1964?","CREATE TABLE ""echo_ii_class_significant_dates"" (121  ""num"" text,122  ""shipyard"" text,123  ""laid_down"" text,124  ""launched"" text,125  ""commissioned"" text,126  ""fleet"" text,127  ""status"" text128);","SELECT ""launched"" FROM ""echo_ii_class_significant_dates"" WHERE ""laid_down""='September 1, 1964';",1-1014206-2129"List the # for ships commissioned on december 18, 1965.","CREATE TABLE ""echo_ii_class_significant_dates"" (130  ""num"" text,131  ""shipyard"" text,132  ""laid_down"" text,133  ""launched"" text,134  ""commissioned"" text,135  ""fleet"" text,136  ""status"" text137);","SELECT ""num"" FROM ""echo_ii_class_significant_dates"" WHERE ""commissioned""='December 18, 1965';",1-1014206-2138"List the # for ships commissioned on september 30, 1967.","CREATE TABLE ""echo_ii_class_significant_dates"" (139  ""num"" text,140  ""shipyard"" text,141  ""laid_down"" text,142  ""launched"" text,143  ""commissioned"" text,144  ""fleet"" text,145  ""status"" text146);","SELECT ""num"" FROM ""echo_ii_class_significant_dates"" WHERE ""commissioned""='September 30, 1967';",1-1014206-2147"When were ships laid down that were commissioned on october 29, 1965?","CREATE TABLE ""echo_ii_class_significant_dates"" (148  ""num"" text,149  ""shipyard"" text,150  ""laid_down"" text,151  ""launched"" text,152  ""commissioned"" text,153  ""fleet"" text,154  ""status"" text155);","SELECT ""laid_down"" FROM ""echo_ii_class_significant_dates"" WHERE ""commissioned""='October 29, 1965';",1-1014206-2156 What could a spanish coronel be addressed as in the commonwealth military?,"CREATE TABLE ""table1_1015521_2"" (157  ""equivalent_nato_rank_code"" text,158  ""rank_in_spanish"" text,159  ""rank_in_english"" text,160  ""commonwealth_equivalent"" text,161  ""us_air_force_equivalent"" text162);","SELECT ""commonwealth_equivalent"" FROM ""table1_1015521_2"" WHERE ""rank_in_spanish""='Coronel';",1-1015521-2163Give me a list of all spanish officer titles that could receive recognition as group captain in english,"CREATE TABLE ""table1_1015521_2"" (164  ""equivalent_nato_rank_code"" text,165  ""rank_in_spanish"" text,166  ""rank_in_english"" text,167  ""commonwealth_equivalent"" text,168  ""us_air_force_equivalent"" text169);","SELECT ""rank_in_english"" FROM ""table1_1015521_2"" WHERE ""commonwealth_equivalent""='Group Captain';",1-1015521-2170If you are a pilot officer in the commonwealth then what will you called as in the US air force?,"CREATE TABLE ""table1_1015521_2"" (171  ""equivalent_nato_rank_code"" text,172  ""rank_in_spanish"" text,173  ""rank_in_english"" text,174  ""commonwealth_equivalent"" text,175  ""us_air_force_equivalent"" text176);","SELECT ""us_air_force_equivalent"" FROM ""table1_1015521_2"" WHERE ""commonwealth_equivalent""='Pilot Officer';",1-1015521-2177If you're a major general in the US air force then what ranking will you receive in the commonwealth's air force?,"CREATE TABLE ""table1_1015521_2"" (178  ""equivalent_nato_rank_code"" text,179  ""rank_in_spanish"" text,180  ""rank_in_english"" text,181  ""commonwealth_equivalent"" text,182  ""us_air_force_equivalent"" text183);","SELECT ""commonwealth_equivalent"" FROM ""table1_1015521_2"" WHERE ""us_air_force_equivalent""='Major General';",1-1015521-2184If you get a ranking as major in the  english military then what would the spanish military address you as? ,"CREATE TABLE ""table1_1015521_2"" (185  ""equivalent_nato_rank_code"" text,186  ""rank_in_spanish"" text,187  ""rank_in_english"" text,188  ""commonwealth_equivalent"" text,189  ""us_air_force_equivalent"" text190);","SELECT ""rank_in_spanish"" FROM ""table1_1015521_2"" WHERE ""rank_in_english""='Major';",1-1015521-2191Which wrestlers have had 2 reigns?,"CREATE TABLE ""table1_10182508_5"" (192  ""rank_each_wrestlers_total_number_of_days_as_champion_are_ranked_highest_to_lowest_wrestlers_with_the_same_number_mean_that_they_are_tied_for_that_certain_rank"" real,193  ""wrestler"" text,194  ""num_of_reigns"" real,195  ""combined_defenses"" real,196  ""combined_days"" text197);","SELECT ""wrestler"" FROM ""table1_10182508_5"" WHERE ""num_of_reigns""=2;",1-10182508-5198"In terms of reigns, what is the lowest number listed?","CREATE TABLE ""table1_10182508_5"" (199  ""rank_each_wrestlers_total_number_of_days_as_champion_are_ranked_highest_to_lowest_wrestlers_with_the_same_number_mean_that_they_are_tied_for_that_certain_rank"" real,200  ""wrestler"" text,201  ""num_of_reigns"" real,202  ""combined_defenses"" real,203  ""combined_days"" text204);","SELECT MIN(""num_of_reigns"") FROM ""table1_10182508_5"";",1-10182508-5205What rank was Bryan Danielson in this chart?,"CREATE TABLE ""table1_10182508_5"" (206  ""rank_each_wrestlers_total_number_of_days_as_champion_are_ranked_highest_to_lowest_wrestlers_with_the_same_number_mean_that_they_are_tied_for_that_certain_rank"" real,207  ""wrestler"" text,208  ""num_of_reigns"" real,209  ""combined_defenses"" real,210  ""combined_days"" text211);","SELECT ""rank_each_wrestlers_total_number_of_days_as_champion_are_ranked_highest_to_lowest_wrestlers_with_the_same_number_mean_that_they_are_tied_for_that_certain_rank"" FROM ""table1_10182508_5"" WHERE ""wrestler""='Bryan Danielson';",1-10182508-5212How many combined days did Go Shiozaki have?,"CREATE TABLE ""table1_10182508_5"" (213  ""rank_each_wrestlers_total_number_of_days_as_champion_are_ranked_highest_to_lowest_wrestlers_with_the_same_number_mean_that_they_are_tied_for_that_certain_rank"" real,214  ""wrestler"" text,215  ""num_of_reigns"" real,216  ""combined_defenses"" real,217  ""combined_days"" text218);","SELECT ""combined_days"" FROM ""table1_10182508_5"" WHERE ""wrestler""='Go Shiozaki';",1-10182508-5219What was Go Shiozaki's rank?,"CREATE TABLE ""table1_10182508_5"" (220  ""rank_each_wrestlers_total_number_of_days_as_champion_are_ranked_highest_to_lowest_wrestlers_with_the_same_number_mean_that_they_are_tied_for_that_certain_rank"" real,221  ""wrestler"" text,222  ""num_of_reigns"" real,223  ""combined_defenses"" real,224  ""combined_days"" text225);","SELECT MIN(""rank_each_wrestlers_total_number_of_days_as_champion_are_ranked_highest_to_lowest_wrestlers_with_the_same_number_mean_that_they_are_tied_for_that_certain_rank"") FROM ""table1_10182508_5"" WHERE ""wrestler""='Go Shiozaki';",1-10182508-5226Which province is grey and bell electorate in,"CREATE TABLE ""initial_composition_of_the_2nd_parliamen"" (227  ""member"" text,228  ""electorate"" text,229  ""province"" text,230  ""m_ps_term"" text,231  ""election_date"" text232);","SELECT ""province"" FROM ""initial_composition_of_the_2nd_parliamen"" WHERE ""electorate""='Grey and Bell';",1-1024710-2233Which province is bay of islands in,"CREATE TABLE ""initial_composition_of_the_2nd_parliamen"" (234  ""member"" text,235  ""electorate"" text,236  ""province"" text,237  ""m_ps_term"" text,238  ""election_date"" text239);","SELECT ""province"" FROM ""initial_composition_of_the_2nd_parliamen"" WHERE ""electorate""='Bay of Islands';",1-1024710-2240what is the total number of total w–l where doubles w–l is 11–11,"CREATE TABLE ""players"" (241  ""player"" text,242  ""total_w_l"" text,243  ""singles_w_l"" text,244  ""doubles_w_l"" text,245  ""ties_played"" real,246  ""debut"" real,247  ""years_played"" real248);","SELECT COUNT(""total_w_l"") FROM ""players"" WHERE ""doubles_w_l""='11–11';",1-10294071-1249what is the total number of singles w–l where doubles w–l is 11–14,"CREATE TABLE ""players"" (250  ""player"" text,251  ""total_w_l"" text,252  ""singles_w_l"" text,253  ""doubles_w_l"" text,254  ""ties_played"" real,255  ""debut"" real,256  ""years_played"" real257);","SELECT COUNT(""singles_w_l"") FROM ""players"" WHERE ""doubles_w_l""='11–14';",1-10294071-1258 what's the total w–l where player is boro jovanović category:articles with hcards,"CREATE TABLE ""players"" (259  ""player"" text,260  ""total_w_l"" text,261  ""singles_w_l"" text,262  ""doubles_w_l"" text,263  ""ties_played"" real,264  ""debut"" real,265  ""years_played"" real266);","SELECT ""total_w_l"" FROM ""players"" WHERE ""player""='Boro Jovanović Category:Articles with hCards';",1-10294071-1267what is the maximum ties played where player is josip palada category:articles with hcards,"CREATE TABLE ""players"" (268  ""player"" text,269  ""total_w_l"" text,270  ""singles_w_l"" text,271  ""doubles_w_l"" text,272  ""ties_played"" real,273  ""debut"" real,274  ""years_played"" real275);","SELECT MAX(""ties_played"") FROM ""players"" WHERE ""player""='Josip Palada Category:Articles with hCards';",1-10294071-1276what is the total number of ties played where total w–l is 38–24,"CREATE TABLE ""players"" (277  ""player"" text,278  ""total_w_l"" text,279  ""singles_w_l"" text,280  ""doubles_w_l"" text,281  ""ties_played"" real,282  ""debut"" real,283  ""years_played"" real284);","SELECT COUNT(""ties_played"") FROM ""players"" WHERE ""total_w_l""='38–24';",1-10294071-1285"What is the Frequency at the Market/Rank of Burlington - Plattsburgh , Vermont - New York /143?","CREATE TABLE ""affiliates"" (286  ""calls"" text,287  ""frequency"" text,288  ""branding"" text,289  ""format"" text,290  ""market_rank"" text,291  ""timeslot"" text,292  ""group_owner"" text293);","SELECT COUNT(""frequency"") FROM ""affiliates"" WHERE ""market_rank""='Burlington - Plattsburgh , Vermont - New York /143';",1-10333757-1294"What is the Branding for Group Owner Qantam of Cape Cod, LLC?","CREATE TABLE ""affiliates"" (295  ""calls"" text,296  ""frequency"" text,297  ""branding"" text,298  ""format"" text,299  ""market_rank"" text,300  ""timeslot"" text,301  ""group_owner"" text302);","SELECT ""branding"" FROM ""affiliates"" WHERE ""group_owner""='Qantam of Cape Cod, LLC';",1-10333757-1303What Branding does WRKO calls use?,"CREATE TABLE ""affiliates"" (304  ""calls"" text,305  ""frequency"" text,306  ""branding"" text,307  ""format"" text,308  ""market_rank"" text,309  ""timeslot"" text,310  ""group_owner"" text311);","SELECT ""branding"" FROM ""affiliates"" WHERE ""calls""='WRKO';",1-10333757-1312What is the Format for Branding of 1290 wkbk w281au 104.1?,"CREATE TABLE ""affiliates"" (313  ""calls"" text,314  ""frequency"" text,315  ""branding"" text,316  ""format"" text,317  ""market_rank"" text,318  ""timeslot"" text,319  ""group_owner"" text320);","SELECT ""format"" FROM ""affiliates"" WHERE ""branding""='1290 WKBK W281AU 104.1';",1-10333757-1321Which Market/Rank is associated with WCRN calls?,"CREATE TABLE ""affiliates"" (322  ""calls"" text,323  ""frequency"" text,324  ""branding"" text,325  ""format"" text,326  ""market_rank"" text,327  ""timeslot"" text,328  ""group_owner"" text329);","SELECT ""market_rank"" FROM ""affiliates"" WHERE ""calls""='WCRN';",1-10333757-1330Which Frequency is used for WEGP calls?,"CREATE TABLE ""affiliates"" (331  ""calls"" text,332  ""frequency"" text,333  ""branding"" text,334  ""format"" text,335  ""market_rank"" text,336  ""timeslot"" text,337  ""group_owner"" text338);","SELECT ""frequency"" FROM ""affiliates"" WHERE ""calls""='WEGP';",1-10333757-1339What is the regulated retail price for the tariff code ff0 prs?,"CREATE TABLE ""table1_10408617_5"" (340  ""scheme"" text,341  ""tariff_code"" text,342  ""b_ts_retail_price_regulated"" text,343  ""approx_premium"" text,344  ""prefixes"" text345);","SELECT ""b_ts_retail_price_regulated"" FROM ""table1_10408617_5"" WHERE ""tariff_code""='ff0 PRS';",1-10408617-5346What is the premium associated with tariff code g9?,"CREATE TABLE ""table1_10408617_5"" (347  ""scheme"" text,348  ""tariff_code"" text,349  ""b_ts_retail_price_regulated"" text,350  ""approx_premium"" text,351  ""prefixes"" text352);","SELECT ""approx_premium"" FROM ""table1_10408617_5"" WHERE ""tariff_code""='g9';",1-10408617-5353How many tariff codes have a bts retail price of 2p/min or inclusive?,"CREATE TABLE ""table1_10408617_5"" (354  ""scheme"" text,355  ""tariff_code"" text,356  ""b_ts_retail_price_regulated"" text,357  ""approx_premium"" text,358  ""prefixes"" text359);","SELECT COUNT(""tariff_code"") FROM ""table1_10408617_5"" WHERE ""b_ts_retail_price_regulated""='2p/min or inclusive';",1-10408617-5360How many tariff codes have a bts retail price of 2.553p/min?,"CREATE TABLE ""table1_10408617_5"" (361  ""scheme"" text,362  ""tariff_code"" text,363  ""b_ts_retail_price_regulated"" text,364  ""approx_premium"" text,365  ""prefixes"" text366);","SELECT COUNT(""tariff_code"") FROM ""table1_10408617_5"" WHERE ""b_ts_retail_price_regulated""='2.553p/min';",1-10408617-5367"What prefixes are priced at pence per minute, fixed at all times with a premium of 3p/min?","CREATE TABLE ""table1_10408617_5"" (368  ""scheme"" text,369  ""tariff_code"" text,370  ""b_ts_retail_price_regulated"" text,371  ""approx_premium"" text,372  ""prefixes"" text373);","SELECT ""prefixes"" FROM ""table1_10408617_5"" WHERE ""scheme""='Pence per minute, fixed at all times' AND ""approx_premium""='3p/min';",1-10408617-5374What is the bts retail price (regulated) for tariff code g10?,"CREATE TABLE ""table1_10408617_5"" (375  ""scheme"" text,376  ""tariff_code"" text,377  ""b_ts_retail_price_regulated"" text,378  ""approx_premium"" text,379  ""prefixes"" text380);","SELECT ""b_ts_retail_price_regulated"" FROM ""table1_10408617_5"" WHERE ""tariff_code""='g10';",1-10408617-5381What is the tone for gen.sing. plague?,"CREATE TABLE ""history_and_exceptions"" (382  ""nominative"" text,383  ""old_orthography"" text,384  ""new_orthography"" text,385  ""e_or_ipa"" text,386  ""tone_latvian_notation_level_broken"" text,387  ""translation"" text388);","SELECT ""tone_latvian_notation_level_broken"" FROM ""history_and_exceptions"" WHERE ""translation""='Gen.Sing. plague';",1-10409754-5389What is the smallest possible radius?,"CREATE TABLE ""prominent_stars_in_pismis_24"" (390  ""star_pismis24_num"" text,391  ""spectral_type"" text,392  ""magnitude_m_bol"" text,393  ""temperature_k"" real,394  ""radius_r"" real,395  ""mass_m"" real396);","SELECT MIN(""radius_r"") FROM ""prominent_stars_in_pismis_24"";",1-10432351-1397What are all the spectral types for star mismis24-# is 1sw?,"CREATE TABLE ""prominent_stars_in_pismis_24"" (398  ""star_pismis24_num"" text,399  ""spectral_type"" text,400  ""magnitude_m_bol"" text,401  ""temperature_k"" real,402  ""radius_r"" real,403  ""mass_m"" real404);","SELECT ""spectral_type"" FROM ""prominent_stars_in_pismis_24"" WHERE ""star_pismis24_num""='1SW';",1-10432351-1405"If a radius is 10, what  is the lowest possible mass?","CREATE TABLE ""prominent_stars_in_pismis_24"" (406  ""star_pismis24_num"" text,407  ""spectral_type"" text,408  ""magnitude_m_bol"" text,409  ""temperature_k"" real,410  ""radius_r"" real,411  ""mass_m"" real412);","SELECT MIN(""mass_m"") FROM ""prominent_stars_in_pismis_24"" WHERE ""radius_r""=10;",1-10432351-1413What percentage of seats were filled in 2006?,"CREATE TABLE ""financial_and_operational_statistics"" (414  ""year"" real,415  ""aircraft_kilometers"" real,416  ""departures"" real,417  ""flying_hours"" real,418  ""passengers"" real,419  ""seat_factor"" text,420  ""employees"" real,421  ""profit_loss"" text422);","SELECT ""seat_factor"" FROM ""financial_and_operational_statistics"" WHERE ""year""=2006;",1-105344-2423How many hours were flown in each of the years where more than 64379058.0 kilometers were flown?,"CREATE TABLE ""financial_and_operational_statistics"" (424  ""year"" real,425  ""aircraft_kilometers"" real,426  ""departures"" real,427  ""flying_hours"" real,428  ""passengers"" real,429  ""seat_factor"" text,430  ""employees"" real,431  ""profit_loss"" text432);","SELECT ""flying_hours"" FROM ""financial_and_operational_statistics"" WHERE ""aircraft_kilometers"">64379058.0;",1-105344-2433"Of the years that had exactly 17096 departures, what is the greatest number of aircraft kilometers flown?","CREATE TABLE ""financial_and_operational_statistics"" (434  ""year"" real,435  ""aircraft_kilometers"" real,436  ""departures"" real,437  ""flying_hours"" real,438  ""passengers"" real,439  ""seat_factor"" text,440  ""employees"" real,441  ""profit_loss"" text442);","SELECT MAX(""aircraft_kilometers"") FROM ""financial_and_operational_statistics"" WHERE ""departures""=17096;",1-105344-2443Which winning team beat the New York Yankees?,"CREATE TABLE ""list_of_winners"" (444  ""year"" real,445  ""game_or_event"" text,446  ""date_contested"" text,447  ""league_or_governing_body"" text,448  ""sport"" text,449  ""winning_team"" text,450  ""losing_team"" text,451  ""final_score"" text452);","SELECT ""winning_team"" FROM ""list_of_winners"" WHERE ""losing_team""='New York Yankees';",1-10548224-1453"What was the final score for the game that was contested on February 1, 2009?","CREATE TABLE ""list_of_winners"" (454  ""year"" real,455  ""game_or_event"" text,456  ""date_contested"" text,457  ""league_or_governing_body"" text,458  ""sport"" text,459  ""winning_team"" text,460  ""losing_team"" text,461  ""final_score"" text462);","SELECT ""final_score"" FROM ""list_of_winners"" WHERE ""date_contested""='February 1, 2009';",1-10548224-1463What sport had a final score of 3-2?,"CREATE TABLE ""list_of_winners"" (464  ""year"" real,465  ""game_or_event"" text,466  ""date_contested"" text,467  ""league_or_governing_body"" text,468  ""sport"" text,469  ""winning_team"" text,470  ""losing_team"" text,471  ""final_score"" text472);","SELECT ""sport"" FROM ""list_of_winners"" WHERE ""final_score""='3-2';",1-10548224-1473"Who was the winning team of the game that was contested on February 1, 2009?","CREATE TABLE ""list_of_winners"" (474  ""year"" real,475  ""game_or_event"" text,476  ""date_contested"" text,477  ""league_or_governing_body"" text,478  ""sport"" text,479  ""winning_team"" text,480  ""losing_team"" text,481  ""final_score"" text482);","SELECT ""winning_team"" FROM ""list_of_winners"" WHERE ""date_contested""='February 1, 2009';",1-10548224-1483"Who was the losing team of the game that was contested on February 1, 2004?","CREATE TABLE ""list_of_winners"" (484  ""year"" real,485  ""game_or_event"" text,486  ""date_contested"" text,487  ""league_or_governing_body"" text,488  ""sport"" text,489  ""winning_team"" text,490  ""losing_team"" text,491  ""final_score"" text492);","SELECT ""losing_team"" FROM ""list_of_winners"" WHERE ""date_contested""='February 1, 2004';",1-10548224-1493what's the minimum total with crop (kilotonnes) being s lupin,"CREATE TABLE ""crops"" (494  ""crop_kilotonnes"" text,495  ""new_south_wales"" real,496  ""victoria"" real,497  ""queensland"" real,498  ""western_australia"" real,499  ""south_australia"" real,500  ""tasmania"" real,501  ""total"" real502);","SELECT MIN(""total"") FROM ""crops"" WHERE ""crop_kilotonnes""='s Lupin';",1-1057262-2503what's the new south wales with crop (kilotonnes) being canola,"CREATE TABLE ""crops"" (504  ""crop_kilotonnes"" text,505  ""new_south_wales"" real,506  ""victoria"" real,507  ""queensland"" real,508  ""western_australia"" real,509  ""south_australia"" real,510  ""tasmania"" real,511  ""total"" real512);","SELECT ""new_south_wales"" FROM ""crops"" WHERE ""crop_kilotonnes""='Canola';",1-1057262-2513what's the total number of south australia with victoria value of 2173,"CREATE TABLE ""crops"" (514  ""crop_kilotonnes"" text,515  ""new_south_wales"" real,516  ""victoria"" real,517  ""queensland"" real,518  ""western_australia"" real,519  ""south_australia"" real,520  ""tasmania"" real,521  ""total"" real522);","SELECT COUNT(""south_australia"") FROM ""crops"" WHERE ""victoria""=2173;",1-1057262-2523what's the minimum tasmania value,"CREATE TABLE ""crops"" (524  ""crop_kilotonnes"" text,525  ""new_south_wales"" real,526  ""victoria"" real,527  ""queensland"" real,528  ""western_australia"" real,529  ""south_australia"" real,530  ""tasmania"" real,531  ""total"" real532);","SELECT MIN(""tasmania"") FROM ""crops"";",1-1057262-2533what's the total number of tasmania with new south wales crop of 190 kilotonnes,"CREATE TABLE ""crops"" (534  ""crop_kilotonnes"" text,535  ""new_south_wales"" real,536  ""victoria"" real,537  ""queensland"" real,538  ""western_australia"" real,539  ""south_australia"" real,540  ""tasmania"" real,541  ""total"" real542);","SELECT COUNT(""tasmania"") FROM ""crops"" WHERE ""new_south_wales""=190;",1-1057262-2543How many significant relationships list Will as a virtue?,"CREATE TABLE ""the_stages"" (544  ""approximate_age"" text,545  ""virtues"" text,546  ""psycho_social_crisis"" text,547  ""significant_relationship"" text,548  ""existential_question_not_in_citation_given"" text,549  ""examples"" text550);","SELECT COUNT(""significant_relationship"") FROM ""the_stages"" WHERE ""virtues""='Will';",1-1058787-1551"Which examples ask the existential question ""Can I Love?""","CREATE TABLE ""the_stages"" (552  ""approximate_age"" text,553  ""virtues"" text,554  ""psycho_social_crisis"" text,555  ""significant_relationship"" text,556  ""existential_question_not_in_citation_given"" text,557  ""examples"" text558);","SELECT ""examples"" FROM ""the_stages"" WHERE ""existential_question_not_in_citation_given""='Can I Love?';",1-1058787-1559How many countries got 796.7 points?,"CREATE TABLE ""table1_1059743_2"" (560  ""rank"" real,561  ""member_association"" text,562  ""points"" text,563  ""group_stage"" real,564  ""play_off"" real,565  ""afc_cup"" real566);","SELECT COUNT(""rank"") FROM ""table1_1059743_2"" WHERE ""points""='796.7';",1-1059743-2567In what group stage were 177.2 points awarded?,"CREATE TABLE ""table1_1059743_2"" (568  ""rank"" real,569  ""member_association"" text,570  ""points"" text,571  ""group_stage"" real,572  ""play_off"" real,573  ""afc_cup"" real574);","SELECT COUNT(""group_stage"") FROM ""table1_1059743_2"" WHERE ""points""='177.2';",1-1059743-2575What is the lowest group to earn 886.6 points?,"CREATE TABLE ""table1_1059743_2"" (576  ""rank"" real,577  ""member_association"" text,578  ""points"" text,579  ""group_stage"" real,580  ""play_off"" real,581  ""afc_cup"" real582);","SELECT MIN(""group_stage"") FROM ""table1_1059743_2"" WHERE ""points""='886.6';",1-1059743-2583How many countries earned 177.2 points?,"CREATE TABLE ""table1_1059743_2"" (584  ""rank"" real,585  ""member_association"" text,586  ""points"" text,587  ""group_stage"" real,588  ""play_off"" real,589  ""afc_cup"" real590);","SELECT COUNT(""member_association"") FROM ""table1_1059743_2"" WHERE ""points""='177.2';",1-1059743-2591If % lunsford is 51.82% what is the % mcconnell in Letcher?,"CREATE TABLE ""results_breakdown"" (592  ""county"" text,593  ""precincts"" real,594  ""lunsford"" real,595  ""pct_lunsford"" text,596  ""mc_connell"" real,597  ""pct_mc_connell"" text,598  ""total"" text599);","SELECT ""pct_mc_connell"" FROM ""results_breakdown"" WHERE ""pct_lunsford""='51.82%';",1-10586064-2600"What country had the total 18,900 (r)?","CREATE TABLE ""results_breakdown"" (601  ""county"" text,602  ""precincts"" real,603  ""lunsford"" real,604  ""pct_lunsford"" text,605  ""mc_connell"" real,606  ""pct_mc_connell"" text,607  ""total"" text608);","SELECT ""county"" FROM ""results_breakdown"" WHERE ""total""='18,900 (R)';",1-10586064-2609When % mcconnell is 44.54% what are the total number of counties?,"CREATE TABLE ""results_breakdown"" (610  ""county"" text,611  ""precincts"" real,612  ""lunsford"" real,613  ""pct_lunsford"" text,614  ""mc_connell"" real,615  ""pct_mc_connell"" text,616  ""total"" text617);","SELECT COUNT(""county"") FROM ""results_breakdown"" WHERE ""pct_mc_connell""='44.54%';",1-10586064-2618If % mcconnell is 47.17% what is the total number of mcconnell ?,"CREATE TABLE ""results_breakdown"" (619  ""county"" text,620  ""precincts"" real,621  ""lunsford"" real,622  ""pct_lunsford"" text,623  ""mc_connell"" real,624  ""pct_mc_connell"" text,625  ""total"" text626);","SELECT COUNT(""mc_connell"") FROM ""results_breakdown"" WHERE ""pct_mc_connell""='47.17%';",1-10586064-2627What is the county of precints 515?,"CREATE TABLE ""results_breakdown"" (628  ""county"" text,629  ""precincts"" real,630  ""lunsford"" real,631  ""pct_lunsford"" text,632  ""mc_connell"" real,633  ""pct_mc_connell"" text,634  ""total"" text635);","SELECT ""county"" FROM ""results_breakdown"" WHERE ""precincts""=515;",1-10586064-2636Which city has a capacity of 41903?,"CREATE TABLE ""under_construction"" (637  ""stadium"" text,638  ""capacity"" real,639  ""city"" text,640  ""country"" text,641  ""tenant"" text,642  ""opening"" real643);","SELECT ""city"" FROM ""under_construction"" WHERE ""capacity""=41903;",1-10601843-2644What is the maximum capacity of the Otkrytie Arena stadium?,"CREATE TABLE ""under_construction"" (645  ""stadium"" text,646  ""capacity"" real,647  ""city"" text,648  ""country"" text,649  ""tenant"" text,650  ""opening"" real651);","SELECT MAX(""capacity"") FROM ""under_construction"" WHERE ""stadium""='Otkrytie Arena';",1-10601843-2652When did the stadium where Bursaspor is the tenant open?,"CREATE TABLE ""under_construction"" (653  ""stadium"" text,654  ""capacity"" real,655  ""city"" text,656  ""country"" text,657  ""tenant"" text,658  ""opening"" real659);","SELECT MIN(""opening"") FROM ""under_construction"" WHERE ""tenant""='Bursaspor';",1-10601843-2660How many tenants are there in the city of Samsun?,"CREATE TABLE ""under_construction"" (661  ""stadium"" text,662  ""capacity"" real,663  ""city"" text,664  ""country"" text,665  ""tenant"" text,666  ""opening"" real667);","SELECT COUNT(""tenant"") FROM ""under_construction"" WHERE ""city""='Samsun';",1-10601843-2668"what's the original air date with title  ""hell""","CREATE TABLE ""table1_10610087_5"" (669  ""no_in_series"" real,670  ""no_in_season"" real,671  ""title"" text,672  ""directed_by"" text,673  ""written_by"" text,674  ""original_air_date"" text675);","SELECT ""original_air_date"" FROM ""table1_10610087_5"" WHERE ""title""='\""Hell\""';",1-10610087-5676What is the percentage of the Shivalik Zone where the percentage of the Mid-Hill Zone is 10%?,"CREATE TABLE ""references"" (677  ""particulars_and_characteristics"" text,678  ""shivalik_zone"" text,679  ""mid_hill_zone"" text,680  ""high_hill_zone"" text,681  ""trance_n_himalaya_zone"" text682);","SELECT ""shivalik_zone"" FROM ""references"" WHERE ""mid_hill_zone""='10%';",1-10638523-1683For mid-hill zone  what is the altitude?,"CREATE TABLE ""references"" (684  ""particulars_and_characteristics"" text,685  ""shivalik_zone"" text,686  ""mid_hill_zone"" text,687  ""high_hill_zone"" text,688  ""trance_n_himalaya_zone"" text689);","SELECT ""mid_hill_zone"" FROM ""references"" WHERE ""particulars_and_characteristics""='Altitude';",1-10638523-1690What are the climatic conditions for the trance- n himalaya zone?,"CREATE TABLE ""references"" (691  ""particulars_and_characteristics"" text,692  ""shivalik_zone"" text,693  ""mid_hill_zone"" text,694  ""high_hill_zone"" text,695  ""trance_n_himalaya_zone"" text696);","SELECT ""trance_n_himalaya_zone"" FROM ""references"" WHERE ""particulars_and_characteristics""='Climatic conditions';",1-10638523-1697What is the percentage of the  trance- n himalaya zone that corresponds with the high hill zone is 25%?,"CREATE TABLE ""references"" (698  ""particulars_and_characteristics"" text,699  ""shivalik_zone"" text,700  ""mid_hill_zone"" text,701  ""high_hill_zone"" text,702  ""trance_n_himalaya_zone"" text703);","SELECT ""trance_n_himalaya_zone"" FROM ""references"" WHERE ""high_hill_zone""='25%';",1-10638523-1704What is the state of Ted Stevens?,"CREATE TABLE ""senate_time"" (705  ""total_tenure_rank"" real,706  ""uninterrupted_rank"" real,707  ""name"" text,708  ""state_represented"" text,709  ""dates_of_service"" text,710  ""total_tenure_time"" text,711  ""uninterrupted_time"" text712);","SELECT ""state_represented"" FROM ""senate_time"" WHERE ""name""='Ted Stevens';",1-10644188-3713What's the standard of the country who won its first title in 1992?,"CREATE TABLE ""table1_10682862_68"" (714  ""country"" text,715  ""players"" real,716  ""standard"" real,717  ""minor"" real,718  ""first_title"" real,719  ""last_title"" real720);","SELECT MAX(""standard"") FROM ""table1_10682862_68"" WHERE ""first_title""=1992;",1-10682862-68721What's the smallest number of players?,"CREATE TABLE ""table1_10682862_68"" (722  ""country"" text,723  ""players"" real,724  ""standard"" real,725  ""minor"" real,726  ""first_title"" real,727  ""last_title"" real728);","SELECT MIN(""players"") FROM ""table1_10682862_68"";",1-10682862-68729"In what year was the last last title received, by any of the countries?","CREATE TABLE ""table1_10682862_68"" (730  ""country"" text,731  ""players"" real,732  ""standard"" real,733  ""minor"" real,734  ""first_title"" real,735  ""last_title"" real736);","SELECT MAX(""last_title"") FROM ""table1_10682862_68"";",1-10682862-68737What religious groups made up 0.72% of the Indian population in 2001?,"CREATE TABLE ""statistics"" (738  ""religious_group"" text,739  ""population_pct_1961"" text,740  ""population_pct_1971"" text,741  ""population_pct_1981"" text,742  ""population_pct_1991"" text,743  ""population_pct_2001"" text744);","SELECT ""religious_group"" FROM ""statistics"" WHERE ""population_pct_2001""='0.72%';",1-10710364-1745What is the original air date for episode 15 of season 6?,"CREATE TABLE ""table1_10718868_2"" (746  ""no_in_series"" real,747  ""no_in_season"" real,748  ""title"" text,749  ""directed_by"" text,750  ""written_by"" text,751  ""original_air_date"" text,752  ""u_s_viewers_millions"" text753);","SELECT ""original_air_date"" FROM ""table1_10718868_2"" WHERE ""no_in_season""=15;",1-10718868-2754"How many episodes in season 6 titles ""Poppin' Tags""?","CREATE TABLE ""table1_10718868_2"" (755  ""no_in_series"" real,756  ""no_in_season"" real,757  ""title"" text,758  ""directed_by"" text,759  ""written_by"" text,760  ""original_air_date"" text,761  ""u_s_viewers_millions"" text762);","SELECT COUNT(""no_in_season"") FROM ""table1_10718868_2"" WHERE ""title""='\""Poppin'' Tags\""';",1-10718868-2763Which podiums did the Williams team have with a margin of defeat of 2?,"CREATE TABLE ""by_season"" (764  ""season"" real,765  ""driver"" text,766  ""team"" text,767  ""engine"" text,768  ""poles"" real,769  ""wins"" real,770  ""podiums"" real,771  ""points"" text,772  ""margin_of_defeat"" text773);","SELECT ""podiums"" FROM ""by_season"" WHERE ""team""='Williams' AND ""margin_of_defeat""='2';",1-10753917-1774How many drivers on the williams team had a margin of defeat of 2?,"CREATE TABLE ""by_season"" (775  ""season"" real,776  ""driver"" text,777  ""team"" text,778  ""engine"" text,779  ""poles"" real,780  ""wins"" real,781  ""podiums"" real,782  ""points"" text,783  ""margin_of_defeat"" text784);","SELECT COUNT(""driver"") FROM ""by_season"" WHERE ""team""='Williams' AND ""margin_of_defeat""='2';",1-10753917-1785How many seasons was clay regazzoni the driver?,"CREATE TABLE ""by_season"" (786  ""season"" real,787  ""driver"" text,788  ""team"" text,789  ""engine"" text,790  ""poles"" real,791  ""wins"" real,792  ""podiums"" real,793  ""points"" text,794  ""margin_of_defeat"" text795);","SELECT COUNT(""season"") FROM ""by_season"" WHERE ""driver""='Clay Regazzoni';",1-10753917-1796Which margin of defeats had points of 30?,"CREATE TABLE ""by_season"" (797  ""season"" real,798  ""driver"" text,799  ""team"" text,800  ""engine"" text,801  ""poles"" real,802  ""wins"" real,803  ""podiums"" real,804  ""points"" text,805  ""margin_of_defeat"" text806);","SELECT ""margin_of_defeat"" FROM ""by_season"" WHERE ""points""='30';",1-10753917-1807Which podiums did the alfa romeo team have?,"CREATE TABLE ""by_season"" (808  ""season"" real,809  ""driver"" text,810  ""team"" text,811  ""engine"" text,812  ""poles"" real,813  ""wins"" real,814  ""podiums"" real,815  ""points"" text,816  ""margin_of_defeat"" text817);","SELECT ""podiums"" FROM ""by_season"" WHERE ""team""='Alfa Romeo';",1-10753917-1818What was the percent of slovenes 1951 for bach?,"CREATE TABLE ""references"" (819  ""village_german"" text,820  ""village_slovene"" text,821  ""number_of_people_1991"" real,822  ""percent_of_slovenes_1991"" text,823  ""percent_of_slovenes_1951"" text824);","SELECT ""percent_of_slovenes_1951"" FROM ""references"" WHERE ""village_german""='Bach';",1-10797636-1825What college's team is the Saskatchewan Roughriders?,"CREATE TABLE ""round_four"" (826  ""pick_num"" real,827  ""cfl_team"" text,828  ""player"" text,829  ""position"" text,830  ""college"" text831);","SELECT ""college"" FROM ""round_four"" WHERE ""cfl_team""='Saskatchewan Roughriders';",1-10812403-4832What position did Calvin Mccarty play?,"CREATE TABLE ""round_four"" (833  ""pick_num"" real,834  ""cfl_team"" text,835  ""player"" text,836  ""position"" text,837  ""college"" text838);","SELECT ""position"" FROM ""round_four"" WHERE ""player""='Calvin McCarty';",1-10812403-4839How many people were pick #30?,"CREATE TABLE ""round_four"" (840  ""pick_num"" real,841  ""cfl_team"" text,842  ""player"" text,843  ""position"" text,844  ""college"" text845);","SELECT COUNT(""position"") FROM ""round_four"" WHERE ""pick_num""=30;",1-10812403-4846What college did Calvin McCarty play at?,"CREATE TABLE ""round_four"" (847  ""pick_num"" real,848  ""cfl_team"" text,849  ""player"" text,850  ""position"" text,851  ""college"" text852);","SELECT ""college"" FROM ""round_four"" WHERE ""player""='Calvin McCarty';",1-10812403-4853What college had a LB in the draft?,"CREATE TABLE ""round_four"" (854  ""pick_num"" real,855  ""cfl_team"" text,856  ""player"" text,857  ""position"" text,858  ""college"" text859);","SELECT ""college"" FROM ""round_four"" WHERE ""position""='LB';",1-10812403-4860Who got high assists for the game played on February 9?,"CREATE TABLE ""game_log"" (861  ""game"" real,862  ""date"" text,863  ""team"" text,864  ""score"" text,865  ""high_points"" text,866  ""high_rebounds"" text,867  ""high_assists"" text,868  ""location_attendance"" text,869  ""record"" text870);","SELECT ""high_assists"" FROM ""game_log"" WHERE ""date""='February 9';",1-10812293-6871Which lava domes erupted or had a growth episode during the Holocene period?,"CREATE TABLE ""table1_1081235_1"" (872  ""name_of_lava_dome"" text,873  ""country"" text,874  ""volcanic_area"" text,875  ""composition"" text,876  ""last_eruption_or_growth_episode"" text877);","SELECT ""name_of_lava_dome"" FROM ""table1_1081235_1"" WHERE ""last_eruption_or_growth_episode""='Holocene';",1-1081235-1878What is the composition at Valles lava dome?,"CREATE TABLE ""table1_1081235_1"" (879  ""name_of_lava_dome"" text,880  ""country"" text,881  ""volcanic_area"" text,882  ""composition"" text,883  ""last_eruption_or_growth_episode"" text884);","SELECT ""composition"" FROM ""table1_1081235_1"" WHERE ""name_of_lava_dome""='Valles lava dome';",1-1081235-1885How many countries are the Tata Sabaya Lava domes located in?,"CREATE TABLE ""table1_1081235_1"" (886  ""name_of_lava_dome"" text,887  ""country"" text,888  ""volcanic_area"" text,889  ""composition"" text,890  ""last_eruption_or_growth_episode"" text891);","SELECT COUNT(""country"") FROM ""table1_1081235_1"" WHERE ""name_of_lava_dome""='Tata Sabaya lava domes';",1-1081235-1892What countries have had eruptions of growth episodes in 1986?,"CREATE TABLE ""table1_1081235_1"" (893  ""name_of_lava_dome"" text,894  ""country"" text,895  ""volcanic_area"" text,896  ""composition"" text,897  ""last_eruption_or_growth_episode"" text898);","SELECT ""country"" FROM ""table1_1081235_1"" WHERE ""last_eruption_or_growth_episode""='1986';",1-1081235-1899Who is the lyricist for the song with a length of 3:05?,"CREATE TABLE ""soundtrack"" (900  ""track_num"" real,901  ""song"" text,902  ""singers"" text,903  ""picturization"" text,904  ""length"" text,905  ""lyricist"" text906);","SELECT ""lyricist"" FROM ""soundtrack"" WHERE ""length""='3:05';",1-10848177-1907What song has a length of 3:05?,"CREATE TABLE ""soundtrack"" (908  ""track_num"" real,909  ""song"" text,910  ""singers"" text,911  ""picturization"" text,912  ""length"" text,913  ""lyricist"" text914);","SELECT ""song"" FROM ""soundtrack"" WHERE ""length""='3:05';",1-10848177-1915Which lyricist has a song with a length of 6:14?,"CREATE TABLE ""soundtrack"" (916  ""track_num"" real,917  ""song"" text,918  ""singers"" text,919  ""picturization"" text,920  ""length"" text,921  ""lyricist"" text922);","SELECT ""lyricist"" FROM ""soundtrack"" WHERE ""length""='6:14';",1-10848177-1923What is the highest track number?,"CREATE TABLE ""soundtrack"" (924  ""track_num"" real,925  ""song"" text,926  ""singers"" text,927  ""picturization"" text,928  ""length"" text,929  ""lyricist"" text930);","SELECT MAX(""track_num"") FROM ""soundtrack"";",1-10848177-1931Which song has picturization by only vijay?,"CREATE TABLE ""soundtrack"" (932  ""track_num"" real,933  ""song"" text,934  ""singers"" text,935  ""picturization"" text,936  ""length"" text,937  ""lyricist"" text938);","SELECT ""song"" FROM ""soundtrack"" WHERE ""picturization""='Vijay';",1-10848177-1939For which singers was Alangudi Somu the lyricist?,"CREATE TABLE ""soundtrack"" (940  ""track_num"" real,941  ""song"" text,942  ""singers"" text,943  ""picturization"" text,944  ""length"" text,945  ""lyricist"" text946);","SELECT ""singers"" FROM ""soundtrack"" WHERE ""lyricist""='Alangudi Somu';",1-10848177-1947What publishers were involved with product number SCUS-97265?,"CREATE TABLE ""table1_10875694_11"" (948  ""title"" text,949  ""system"" text,950  ""publisher"" text,951  ""product_no"" text,952  ""compatible_with_20_60_gb_ntsc_ps3_cecha_cechb"" text,953  ""compatible_with_60_gb_pal_80_gb_ntsc_ps3_cechc_ceche"" text954);","SELECT ""publisher"" FROM ""table1_10875694_11"" WHERE ""product_no""='SCUS-97265';",1-10875694-11955What is the total number of James Bond 007: Everything or Nothing for each system?,"CREATE TABLE ""table1_10875694_11"" (956  ""title"" text,957  ""system"" text,958  ""publisher"" text,959  ""product_no"" text,960  ""compatible_with_20_60_gb_ntsc_ps3_cecha_cechb"" text,961  ""compatible_with_60_gb_pal_80_gb_ntsc_ps3_cechc_ceche"" text962);","SELECT COUNT(""system"") FROM ""table1_10875694_11"" WHERE ""title""='James Bond 007: Everything or Nothing';",1-10875694-11963"How many products have the title ""Jak 3""?","CREATE TABLE ""table1_10875694_11"" (964  ""title"" text,965  ""system"" text,966  ""publisher"" text,967  ""product_no"" text,968  ""compatible_with_20_60_gb_ntsc_ps3_cecha_cechb"" text,969  ""compatible_with_60_gb_pal_80_gb_ntsc_ps3_cechc_ceche"" text970);","SELECT COUNT(""product_no"") FROM ""table1_10875694_11"" WHERE ""title""='Jak 3';",1-10875694-11971Which James Bond 007: Agent Under Fire from Electronic Arts is compatible with 60 gb pal/80 gb NTSC PS3 (CECHC/CECHE)?,"CREATE TABLE ""table1_10875694_11"" (972  ""title"" text,973  ""system"" text,974  ""publisher"" text,975  ""product_no"" text,976  ""compatible_with_20_60_gb_ntsc_ps3_cecha_cechb"" text,977  ""compatible_with_60_gb_pal_80_gb_ntsc_ps3_cechc_ceche"" text978);","SELECT ""compatible_with_60_gb_pal_80_gb_ntsc_ps3_cechc_ceche"" FROM ""table1_10875694_11"" WHERE ""publisher""='Electronic Arts' AND ""title""='James Bond 007: Agent Under Fire';",1-10875694-11979What publishers produce product number SLUS-20265?,"CREATE TABLE ""table1_10875694_11"" (980  ""title"" text,981  ""system"" text,982  ""publisher"" text,983  ""product_no"" text,984  ""compatible_with_20_60_gb_ntsc_ps3_cecha_cechb"" text,985  ""compatible_with_60_gb_pal_80_gb_ntsc_ps3_cechc_ceche"" text986);","SELECT ""publisher"" FROM ""table1_10875694_11"" WHERE ""product_no""='SLUS-20265';",1-10875694-11987How many titles have the product number SCUS-97330?,"CREATE TABLE ""table1_10875694_11"" (988  ""title"" text,989  ""system"" text,990  ""publisher"" text,991  ""product_no"" text,992  ""compatible_with_20_60_gb_ntsc_ps3_cecha_cechb"" text,993  ""compatible_with_60_gb_pal_80_gb_ntsc_ps3_cechc_ceche"" text994);","SELECT COUNT(""title"") FROM ""table1_10875694_11"" WHERE ""product_no""='SCUS-97330';",1-10875694-11995What is  the status when livery is blue?,"CREATE TABLE ""preservation"" (996  ""vehicle_numbers"" text,997  ""vehicle_types"" text,998  ""livery"" text,999  ""location"" text,1000  ""status"" text1001);","SELECT ""status"" FROM ""preservation"" WHERE ""livery""='Blue';",1-1090916-21002What is the location when the status is in service as coaching stock?,"CREATE TABLE ""preservation"" (1003  ""vehicle_numbers"" text,1004  ""vehicle_types"" text,1005  ""livery"" text,1006  ""location"" text,1007  ""status"" text1008);","SELECT ""location"" FROM ""preservation"" WHERE ""status""='In service as coaching stock';",1-1090916-21009What was the first season of the club who last won a title in 2012?,"CREATE TABLE ""clubs"" (1010  ""club"" text,1011  ""position_in_2012"" text,1012  ""first_season"" text,1013  ""number_of_seasons"" real,1014  ""first_season_of_current_spell"" real,1015  ""titles"" real,1016  ""last_title"" text1017);","SELECT ""first_season"" FROM ""clubs"" WHERE ""last_title""='2012';",1-1096793-11018What was the first season of the club that in 2012 was 2nd in Superettan?,"CREATE TABLE ""clubs"" (1019  ""club"" text,1020  ""position_in_2012"" text,1021  ""first_season"" text,1022  ""number_of_seasons"" real,1023  ""first_season_of_current_spell"" real,1024  ""titles"" real,1025  ""last_title"" text1026);","SELECT ""first_season"" FROM ""clubs"" WHERE ""position_in_2012""='2nd in Superettan';",1-1096793-11027What was the first season for the club that in 2012 was 2nd in Superettan?,"CREATE TABLE ""clubs"" (1028  ""club"" text,1029  ""position_in_2012"" text,1030  ""first_season"" text,1031  ""number_of_seasons"" real,1032  ""first_season_of_current_spell"" real,1033  ""titles"" real,1034  ""last_title"" text1035);","SELECT ""first_season"" FROM ""clubs"" WHERE ""position_in_2012""='2nd in Superettan';",1-1096793-11036"How many series are named ""Lockdown""?","CREATE TABLE ""table1_11075747_3"" (1037  ""series_num"" real,1038  ""episode_num"" real,1039  ""title"" text,1040  ""directed_by"" text,1041  ""written_by"" text,1042  ""original_air_date"" text1043);","SELECT COUNT(""series_num"") FROM ""table1_11075747_3"" WHERE ""title""='\""Lockdown\""';",1-11075747-31044"Who directed the second episode of ""The Homecoming"" which was written by Tommy Thompson?","CREATE TABLE ""table1_11075747_3"" (1045  ""series_num"" real,1046  ""episode_num"" real,1047  ""title"" text,1048  ""directed_by"" text,1049  ""written_by"" text,1050  ""original_air_date"" text1051);","SELECT ""directed_by"" FROM ""table1_11075747_3"" WHERE ""written_by""='Tommy Thompson';",1-11075747-31052"What was the latest episode of ""House of Cards""?","CREATE TABLE ""table1_11075747_3"" (1053  ""series_num"" real,1054  ""episode_num"" real,1055  ""title"" text,1056  ""directed_by"" text,1057  ""written_by"" text,1058  ""original_air_date"" text1059);","SELECT MAX(""episode_num"") FROM ""table1_11075747_3"" WHERE ""title""='\""House of Cards\""';",1-11075747-31060What percentage of The Bronx voters occured when Manhattan had 29.9% of voters?,"CREATE TABLE ""1953"" (1061  ""1953"" text,1062  ""party"" text,1063  ""manhattan"" text,1064  ""the_bronx"" text,1065  ""brooklyn"" text,1066  ""queens"" text,1067  ""richmond_staten_is"" text,1068  ""total"" real,1069  ""pct"" text1070);","SELECT ""the_bronx"" FROM ""1953"" WHERE ""manhattan""='29.9%';",1-1108394-341071What number of voters did the Bronx have when the total number was 2054?,"CREATE TABLE ""1953"" (1072  ""1953"" text,1073  ""party"" text,1074  ""manhattan"" text,1075  ""the_bronx"" text,1076  ""brooklyn"" text,1077  ""queens"" text,1078  ""richmond_staten_is"" text,1079  ""total"" real,1080  ""pct"" text1081);","SELECT ""the_bronx"" FROM ""1953"" WHERE ""total""=2054;",1-1108394-341082What number of voters did Queens have when Staten Island had 295 voters?,"CREATE TABLE ""1953"" (1083  ""1953"" text,1084  ""party"" text,1085  ""manhattan"" text,1086  ""the_bronx"" text,1087  ""brooklyn"" text,1088  ""queens"" text,1089  ""richmond_staten_is"" text,1090  ""total"" real,1091  ""pct"" text1092);","SELECT ""queens"" FROM ""1953"" WHERE ""richmond_staten_is""='295';",1-1108394-341093What was Staten Island when Brooklyn was 940?,"CREATE TABLE ""2013"" (1094  ""2013_republican_primary"" text,1095  ""manhattan"" text,1096  ""the_bronx"" text,1097  ""brooklyn"" text,1098  ""queens"" text,1099  ""staten_island"" text,1100  ""total"" real,1101  ""pct"" text1102);","SELECT ""staten_island"" FROM ""2013"" WHERE ""brooklyn""='940';",1-1108394-61103"What was the total number in Manhattan when Staten Island was 12,658?","CREATE TABLE ""2013"" (1104  ""2013_republican_primary"" text,1105  ""manhattan"" text,1106  ""the_bronx"" text,1107  ""brooklyn"" text,1108  ""queens"" text,1109  ""staten_island"" text,1110  ""total"" real,1111  ""pct"" text1112);","SELECT COUNT(""manhattan"") FROM ""2013"" WHERE ""staten_island""='12,658';",1-1108394-61113"What was the total in Brooklyn when Manhattan was 3,139?","CREATE TABLE ""2013"" (1114  ""2013_republican_primary"" text,1115  ""manhattan"" text,1116  ""the_bronx"" text,1117  ""brooklyn"" text,1118  ""queens"" text,1119  ""staten_island"" text,1120  ""total"" real,1121  ""pct"" text1122);","SELECT ""brooklyn"" FROM ""2013"" WHERE ""manhattan""='3,139';",1-1108394-61123Who was the republican candidate in 2013 when Staten Island was 451?,"CREATE TABLE ""2013"" (1124  ""2013_republican_primary"" text,1125  ""manhattan"" text,1126  ""the_bronx"" text,1127  ""brooklyn"" text,1128  ""queens"" text,1129  ""staten_island"" text,1130  ""total"" real,1131  ""pct"" text1132);","SELECT ""2013_republican_primary"" FROM ""2013"" WHERE ""staten_island""='451';",1-1108394-61133"What was the amount in Staten Island when The Bronx was 1,281?","CREATE TABLE ""2013"" (1134  ""2013_republican_primary"" text,1135  ""manhattan"" text,1136  ""the_bronx"" text,1137  ""brooklyn"" text,1138  ""queens"" text,1139  ""staten_island"" text,1140  ""total"" real,1141  ""pct"" text1142);","SELECT ""staten_island"" FROM ""2013"" WHERE ""the_bronx""='1,281';",1-1108394-61143The candidate who received 133 votes in the Bronx won what percentage overall?,"CREATE TABLE ""table1_1108394_47"" (1144  ""1921"" text,1145  ""party"" text,1146  ""manhattan"" text,1147  ""the_bronx"" text,1148  ""brooklyn"" text,1149  ""queens"" text,1150  ""richmond_staten_is"" text,1151  ""total"" real,1152  ""pct"" text1153);","SELECT ""pct"" FROM ""table1_1108394_47"" WHERE ""the_bronx""='133';",1-1108394-471154Which candidate won 88 votes in Queens in 1921?,"CREATE TABLE ""table1_1108394_47"" (1155  ""1921"" text,1156  ""party"" text,1157  ""manhattan"" text,1158  ""the_bronx"" text,1159  ""brooklyn"" text,1160  ""queens"" text,1161  ""richmond_staten_is"" text,1162  ""total"" real,1163  ""pct"" text1164);","SELECT ""1921"" FROM ""table1_1108394_47"" WHERE ""queens""='88';",1-1108394-471165How many votes in Brooklyn were won by the candidate who won 321 votes in Manhattan?,"CREATE TABLE ""table1_1108394_47"" (1166  ""1921"" text,1167  ""party"" text,1168  ""manhattan"" text,1169  ""the_bronx"" text,1170  ""brooklyn"" text,1171  ""queens"" text,1172  ""richmond_staten_is"" text,1173  ""total"" real,1174  ""pct"" text1175);","SELECT ""brooklyn"" FROM ""table1_1108394_47"" WHERE ""manhattan""='321';",1-1108394-471176"The man who received 87,676 votes in Queens won what percentage of the total for the election?","CREATE TABLE ""table1_1108394_47"" (1177  ""1921"" text,1178  ""party"" text,1179  ""manhattan"" text,1180  ""the_bronx"" text,1181  ""brooklyn"" text,1182  ""queens"" text,1183  ""richmond_staten_is"" text,1184  ""total"" real,1185  ""pct"" text1186);","SELECT ""pct"" FROM ""table1_1108394_47"" WHERE ""queens""='87,676';",1-1108394-471187How many parties received 29.9% of the vote in Manhattan?,"CREATE TABLE ""table1_1108394_47"" (1188  ""1921"" text,1189  ""party"" text,1190  ""manhattan"" text,1191  ""the_bronx"" text,1192  ""brooklyn"" text,1193  ""queens"" text,1194  ""richmond_staten_is"" text,1195  ""total"" real,1196  ""pct"" text1197);","SELECT COUNT(""party"") FROM ""table1_1108394_47"" WHERE ""manhattan""='29.9%';",1-1108394-471198Name the most late 1943 with late 194 in slovenia,"CREATE TABLE ""composition"" (1199  ""late_1941"" text,1200  ""late_1942"" real,

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