tulika214/Quantized_4_bit_models
061
1[2 {3 "question": "When Essendon played away; where did they play?",4 "answer": "SELECT venue FROM table_name_50 WHERE away_team = \"essendon\"",5 "context": "CREATE TABLE table_name_50 (venue VARCHAR, away_team VARCHAR)"6 },7 {8 "question": "What is the lowest numbered game against Phoenix with a record of 29-17?",9 "answer": "SELECT MIN(game) FROM table_name_61 WHERE opponent = \"phoenix\" AND record = \"29-17\"",10 "context": "CREATE TABLE table_name_61 (game INTEGER, opponent VARCHAR, record VARCHAR)"11 },12 {13 "question": "Who did the Texan's play on Week 4?",14 "answer": "SELECT opponent FROM table_name_37 WHERE week = \"4\"",15 "context": "CREATE TABLE table_name_37 (opponent VARCHAR, week VARCHAR)"16 },17 {18 "question": "Which Points have Touchdowns larger than 0, and an Extra points smaller than 0?",19 "answer": "SELECT SUM(points) FROM table_name_70 WHERE touchdowns > 0 AND extra_points < 0",20 "context": "CREATE TABLE table_name_70 (points INTEGER, touchdowns VARCHAR, extra_points VARCHAR)"21 },22 {23 "question": "What is the name of the player who is Sco and moving to greenock morton in the summer?",24 "answer": "SELECT name FROM table_name_83 WHERE nat = \"sco\" AND transfer_window = \"summer\" AND moving_to = \"greenock morton\"",25 "context": "CREATE TABLE table_name_83 (name VARCHAR, moving_to VARCHAR, nat VARCHAR, transfer_window VARCHAR)"26 },27 {28 "question": "Of all the contestants who got voted, what is the contestant number and name of the contestant who got least votes?",29 "answer": "SELECT T1.contestant_number, T1.contestant_name FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number = T2.contestant_number GROUP BY T1.contestant_number ORDER BY COUNT(*) LIMIT 1",30 "context": "CREATE TABLE votes (contestant_number VARCHAR); CREATE TABLE contestants (contestant_number VARCHAR, contestant_name VARCHAR)"31 },32 {33 "question": "Which venue had the result 7-1?",34 "answer": "SELECT venue FROM table_name_50 WHERE result = \"7-1\"",35 "context": "CREATE TABLE table_name_50 (venue VARCHAR, result VARCHAR)"36 },37 {38 "question": "What did the tournament that got an A in 1945 get in 1949?",39 "answer": "SELECT 1949 FROM table_name_22 WHERE 1945 = \"a\"",40 "context": "CREATE TABLE table_name_22 (Id VARCHAR)"41 },42 {43 "question": "Find the states where have the colleges whose enrollments are less than the largest size.",44 "answer": "SELECT DISTINCT state FROM college WHERE enr < (SELECT MAX(enr) FROM college)",45 "context": "CREATE TABLE college (state VARCHAR, enr INTEGER)"46 },47 {48 "question": "What is the name of the episode that had 9.89 million U.S. viewers?",49 "answer": "SELECT title FROM table_24648983_1 WHERE us_viewers__million_ = \"9.89\"",50 "context": "CREATE TABLE table_24648983_1 (title VARCHAR, us_viewers__million_ VARCHAR)"51 },52 {53 "question": "What are the names of the workshop groups that have bookings with status code \"stop\"?",54 "answer": "SELECT T2.Store_Name FROM Bookings AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Workshop_Group_ID = T2.Workshop_Group_ID WHERE T1.Status_Code = \"stop\"",55 "context": "CREATE TABLE Bookings (Workshop_Group_ID VARCHAR, Status_Code VARCHAR); CREATE TABLE Drama_Workshop_Groups (Store_Name VARCHAR, Workshop_Group_ID VARCHAR)"56 },57 {58 "question": "Where was the opponent Germany?",59 "answer": "SELECT location FROM table_name_96 WHERE opponenent = \"germany\"",60 "context": "CREATE TABLE table_name_96 (location VARCHAR, opponenent VARCHAR)"61 },62 {63 "question": "Name the candidates for result of lost renomination democratic loss",64 "answer": "SELECT candidates FROM table_1342149_24 WHERE result = \"Lost renomination Democratic loss\"",65 "context": "CREATE TABLE table_1342149_24 (candidates VARCHAR, result VARCHAR)"66 },67 {68 "question": "What is the number of party in the arkansas 1 district",69 "answer": "SELECT COUNT(party) FROM table_1341930_5 WHERE district = \"Arkansas 1\"",70 "context": "CREATE TABLE table_1341930_5 (party VARCHAR, district VARCHAR)"71 },72 {73 "question": "How many alt names does 1964-011a have?",74 "answer": "SELECT COUNT(alt_name) FROM table_12141496_1 WHERE id = \"1964-011A\"",75 "context": "CREATE TABLE table_12141496_1 (alt_name VARCHAR, id VARCHAR)"76 },77 {78 "question": "Who is the opponent of the game played on November 20, 1995?",79 "answer": "SELECT opponent FROM table_name_66 WHERE date = \"november 20, 1995\"",80 "context": "CREATE TABLE table_name_66 (opponent VARCHAR, date VARCHAR)"81 },82 {83 "question": "What is the position of tickets sold/available when the sellout is 82%?",84 "answer": "SELECT COUNT(tickets_sold___available) FROM table_16331025_2 WHERE sellout___percentage_ = \"82%\"",85 "context": "CREATE TABLE table_16331025_2 (tickets_sold___available VARCHAR, sellout___percentage_ VARCHAR)"86 },87 {88 "question": "Which College/Junior/Club Team (League) did the player in round 6 play for?",89 "answer": "SELECT college_junior_club_team__league_ FROM table_name_98 WHERE round = \"6\"",90 "context": "CREATE TABLE table_name_98 (college_junior_club_team__league_ VARCHAR, round VARCHAR)"91 },92 {93 "question": "How many in the introduced section had Fokker as a manufacturer, a quantity of 5, and retired later than 1999?",94 "answer": "SELECT SUM(introduced) FROM table_name_94 WHERE manufacturer = \"fokker\" AND quantity = 5 AND retired > 1999",95 "context": "CREATE TABLE table_name_94 (introduced INTEGER, retired VARCHAR, manufacturer VARCHAR, quantity VARCHAR)"96 },97 {98 "question": "Where was the audition venue where Peninha was the guest fourth judge?",99 "answer": "SELECT audition_venue FROM table_27615445_1 WHERE guest_fourth_judge = \"Peninha\"",100 "context": "CREATE TABLE table_27615445_1 (audition_venue VARCHAR, guest_fourth_judge VARCHAR)"101 },102 {103 "question": "Who was the runner-up in the Memorial Tournament?",104 "answer": "SELECT runner_s__up FROM table_1602858_1 WHERE tournament = \"Memorial tournament\"",105 "context": "CREATE TABLE table_1602858_1 (runner_s__up VARCHAR, tournament VARCHAR)"106 },107 {108 "question": "What is the number of bonus points when there are 2 drawn and the points against is 599?",109 "answer": "SELECT bonus_points FROM table_name_83 WHERE drawn = \"2\" AND points_against = \"599\"",110 "context": "CREATE TABLE table_name_83 (bonus_points VARCHAR, drawn VARCHAR, points_against VARCHAR)"111 },112 {113 "question": "Which game was a Platformer?",114 "answer": "SELECT game FROM table_name_90 WHERE genre = \"platformer\"",115 "context": "CREATE TABLE table_name_90 (game VARCHAR, genre VARCHAR)"116 },117 {118 "question": "Who was the individual in the event of 1998 Pokljuka?",119 "answer": "SELECT individual FROM table_name_33 WHERE event = \"1998 pokljuka\"",120 "context": "CREATE TABLE table_name_33 (individual VARCHAR, event VARCHAR)"121 },122 {123 "question": "What's the average draft pick number from Carson-Newman College before Round 7?",124 "answer": "SELECT AVG(pick__number) FROM table_name_21 WHERE college = \"carson-newman\" AND round < 7",125 "context": "CREATE TABLE table_name_21 (pick__number INTEGER, college VARCHAR, round VARCHAR)"126 },127 {128 "question": "Who was the spouse of the consort who was born as rania al yassin?",129 "answer": "SELECT spouse_to FROM table_name_27 WHERE born_as = \"rania al yassin\"",130 "context": "CREATE TABLE table_name_27 (spouse_to VARCHAR, born_as VARCHAR)"131 },132 {133 "question": "How many figures for wickets when the strike rate is 54.0?",134 "answer": "SELECT COUNT(wickets) FROM table_19662262_6 WHERE strike_rate = \"54.0\"",135 "context": "CREATE TABLE table_19662262_6 (wickets VARCHAR, strike_rate VARCHAR)"136 },137 {138 "question": "Who's the Communist ticket with an American Labor ticket of joseph v. o'leary?",139 "answer": "SELECT communist_ticket FROM table_name_49 WHERE american_labor_ticket = \"joseph v. o'leary\"",140 "context": "CREATE TABLE table_name_49 (communist_ticket VARCHAR, american_labor_ticket VARCHAR)"141 },142 {143 "question": "What is the HDI 2011 of the country with a DI 2011 of 7.63?",144 "answer": "SELECT hdi_2011 FROM table_name_54 WHERE di_2011 = \"7.63\"",145 "context": "CREATE TABLE table_name_54 (hdi_2011 VARCHAR, di_2011 VARCHAR)"146 },147 {148 "question": "How much Against has Draws of 2, and Losses smaller than 4?",149 "answer": "SELECT SUM(against) FROM table_name_17 WHERE draws = 2 AND losses < 4",150 "context": "CREATE TABLE table_name_17 (against INTEGER, draws VARCHAR, losses VARCHAR)"151 },152 {153 "question": "What was Galatasaray score when when he won in 1990 and Trabzonspor was the runner-up?",154 "answer": "SELECT score FROM table_name_24 WHERE winners = \"galatasaray\" AND runners_up = \"trabzonspor\" AND year = 1990",155 "context": "CREATE TABLE table_name_24 (score VARCHAR, year VARCHAR, winners VARCHAR, runners_up VARCHAR)"156 },157 {158 "question": "Who was the runner-up of the competition played at Minikahda Club?",159 "answer": "SELECT runner_up FROM table_name_55 WHERE venue = \"minikahda club\"",160 "context": "CREATE TABLE table_name_55 (runner_up VARCHAR, venue VARCHAR)"161 },162 {163 "question": "What is the catalog number for the Grilled Cheese label?",164 "answer": "SELECT catalog FROM table_name_33 WHERE label = \"grilled cheese\"",165 "context": "CREATE TABLE table_name_33 (catalog VARCHAR, label VARCHAR)"166 },167 {168 "question": "Which opponent had the result of W 24-14?",169 "answer": "SELECT opponent FROM table_name_64 WHERE result = \"w 24-14\"",170 "context": "CREATE TABLE table_name_64 (opponent VARCHAR, result VARCHAR)"171 },172 {173 "question": "What is the newest season?",174 "answer": "SELECT MAX(season) FROM table_2140071_7",175 "context": "CREATE TABLE table_2140071_7 (season INTEGER)"176 },177 {178 "question": "Which Surface has an Opponent(s) of anna-lena gr\u00f6nefeld tatjana malek?",179 "answer": "SELECT surface FROM table_name_8 WHERE opponent_s_ = \"anna-lena gr\u00f6nefeld tatjana malek\"",180 "context": "CREATE TABLE table_name_8 (surface VARCHAR, opponent_s_ VARCHAR)"181 },182 {183 "question": "In what TV season did the 3rd season air?",184 "answer": "SELECT TV AS season FROM table_1348989_2 WHERE season = \"3rd\"",185 "context": "CREATE TABLE table_1348989_2 (TV VARCHAR, season VARCHAR)"186 },187 {188 "question": "Who ran the fastest lap in the team that competed in Zolder, in which Ferrari was the Constructor?",189 "answer": "SELECT fastest_lap FROM table_name_39 WHERE constructor = \"ferrari\" AND location = \"zolder\"",190 "context": "CREATE TABLE table_name_39 (fastest_lap VARCHAR, constructor VARCHAR, location VARCHAR)"191 },192 {193 "question": "What was the NBA draft status for Northeast High School?",194 "answer": "SELECT nba_draft FROM table_name_7 WHERE school = \"northeast high school\"",195 "context": "CREATE TABLE table_name_7 (nba_draft VARCHAR, school VARCHAR)"196 },197 {198 "question": "What is the high Population (total) from 1976 with a (Barcaldine) smaller than 1,780?",199 "answer": "SELECT MAX(population__total_) FROM table_name_96 WHERE year = 1976 AND _barcaldine_ < 1 OFFSET 780",200 "context": "CREATE TABLE table_name_96 (population__total_ INTEGER, year VARCHAR, _barcaldine_ VARCHAR)"201 },202 {203 "question": "What 1953 has 2 as a 1949, and 3 as 1952?",204 "answer": "SELECT 1953 FROM table_name_48 WHERE 1949 = \"2\" AND 1952 = \"3\"",205 "context": "CREATE TABLE table_name_48 (Id VARCHAR)"206 },207 {208 "question": "What is the total number of losses for the over 30 games played?",209 "answer": "SELECT COUNT(losses) FROM table_name_50 WHERE played > 30",210 "context": "CREATE TABLE table_name_50 (losses VARCHAR, played INTEGER)"211 },212 {213 "question": "Show names for artists without any exhibition.",214 "answer": "SELECT name FROM artist WHERE NOT artist_id IN (SELECT artist_id FROM exhibition)",215 "context": "CREATE TABLE artist (name VARCHAR, artist_id VARCHAR); CREATE TABLE exhibition (name VARCHAR, artist_id VARCHAR)"216 },217 {218 "question": "What are the countries of mountains with height bigger than 5000?",219 "answer": "SELECT Country FROM mountain WHERE Height > 5000",220 "context": "CREATE TABLE mountain (Country VARCHAR, Height INTEGER)"221 },222 {223 "question": "What is the highest Money ( \u00a3 ), when Player is \"Peter Hedblom\"?",224 "answer": "SELECT MAX(money___) AS \u00a3__ FROM table_name_95 WHERE player = \"peter hedblom\"",225 "context": "CREATE TABLE table_name_95 (money___ INTEGER, player VARCHAR)"226 },227 {228 "question": "When was the appointment date for VFL Wolfsburg?",229 "answer": "SELECT date_of_appointment FROM table_name_72 WHERE team = \"vfl wolfsburg\"",230 "context": "CREATE TABLE table_name_72 (date_of_appointment VARCHAR, team VARCHAR)"231 },232 {233 "question": "What language is the moviein that is on UMP movies network through Sky service?",234 "answer": "SELECT language FROM table_name_87 WHERE genre = \"movies\" AND service = \"sky\" AND network = \"ump movies\"",235 "context": "CREATE TABLE table_name_87 (language VARCHAR, network VARCHAR, genre VARCHAR, service VARCHAR)"236 },237 {238 "question": "What Location has a Design flow (LPM) smaller than 1900, and a Construction Start of 2006 june?",239 "answer": "SELECT location FROM table_name_40 WHERE design_flow__lpm_ < 1900 AND construction_start = \"2006 june\"",240 "context": "CREATE TABLE table_name_40 (location VARCHAR, design_flow__lpm_ VARCHAR, construction_start VARCHAR)"241 },242 {243 "question": "What high definition television options are available for Italia 1?",244 "answer": "SELECT hdtv FROM table_15887683_1 WHERE television_service = \"Italia 1\"",245 "context": "CREATE TABLE table_15887683_1 (hdtv VARCHAR, television_service VARCHAR)"246 },247 {248 "question": "Which suffix has the prefix of isothiocyanato- (-ncs)?",249 "answer": "SELECT suffix FROM table_name_17 WHERE prefix = \"isothiocyanato- (-ncs)\"",250 "context": "CREATE TABLE table_name_17 (suffix VARCHAR, prefix VARCHAR)"251 },252 {253 "question": "What is the enrollment at the school of Hamilton community?",254 "answer": "SELECT AVG(enrollment) FROM table_name_3 WHERE school = \"hamilton community\"",255 "context": "CREATE TABLE table_name_3 (enrollment INTEGER, school VARCHAR)"256 },257 {258 "question": "What is the date of return for the program for the program \"Big Brother\"?",259 "answer": "SELECT date_of_return FROM table_29566606_11 WHERE programme = \"Big Brother\"",260 "context": "CREATE TABLE table_29566606_11 (date_of_return VARCHAR, programme VARCHAR)"261 },262 {263 "question": "On what date was Patty Fendick an opponent?",264 "answer": "SELECT date FROM table_name_95 WHERE opponent = \"patty fendick\"",265 "context": "CREATE TABLE table_name_95 (date VARCHAR, opponent VARCHAR)"266 },267 {268 "question": "What position did the player who was with the grizzlies from 2007-2009 play?",269 "answer": "SELECT position FROM table_name_89 WHERE years_for_grizzlies = \"2007-2009\"",270 "context": "CREATE TABLE table_name_89 (position VARCHAR, years_for_grizzlies VARCHAR)"271 },272 {273 "question": "When do all the researcher role staff start to work, and when do they stop working?",274 "answer": "SELECT date_from, date_to FROM Project_Staff WHERE role_code = 'researcher'",275 "context": "CREATE TABLE Project_Staff (date_from VARCHAR, date_to VARCHAR, role_code VARCHAR)"276 },277 {278 "question": "what is the analog type for wxmi?",279 "answer": "SELECT analog FROM table_name_9 WHERE callsign = \"wxmi\"",280 "context": "CREATE TABLE table_name_9 (analog VARCHAR, callsign VARCHAR)"281 },282 {283 "question": "what's the\u00a0record\u00a0with\u00a0result\u00a0being w 21\u20137",284 "answer": "SELECT record FROM table_14951643_1 WHERE result = \"W 21\u20137\"",285 "context": "CREATE TABLE table_14951643_1 (record VARCHAR, result VARCHAR)"286 },287 {288 "question": "What is the market income per capita in a county where the status is distressed and the unemployment rate is at 10.5%? ",289 "answer": "SELECT market_income_per_capita FROM table_22815568_3 WHERE status = \"Distressed\" AND unemployment_rate = \"10.5%\"",290 "context": "CREATE TABLE table_22815568_3 (market_income_per_capita VARCHAR, status VARCHAR, unemployment_rate VARCHAR)"291 },292 {293 "question": "What is Date, when Opponent in Final is \"Guy Forget\"?",294 "answer": "SELECT date FROM table_name_64 WHERE opponent_in_final = \"guy forget\"",295 "context": "CREATE TABLE table_name_64 (date VARCHAR, opponent_in_final VARCHAR)"296 },297 {298 "question": "Name the time for saturday 4 march 1995",299 "answer": "SELECT time FROM table_16388047_1 WHERE date = \"Saturday 4 March 1995\"",300 "context": "CREATE TABLE table_16388047_1 (time VARCHAR, date VARCHAR)"301 },302 {303 "question": "What was the lowest win% with an away score of 3-2 in 2011 season?",304 "answer": "SELECT MIN(win__percentage) FROM table_name_53 WHERE away = \"3-2\" AND season = \"2011\"",305 "context": "CREATE TABLE table_name_53 (win__percentage INTEGER, away VARCHAR, season VARCHAR)"306 },307 {308 "question": "how many division did not qualify for u.s. open cup in 2003",309 "answer": "SELECT division FROM table_1046170_5 WHERE us_open_cup = \"Did Not Qualify\" AND year = 2003",310 "context": "CREATE TABLE table_1046170_5 (division VARCHAR, us_open_cup VARCHAR, year VARCHAR)"311 },312 {313 "question": "What album is 4:53 long?",314 "answer": "SELECT album FROM table_name_74 WHERE length = \"4:53\"",315 "context": "CREATE TABLE table_name_74 (album VARCHAR, length VARCHAR)"316 },317 {318 "question": "What are the formats associated with the Atlantic Records label, catalog number 512336?",319 "answer": "SELECT format_s_ FROM table_name_15 WHERE label = \"atlantic records\" AND catalog = \"512336\"",320 "context": "CREATE TABLE table_name_15 (format_s_ VARCHAR, label VARCHAR, catalog VARCHAR)"321 },322 {323 "question": "Name the number of naming for anomic aphasia",324 "answer": "SELECT COUNT(naming) FROM table_2088_1 WHERE type_of_aphasia = \"Anomic aphasia\"",325 "context": "CREATE TABLE table_2088_1 (naming VARCHAR, type_of_aphasia VARCHAR)"326 },327 {328 "question": "What was the Result F\u2013A on 21 February 2009, when the league position was 1st?",329 "answer": "SELECT result_f_a FROM table_name_55 WHERE league_position = \"1st\" AND date = \"21 february 2009\"",330 "context": "CREATE TABLE table_name_55 (result_f_a VARCHAR, league_position VARCHAR, date VARCHAR)"331 },332 {333 "question": "What is position does Dan O'Sullivan play?",334 "answer": "SELECT position FROM table_name_58 WHERE player = \"dan o'sullivan\"",335 "context": "CREATE TABLE table_name_58 (position VARCHAR, player VARCHAR)"336 },337 {338 "question": "Name the traditional for \u5c4f\u5357\u53bf",339 "answer": "SELECT traditional FROM table_2013618_1 WHERE simplified = \"\u5c4f\u5357\u53bf\"",340 "context": "CREATE TABLE table_2013618_1 (traditional VARCHAR, simplified VARCHAR)"341 },342 {343 "question": "Name the district for hugh glasgow",344 "answer": "SELECT district FROM table_2668352_14 WHERE incumbent = \"Hugh Glasgow\"",345 "context": "CREATE TABLE table_2668352_14 (district VARCHAR, incumbent VARCHAR)"346 },347 {348 "question": "Name the being qualities for having things of friendships, family, relationships with nature",349 "answer": "SELECT being__qualities_ FROM table_name_20 WHERE having__things_ = \"friendships, family, relationships with nature\"",350 "context": "CREATE TABLE table_name_20 (being__qualities_ VARCHAR, having__things_ VARCHAR)"351 },352 {353 "question": "which number lists the production code as 2j5809",354 "answer": "SELECT no FROM table_27403436_1 WHERE production_code = \"2J5809\"",355 "context": "CREATE TABLE table_27403436_1 (no VARCHAR, production_code VARCHAR)"356 },357 {358 "question": "What is listed under try bonus when listed under Tries for is tries for?",359 "answer": "SELECT try_bonus FROM table_13399573_3 WHERE \"tries_for\" = \"tries_for\"",360 "context": "CREATE TABLE table_13399573_3 (try_bonus VARCHAR)"361 },362 {363 "question": "which championship had arantxa s\u00e1nchez vicario todd woodbridge as opponents in the final ",364 "answer": "SELECT championship FROM table_1918850_2 WHERE opponents_in_the_final = \"Arantxa S\u00e1nchez Vicario Todd Woodbridge\"",365 "context": "CREATE TABLE table_1918850_2 (championship VARCHAR, opponents_in_the_final VARCHAR)"366 },367 {368 "question": "What is the highest tonnage of the ship from norway?",369 "answer": "SELECT MAX(tonnage) FROM table_name_71 WHERE nationality = \"norway\"",370 "context": "CREATE TABLE table_name_71 (tonnage INTEGER, nationality VARCHAR)"371 },372 {373 "question": "What was the date of the game where Esteban Paredes scored 2 goals?",374 "answer": "SELECT date FROM table_name_62 WHERE goal = 2",375 "context": "CREATE TABLE table_name_62 (date VARCHAR, goal VARCHAR)"376 },377 {378 "question": "What is the Away team with Newcastle United as the Home team?",379 "answer": "SELECT away_team FROM table_name_42 WHERE home_team = \"newcastle united\"",380 "context": "CREATE TABLE table_name_42 (away_team VARCHAR, home_team VARCHAR)"381 },382 {383 "question": "what was the competitoin where the opponent is sheffield scimitars?",384 "answer": "SELECT competition FROM table_17120964_9 WHERE opponent = \"Sheffield Scimitars\"",385 "context": "CREATE TABLE table_17120964_9 (competition VARCHAR, opponent VARCHAR)"386 },387 {388 "question": "Which Circuit has a Winning Driver of hans-joachim stuck, and a Round of 3?",389 "answer": "SELECT circuit FROM table_name_74 WHERE winning_driver = \"hans-joachim stuck\" AND round = 3",390 "context": "CREATE TABLE table_name_74 (circuit VARCHAR, winning_driver VARCHAR, round VARCHAR)"391 },392 {393 "question": "What is the capacity of the mine that is operated by Cyprus Amax minerals?",394 "answer": "SELECT capacity__thousands_of_metric_tons_ FROM table_name_83 WHERE operator = \"cyprus amax minerals\"",395 "context": "CREATE TABLE table_name_83 (capacity__thousands_of_metric_tons_ VARCHAR, operator VARCHAR)"396 },397 {398 "question": "Who was the Partner in the Algiers 2, Algeria Tournament?",399 "answer": "SELECT partner FROM table_name_2 WHERE tournament = \"algiers 2, algeria\"",400 "context": "CREATE TABLE table_name_2 (partner VARCHAR, tournament VARCHAR)"401 },402 {403 "question": "WHAT kind of No Result has Wins smaller than 2, and Losses larger than 1?",404 "answer": "SELECT no_result FROM table_name_2 WHERE wins < 2 AND losses > 1",405 "context": "CREATE TABLE table_name_2 (no_result VARCHAR, wins VARCHAR, losses VARCHAR)"406 },407 {408 "question": "Who did the Rangers play in a game that was later than 72 when the team record was 39-27-9?",409 "answer": "SELECT opponent FROM table_name_93 WHERE game > 72 AND record = \"39-27-9\"",410 "context": "CREATE TABLE table_name_93 (opponent VARCHAR, game VARCHAR, record VARCHAR)"411 },412 {413 "question": "In game 73, what were the total number of high assists?",414 "answer": "SELECT COUNT(high_assists) FROM table_28768469_10 WHERE game = 73",415 "context": "CREATE TABLE table_28768469_10 (high_assists VARCHAR, game VARCHAR)"416 },417 {418 "question": "when deland is the fcsl team and 2008 is the year played who is the mlb team?",419 "answer": "SELECT mlb_team FROM table_18373863_2 WHERE years_played = \"2008\" AND fcsl_team = \"DeLand\"",420 "context": "CREATE TABLE table_18373863_2 (mlb_team VARCHAR, years_played VARCHAR, fcsl_team VARCHAR)"421 },422 {423 "question": "what is the total number of\u00a0kickoff [a ]\u00a0where\u00a0week\u00a0is week",424 "answer": "SELECT COUNT(kickoff_)[a_] FROM table_11406866_2 WHERE \"week\" = \"week\"",425 "context": "CREATE TABLE table_11406866_2 (a_ VARCHAR, kickoff_ VARCHAR)"426 },427 {428 "question": "What position did he finish in 1987?",429 "answer": "SELECT position FROM table_2387790_2 WHERE year = 1987",430 "context": "CREATE TABLE table_2387790_2 (position VARCHAR, year VARCHAR)"431 },432 {433 "question": "What was Gary Player's highest total when his To par was over 15?",434 "answer": "SELECT MAX(total) FROM table_name_41 WHERE player = \"gary player\" AND to_par > 15",435 "context": "CREATE TABLE table_name_41 (total INTEGER, player VARCHAR, to_par VARCHAR)"436 },437 {438 "question": "What is the total sum of 50m splits for josefin lillhage in lanes above 8?",439 "answer": "SELECT SUM(split__50m_) FROM table_name_24 WHERE name = \"josefin lillhage\" AND lane > 8",440 "context": "CREATE TABLE table_name_24 (split__50m_ INTEGER, name VARCHAR, lane VARCHAR)"441 },442 {443 "question": "Where has Jimmy Demaret as a player?",444 "answer": "SELECT place FROM table_name_94 WHERE player = \"jimmy demaret\"",445 "context": "CREATE TABLE table_name_94 (place VARCHAR, player VARCHAR)"446 },447 {448 "question": "What is the total number of Goals scored that has more than 45 Points?",449 "answer": "SELECT COUNT(goals_scored) FROM table_name_74 WHERE points > 45",450 "context": "CREATE TABLE table_name_74 (goals_scored VARCHAR, points INTEGER)"451 },452 {453 "question": "How did the game number 50 end?",454 "answer": "SELECT score FROM table_23248940_9 WHERE game = 50",455 "context": "CREATE TABLE table_23248940_9 (score VARCHAR, game VARCHAR)"456 },457 {458 "question": "What player has a round larger than 2, and position of (d)?",459 "answer": "SELECT player FROM table_name_20 WHERE round > 2 AND position = \"(d)\"",460 "context": "CREATE TABLE table_name_20 (player VARCHAR, round VARCHAR, position VARCHAR)"461 },462 {463 "question": "What was sweden's score in T9 place?",464 "answer": "SELECT score FROM table_name_27 WHERE place = \"t9\" AND country = \"sweden\"",465 "context": "CREATE TABLE table_name_27 (score VARCHAR, place VARCHAR, country VARCHAR)"466 },467 {468 "question": "What was the Attendance on November 26?",469 "answer": "SELECT attendance FROM table_name_98 WHERE date = \"november 26\"",470 "context": "CREATE TABLE table_name_98 (attendance VARCHAR, date VARCHAR)"471 },472 {473 "question": "Who finished in third place when the winner was Karina Bacchi? ",474 "answer": "SELECT third_place FROM table_25214321_1 WHERE winner = \"Karina Bacchi\"",475 "context": "CREATE TABLE table_25214321_1 (third_place VARCHAR, winner VARCHAR)"476 },477 {478 "question": "When is the date of appointment when the position in table is 16?",479 "answer": "SELECT date_of_appointment FROM table_27383390_4 WHERE position_in_table = 16",480 "context": "CREATE TABLE table_27383390_4 (date_of_appointment VARCHAR, position_in_table VARCHAR)"481 },482 {483 "question": "What is Date, when Outcome is \"Winner\", and when Opponents is \"Paul Haarhuis Sandon Stolle\"?",484 "answer": "SELECT date FROM table_name_48 WHERE outcome = \"winner\" AND opponents = \"paul haarhuis sandon stolle\"",485 "context": "CREATE TABLE table_name_48 (date VARCHAR, outcome VARCHAR, opponents VARCHAR)"486 },487 {488 "question": "What is the location of the Saints having 1979- as Years in GFL?",489 "answer": "SELECT location FROM table_name_37 WHERE years_in_gfl = \"1979-\" AND nickname = \"saints\"",490 "context": "CREATE TABLE table_name_37 (location VARCHAR, years_in_gfl VARCHAR, nickname VARCHAR)"491 },492 {493 "question": "Who was the Team that was played against on February 24 and a game after game 55?",494 "answer": "SELECT team FROM table_name_61 WHERE game > 55 AND date = \"february 24\"",495 "context": "CREATE TABLE table_name_61 (team VARCHAR, game VARCHAR, date VARCHAR)"496 },497 {498 "question": "Who is the monarch with the heir thado minsaw?",499 "answer": "SELECT monarch FROM table_26460435_8 WHERE heir = \"Thado Minsaw\"",500 "context": "CREATE TABLE table_26460435_8 (monarch VARCHAR, heir VARCHAR)"501 }502]503