MertML/refined-sql-create-context
Overview refined-sql-create-context is a high-quality dataset for training and evaluating Text-to-SQL models. It builds upon the sql-create-context dataset by ensuring that all SQL queries are executable in a MySQL database, resolving schema inconsistencies, and refining query validity. The dataset consists of natural language questions, their corresponding table schemas, and SQL queries that generate results from the given schema context with 11,632 examples.… See the full description on the dataset page: https://huggingface.co/datasets/MertML/refined-sql-create-context.
014
1[
2 {
3 "question": "What are the id and name of the museum visited most times?",
4 "context": "create table museum (name varchar, museum_id varchar, PRIMARY KEY (name)); create table visit (museum_id varchar, PRIMARY KEY (museum_id))",
5 "answer": "select t2.museum_id, t1.name from museum as t1 join visit as t2 on t1.museum_id = t2.museum_id group by t2.museum_id order by count(*) desc limit 1"
6 },
7 {
8 "question": "Find the first name and gender of student who have more than one pet.",
9 "context": "create table student (fname varchar, sex varchar, stuid varchar, PRIMARY KEY (fname)); create table has_pet (stuid varchar, PRIMARY KEY (stuid))",
10 "answer": "select t1.fname, t1.sex from student as t1 join has_pet as t2 on t1.stuid = t2.stuid group by t1.stuid having count(*) > 1"
11 },
12 {
13 "question": "Find the id of users who are followed by Mary and Susan.",
14 "context": "create table follows (f1 varchar, f2 varchar, PRIMARY KEY (f1)); create table user_profiles (uid varchar, name varchar, PRIMARY KEY (uid))",
15 "answer": "select t2.f1 from user_profiles as t1 join follows as t2 on t1.uid = t2.f2 where t1.name = \"mary\" intersect select t2.f1 from user_profiles as t1 join follows as t2 on t1.uid = t2.f2 where t1.name = \"susan\""
16 },
17
18 {
19 "question": "Which document type is described with the prefix 'Initial'?",
20 "context": "create table document_types (document_type_code varchar, document_description varchar, PRIMARY KEY (document_type_code))",
21 "answer": "select document_type_code from document_types where document_description like 'initial%'"
22 },
23 {
24 "question": "Find the names of stadiums which have never had any event.",
25 "context": "create table stadium (name_ varchar, id varchar, stadium_id varchar, PRIMARY KEY (name_)); create table events_ (name_ varchar, id varchar, stadium_id varchar, PRIMARY KEY (name_))",
26 "answer": "select name_ from stadium where not id in (select stadium_id from events_)"
27 },
28 {
29 "question": "Name the explanation for alben w. barkley",
30 "context": "create table table_2026548_1 (explanation varchar, vice_president varchar, PRIMARY KEY (explanation))",
31 "answer": "select explanation from table_2026548_1 where vice_president = \"alben w. barkley\""
32 },
33 {
34 "question": "If the parallel bars is 16.150, who is the gymnast?",
35 "context": "create table table_18662026_10 (gymnast varchar, parallel_bars varchar, PRIMARY KEY (gymnast))",
36 "answer": "select gymnast from table_18662026_10 where parallel_bars = \"16.150\""
37 },
38 {
39 "question": "how many times is the cyrillic name \u0441\u0438\u0431\u0430\u0447?",
40 "context": "create table table_2562572_52 (dominant_religion__2002_ varchar, cyrillic_name varchar, PRIMARY KEY (dominant_religion__2002_))",
41 "answer": "select count(dominant_religion__2002_) from table_2562572_52 where cyrillic_name = \"\u0441\u0438\u0431\u0430\u0447\""
42 },
43 {
44 "question": "What was the local investment (in $) in the projects of the department with $912,185 BID/PRONAR investment?",
45 "context": "create table table_17118006_2 (local_investment__us$_ varchar, bid_pronar_investment__us$_ varchar, PRIMARY KEY (local_investment__us$_))",
46 "answer": "select local_investment__us$_ from table_17118006_2 where bid_pronar_investment__us$_ = \"912,185\""
47 },
48 {
49 "question": "What was the elapsed time for the championship that had $9,377.42 in prize money?",
50 "context": "create table table_22050544_4 (elapsed_time varchar, prize varchar, PRIMARY KEY (elapsed_time))",
51 "answer": "select elapsed_time from table_22050544_4 where prize = \"$9,377.42\""
52 },
53 {
54 "question": "What is the incident type description for the incident type with code \"VIOLENCE\"?",
55 "context": "create table ref_incident_type (incident_type_description varchar, incident_type_code varchar, PRIMARY KEY (incident_type_description))",
56 "answer": "select incident_type_description from ref_incident_type where incident_type_code = \"violence\""
57 },
58 {
59 "question": "How many inches is the barrel length when the rear sight is weaver and the barrel profile is A2?",
60 "context": "create table table_12834315_8 (barrel_length varchar, rear_sight varchar, barrel_profile varchar, PRIMARY KEY (barrel_length))",
61 "answer": "select barrel_length from table_12834315_8 where rear_sight = \"weaver\" and barrel_profile = \"a2\""
62 },
63 {
64 "question": "How many towns exist on the government area with a surface of 110 square kilometers?",
65 "context": "create table table_23685890_2 (towns integer, land_area__km\u00b2_ varchar, PRIMARY KEY (towns))",
66 "answer": "select min(towns) from table_23685890_2 where land_area__km\u00b2_ = \"110\""
67 },
68 {
69 "question": "When Ryan Anderson won the mountains classification, and Michael Rogers won the general classification, who won the sprint classification?",
70 "context": "create table table_25055040_22 (sprint_classification varchar, mountains_classification varchar, general_classification varchar, PRIMARY KEY (sprint_classification))",
71 "answer": "select sprint_classification from table_25055040_22 where mountains_classification = \"ryan anderson\" and general_classification = \"michael rogers\""
72 },
73 {
74 "question": "Name the total number of qualifiying for race 3 being 3",
75 "context": "create table table_15530244_5 (qualifying varchar, race_3 varchar, PRIMARY KEY (qualifying))",
76 "answer": "select count(qualifying) from table_15530244_5 where race_3 = \"3\""
77 },
78 {
79 "question": "Name the b winning car for #88 team mitsubishi 88 mitsubishi starion",
80 "context": "create table table_27965906_2 (b_winning_car varchar, a_winning_car varchar, PRIMARY KEY (b_winning_car))",
81 "answer": "select b_winning_car from table_27965906_2 where a_winning_car = \"#88 team mitsubishi 88 mitsubishi starion\""
82 },
83 {
84 "question": "How many births per year are there for the period with 998 000 deaths per year?",
85 "context": "create table table_18950570_2 (live_births_per_year varchar, deaths_per_year varchar, PRIMARY KEY (live_births_per_year))",
86 "answer": "select live_births_per_year from table_18950570_2 where deaths_per_year = \"998 000\""
87 },
88 {
89 "question": "What are the dates of the assessment notes?",
90 "context": "create table assessment_notes (date_of_notes varchar, PRIMARY KEY (date_of_notes))",
91 "answer": "select date_of_notes from assessment_notes"
92 },
93 {
94 "question": "Find the ids of orders whose status is 'Success'.",
95 "context": "create table actual_orders (actual_order_id varchar, order_status_code varchar, PRIMARY KEY (actual_order_id))",
96 "answer": "select actual_order_id from actual_orders where order_status_code = 'success'"
97 },
98 {
99 "question": "When 2 is the ka-band how many properties are there?",
100 "context": "create table table_186468_1 (property varchar, ka_band varchar, PRIMARY KEY (property))",
101 "answer": "select count(property) from table_186468_1 where ka_band = \"2\""
102 },
103 {
104 "question": "Name the name of the state",
105 "context": "create table table_15463188_7 (name varchar, school_club_team varchar, PRIMARY KEY (name))",
106 "answer": "select name from table_15463188_7 where school_club_team = \"state\""
107 },
108 {
109 "question": "How many different kinds of lens brands are there?",
110 "context": "create table camera_lens (brand varchar, PRIMARY KEY (brand))",
111 "answer": "select count(distinct brand) from camera_lens"
112 },
113 {
114 "question": "What is the flange width (mm) for cross section area (cm 2) 16.4?",
115 "context": "create table table_2071644_1 (flange_width__mm_ varchar, cross_section_area__cm_2__ varchar, PRIMARY KEY (flange_width__mm_))",
116 "answer": "select count(flange_width__mm_) from table_2071644_1 where cross_section_area__cm_2__ = \"16.4\""
117 },
118 {
119 "question": "What party did the incumbent Joseph Pearson belong to?",
120 "context": "create table table_2668367_14 (party varchar, incumbent varchar, PRIMARY KEY (party))",
121 "answer": "select party from table_2668367_14 where incumbent = \"joseph pearson\""
122 },
123 {
124 "question": "If the team is Rubio \u00f1\u00fa, what is the 08 points?",
125 "context": "create table table_22011138_7 (team varchar, PRIMARY KEY (team))",
126 "answer": "select 08 as _pts from table_22011138_7 where team = \"rubio \u00f1\u00fa\""
127 },
128 {
129 "question": "What is the name of the road race held in Omsk, Russia?",
130 "context": "create table table_26166836_3 (road_race varchar, location varchar, PRIMARY KEY (road_race))",
131 "answer": "select road_race from table_26166836_3 where location = \"omsk\""
132 },
133 {
134 "question": "What is the brand name for the antibody Brentuximab Vedotin?",
135 "context": "create table table_1661124_1 (brand_name varchar, antibody varchar, PRIMARY KEY (brand_name))",
136 "answer": "select brand_name from table_1661124_1 where antibody = \"brentuximab vedotin\""
137 },
138 {
139 "question": "How many digital terrestrial channels are there for channel 4?",
140 "context": "create table table_182410_10 (digital_terrestrial_channel varchar, channel varchar, PRIMARY KEY (digital_terrestrial_channel))",
141 "answer": "select count(digital_terrestrial_channel) from table_182410_10 where channel = \"channel 4\""
142 },
143 {
144 "question": "How many written by have wendey stanzler as the director?",
145 "context": "create table table_22570439_1 (written_by varchar, directed_by varchar, PRIMARY KEY (written_by))",
146 "answer": "select count(written_by) from table_22570439_1 where directed_by = \"wendey stanzler\""
147 },
148 {
149 "question": "What was the percentage of others when the number for Bush was 3196?",
150 "context": "create table table_1733513_1 (others_percentage varchar, bush_number varchar, PRIMARY KEY (others_percentage))",
151 "answer": "select others_percentage from table_1733513_1 where bush_number = 3196"
152 },
153 {
154 "question": "Name the number of naming for anomic aphasia",
155 "context": "create table table_2088_1 (naming varchar, type_of_aphasia varchar, PRIMARY KEY (naming))",
156 "answer": "select count(naming) from table_2088_1 where type_of_aphasia = \"anomic aphasia\""
157 },
158 {
159 "question": "How many values of free float for the BSE code of 4EH?",
160 "context": "create table table_20667854_1 (free_float varchar, bse_code varchar, PRIMARY KEY (free_float))",
161 "answer": "select count(free_float) from table_20667854_1 where bse_code = \"4eh\""
162 },
163 {
164 "question": "What is the date of the tournament at Hokkaid\u014d with prize of \uffe5150000000?",
165 "context": "create table table_26144632_1 (dates varchar, location varchar, prize_fund___\uffe5__ varchar, PRIMARY KEY (dates))",
166 "answer": "select dates from table_26144632_1 where location = \"hokkaid\u014d\" and prize_fund___\uffe5__ = 150000000"
167 },
168 {
169 "question": "Find the names of swimmers who has a result of \"win\".",
170 "context": "create table record (swimmer_id varchar, PRIMARY KEY (swimmer_id)); create table swimmer (name varchar, id varchar, PRIMARY KEY (name))",
171 "answer": "select t1.name from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'win'"
172 },
173 {
174 "question": "How many people had the high points when a. webb (7) had the high assists?",
175 "context": "create table table_27882867_9 (high_points varchar, high_assists varchar, PRIMARY KEY (high_points))",
176 "answer": "select count(high_points) from table_27882867_9 where high_assists = \"a. webb (7)\""
177 },
178 {
179 "question": "What is the economy when the strike rate is 54.0?",
180 "context": "create table table_19662262_6 (economy_rate varchar, strike_rate varchar, PRIMARY KEY (economy_rate))",
181 "answer": "select economy_rate from table_19662262_6 where strike_rate = \"54.0\""
182 },
183 {
184 "question": "Which conference has the nickname Lions?",
185 "context": "create table table_1973729_2 (current_conference varchar, nickname varchar, PRIMARY KEY (current_conference))",
186 "answer": "select current_conference from table_1973729_2 where nickname = \"lions\""
187 },
188 {
189 "question": "Who wrote the episode that was directed by Dennie Gordon",
190 "context": "create table table_15938543_1 (written_by varchar, directed_by varchar, PRIMARY KEY (written_by))",
191 "answer": "select written_by from table_15938543_1 where directed_by = \"dennie gordon\""
192 },
193 {
194 "question": "When 169.182 is the average speed miles per hour what is the chassis?",
195 "context": "create table table_1771753_3 (chassis varchar, average_speed__mph_ varchar, PRIMARY KEY (chassis))",
196 "answer": "select chassis from table_1771753_3 where average_speed__mph_ = \"169.182\""
197 },
198 {
199 "question": "Who was the winner of the race at Belmont?",
200 "context": "create table table_1358608_4 (winner_2nd varchar, venue varchar, PRIMARY KEY (winner_2nd))",
201 "answer": "select winner_2nd from table_1358608_4 where venue = \"belmont\""
202 },
203 {
204 "question": "Name the story number for paul cornell",
205 "context": "create table table_18012738_1 (story_no varchar, written_by varchar, PRIMARY KEY (story_no))",
206 "answer": "select story_no from table_18012738_1 where written_by = \"paul cornell\""
207 },
208 {
209 "question": "What is the human development index for the year 2000 where the ingei code is 10?",
210 "context": "create table table_1480455_1 (human_development_index__2000_ varchar, inegi_code varchar, PRIMARY KEY (human_development_index__2000_))",
211 "answer": "select human_development_index__2000_ from table_1480455_1 where inegi_code = 10"
212 },
213 {
214 "question": "How many times was lakpa tashi sherpa ( bhu ) w pts 12-5 in round of 32?",
215 "context": "create table table_26335424_86 (round_of_16 varchar, round_of_32 varchar, PRIMARY KEY (round_of_16))",
216 "answer": "select count(round_of_16) from table_26335424_86 where round_of_32 = \"lakpa tashi sherpa ( bhu ) w pts 12-5\""
217 },
218 {
219 "question": "What was the first day cover cancellation for the University of Saskatchewan themed stamp?",
220 "context": "create table table_11900773_5 (first_day_cover_cancellation varchar, theme varchar, PRIMARY KEY (first_day_cover_cancellation))",
221 "answer": "select first_day_cover_cancellation from table_11900773_5 where theme = \"university of saskatchewan\""
222 },
223 {
224 "question": "how many times was the candidates phil crane (r) 58.0% edward a. warman (d) 42.0%?",
225 "context": "create table table_1341718_14 (incumbent varchar, candidates varchar, PRIMARY KEY (incumbent))",
226 "answer": "select count(incumbent) from table_1341718_14 where candidates = \"phil crane (r) 58.0% edward a. warman (d) 42.0%\""
227 },
228 {
229 "question": "At what venue did Alex Mettam/Mark Williams be named Man of the Match?",
230 "context": "create table table_17120964_6 (venue varchar, man_of_the_match varchar, PRIMARY KEY (venue))",
231 "answer": "select venue from table_17120964_6 where man_of_the_match = \"alex mettam/mark williams\""
232 },
233 {
234 "question": "Find the name of students who took some course offered by Statistics department.",
235 "context": "create table student (name varchar, id varchar, PRIMARY KEY (name)); create table takes (course_id varchar, id varchar, PRIMARY KEY (course_id)); create table course (course_id varchar, dept_name varchar, PRIMARY KEY (course_id))",
236 "answer": "select t3.name from course as t1 join takes as t2 on t1.course_id = t2.course_id join student as t3 on t2.id = t3.id where t1.dept_name = 'statistics'"
237 },
238 {
239 "question": "Where did Audette Racing win?",
240 "context": "create table table_25773116_2 (location varchar, winning_team varchar, PRIMARY KEY (location))",
241 "answer": "select location from table_25773116_2 where winning_team = \"audette racing\""
242 },
243 {
244 "question": "Name the last title for 2012",
245 "context": "create table table_2454589_1 (last_title varchar, first_season_in_current_spell varchar, PRIMARY KEY (last_title))",
246 "answer": "select last_title from table_2454589_1 where first_season_in_current_spell = 2012"
247 },
248 {
249 "question": "Who was eliminated when the vote was 8-1?",
250 "context": "create table table_25016824_2 (eliminated varchar, vote varchar, PRIMARY KEY (eliminated))",
251 "answer": "select eliminated from table_25016824_2 where vote = \"8-1\""
252 },
253 {
254 "question": "What party did incumbent Howard Coble belong to?",
255 "context": "create table table_1341568_34 (party varchar, incumbent varchar, PRIMARY KEY (party))",
256 "answer": "select party from table_1341568_34 where incumbent = \"howard coble\""
257 },
258 {
259 "question": "How many zodiac signs does the month by the Thai name of \u0e01\u0e31\u0e19\u0e22\u0e32\u0e22\u0e19 belong to?",
260 "context": "create table table_180802_2 (zodiac_sign varchar, thai_name varchar, PRIMARY KEY (zodiac_sign))",
261 "answer": "select count(zodiac_sign) from table_180802_2 where thai_name = \"\u0e01\u0e31\u0e19\u0e22\u0e32\u0e22\u0e19\""
262 },
263 {
264 "question": "Who was the host country when Bar was the host city?",
265 "context": "create table table_26669939_1 (host_country varchar, host_city varchar, PRIMARY KEY (host_country))",
266 "answer": "select host_country from table_26669939_1 where host_city = \"bar\""
267 },
268 {
269 "question": "Who was the republican candidate in the race with incumbent thelma drake?",
270 "context": "create table table_17503169_1 (republican varchar, incumbent varchar, PRIMARY KEY (republican))",
271 "answer": "select republican from table_17503169_1 where incumbent = \"thelma drake\""
272 },
273 {
274 "question": "What is the config core 1 of the model with a processing power GFLOPs of 432?",
275 "context": "create table table_26860595_2 (config_core_1 varchar, processing_power_gflops varchar, PRIMARY KEY (config_core_1))",
276 "answer": "select config_core_1 from table_26860595_2 where processing_power_gflops = \"432\""
277 },
278 {
279 "question": "What was the percentage increase in spending on international tourism from 2011 to 2012 of the country that spent $85.9 billion in 2011?",
280 "context": "create table table_29789_3 (_percentage_change varchar, international_tourism_expenditure_2011 varchar, PRIMARY KEY (_percentage_change))",
281 "answer": "select _percentage_change from table_29789_3 where international_tourism_expenditure_2011 = \"$85.9 billion\""
282 },
283 {
284 "question": "On which episode did actress Sela Ward make her last appearance?",
285 "context": "create table table_11240028_1 (last_appearance varchar, portrayed_by varchar, PRIMARY KEY (last_appearance))",
286 "answer": "select last_appearance from table_11240028_1 where portrayed_by = \"sela ward\""
287 },
288 {
289 "question": "Show all paragraph ids and texts for the document with name 'Welcome to NY'.",
290 "context": "create table documents (document_id varchar, document_name varchar, PRIMARY KEY (document_id)); create table paragraphs (paragraph_id varchar, paragraph_text varchar, document_id varchar, PRIMARY KEY (paragraph_id))",
291 "answer": "select t1.paragraph_id, t1.paragraph_text from paragraphs as t1 join documents as t2 on t1.document_id = t2.document_id where t2.document_name = 'welcome to ny'"
292 },
293 {
294 "question": "How many transactions do we have?",
295 "context": "create table financial_transactions (id varchar, PRIMARY KEY (id))",
296 "answer": "select count(*) from financial_transactions"
297 },
298 {
299 "question": "What is the number of external links with a coach named Katie Kansas?",
300 "context": "create table table_2140071_13 (external_link varchar, coach varchar, PRIMARY KEY (external_link))",
301 "answer": "select count(external_link) from table_2140071_13 where coach = \"katie kansas\""
302 },
303 {
304 "question": "List the first names of people in alphabetical order?",
305 "context": "create table people (first_name varchar, PRIMARY KEY (first_name))",
306 "answer": "select first_name from people order by first_name"
307 },
308 {
309 "question": "When did the program air on Vier?",
310 "context": "create table table_178242_1 (premiere___aired varchar, channel varchar, PRIMARY KEY (premiere___aired))",
311 "answer": "select premiere___aired from table_178242_1 where channel = \"vier\""
312 },
313 {
314 "question": "List directors and producers when the celebrities involved were Bill Turnbull and Louise Minchin.",
315 "context": "create table table_24725951_1 (directed_and_produced_by varchar, celebrities varchar, PRIMARY KEY (directed_and_produced_by))",
316 "answer": "select directed_and_produced_by from table_24725951_1 where celebrities = \"bill turnbull and louise minchin\""
317 },
318 {
319 "question": "What are the investors of entrepreneurs and the corresponding number of entrepreneurs invested by each investor?",
320 "context": "create table entrepreneur (investor varchar, PRIMARY KEY (investor))",
321 "answer": "select investor, count(*) from entrepreneur group by investor"
322 },
323 {
324 "question": "What is the percentage of others when the number for Bush is 1329?",
325 "context": "create table table_1733513_1 (others_percentage varchar, bush_number varchar, PRIMARY KEY (others_percentage))",
326 "answer": "select others_percentage from table_1733513_1 where bush_number = 1329"
327 },
328 {
329 "question": "How many earnings values are associated with players who had a best finish of T38?",
330 "context": "create table table_28540609_2 (earnings__ varchar, best_finish varchar, PRIMARY KEY (earnings__))",
331 "answer": "select count(earnings__) as \u20ac_ from table_28540609_2 where best_finish = \"t38\""
332 },
333 {
334 "question": "What is the nt identity when the species is drosophilia melanogaster?",
335 "context": "create table table_26708105_5 (nt_identity varchar, species varchar, PRIMARY KEY (nt_identity))",
336 "answer": "select nt_identity from table_26708105_5 where species = \"drosophilia melanogaster\""
337 },
338 {
339 "question": "When was the show first aired that was viewed by 3.57 million U.S. viewers?",
340 "context": "create table table_11694832_1 (original_air_date varchar, us_viewers__millions_ varchar, PRIMARY KEY (original_air_date))",
341 "answer": "select original_air_date from table_11694832_1 where us_viewers__millions_ = \"3.57\""
342 },
343 {
344 "question": "On what circuit was the City of Ipswich 400 race held?",
345 "context": "create table table_14016079_1 (circuit varchar, race_title varchar, PRIMARY KEY (circuit))",
346 "answer": "select circuit from table_14016079_1 where race_title = \"city of ipswich 400\""
347 },
348 {
349 "question": "How many wrestlers were born in nara, and have a completed 'career and other notes' section?",
350 "context": "create table table_1557974_1 (career_and_other_notes varchar, birthplace varchar, PRIMARY KEY (career_and_other_notes))",
351 "answer": "select count(career_and_other_notes) from table_1557974_1 where birthplace = \"nara\""
352 },
353 {
354 "question": "How many data are there under NO vote with a description of $1500 tax exemption amendment?",
355 "context": "create table table_256286_8 (no_votes varchar, description varchar, PRIMARY KEY (no_votes))",
356 "answer": "select count(no_votes) from table_256286_8 where description = \"$1500 tax exemption amendment\""
357 },
358 {
359 "question": "When interjection is the subject how many performers are there?",
360 "context": "create table table_191105_2 (performed_by varchar, subject varchar, PRIMARY KEY (performed_by))",
361 "answer": "select count(performed_by) from table_191105_2 where subject = \"interjection\""
362 },
363 {
364 "question": "Who was the winner when Mateus Rocha finished in 3rd place?",
365 "context": "create table table_25214321_1 (winner varchar, third_place varchar, PRIMARY KEY (winner))",
366 "answer": "select winner from table_25214321_1 where third_place = \"mateus rocha\""
367 },
368 {
369 "question": "Name the manner of departure for luis enrique",
370 "context": "create table table_27666856_3 (manner_of_departure varchar, outgoing_manager varchar, PRIMARY KEY (manner_of_departure))",
371 "answer": "select manner_of_departure from table_27666856_3 where outgoing_manager = \"luis enrique\""
372 },
373 {
374 "question": "The theme Auditioner's Choice\thas what song choice?",
375 "context": "create table table_26250199_1 (song_choice varchar, theme varchar, PRIMARY KEY (song_choice))",
376 "answer": "select song_choice from table_26250199_1 where theme = \"auditioner's choice\""
377 },
378 {
379 "question": "What episode did tomoyuki furumaya",
380 "context": "create table table_29039942_1 (title varchar, director varchar, PRIMARY KEY (title))",
381 "answer": "select title from table_29039942_1 where director = \"tomoyuki furumaya\""
382 },
383 {
384 "question": "What are the names and location of the shops in ascending alphabetical order of name.",
385 "context": "create table shop (shop_name varchar, location varchar, PRIMARY KEY (shop_name))",
386 "answer": "select shop_name, location from shop order by shop_name"
387 },
388 {
389 "question": "When bbc two is the original channel what is the date of original removal?",
390 "context": "create table table_19114172_11 (date_s__of_original_removal varchar, original_channel varchar, PRIMARY KEY (date_s__of_original_removal))",
391 "answer": "select date_s__of_original_removal from table_19114172_11 where original_channel = \"bbc two\""
392 },
393 {
394 "question": "What is the nationality of th player who's school is Clemson?",
395 "context": "create table table_15621965_16 (nationality varchar, school_club_team varchar, PRIMARY KEY (nationality))",
396 "answer": "select nationality from table_15621965_16 where school_club_team = \"clemson\""
397 },
398 {
399 "question": "what is b - bishop where ab - angry boar is vw - vertical wolf?",
400 "context": "create table table_2603017_2 (b___bishop varchar, ab___angry_boar varchar, PRIMARY KEY (b___bishop))",
401 "answer": "select b___bishop from table_2603017_2 where ab___angry_boar = \"vw - vertical wolf\""
402 },
403 {
404 "question": "What is the meaning of a gentle personality?",
405 "context": "create table table_1912713_2 (\u610f\u7fa9_meaning varchar, \u6027\u60c5_personality varchar, PRIMARY KEY (\u610f\u7fa9_meaning))",
406 "answer": "select \u610f\u7fa9_meaning from table_1912713_2 where \u6027\u60c5_personality = \"gentle\""
407 },
408 {
409 "question": "Why did Robert L. Bacon (r) vacate?",
410 "context": "create table table_2159547_3 (reason_for_change varchar, vacator varchar, PRIMARY KEY (reason_for_change))",
411 "answer": "select reason_for_change from table_2159547_3 where vacator = \"robert l. bacon (r)\""
412 },
413 {
414 "question": "What party represents the district with incumbent matthew clay?",
415 "context": "create table table_2668378_18 (party varchar, incumbent varchar, PRIMARY KEY (party))",
416 "answer": "select party from table_2668378_18 where incumbent = \"matthew clay\""
417 },
418 {
419 "question": "Where did Kisnorbo move from?",
420 "context": "create table table_22810095_8 (moving_from varchar, name varchar, PRIMARY KEY (moving_from))",
421 "answer": "select moving_from from table_22810095_8 where name = \"kisnorbo\""
422 },
423 {
424 "question": "Who played River Plate?",
425 "context": "create table table_17282875_3 (team__number2 varchar, team__number1 varchar, PRIMARY KEY (team__number2))",
426 "answer": "select team__number2 from table_17282875_3 where team__number1 = \"river plate\""
427 },
428 {
429 "question": "what's the\u00a0title\u00a0where\u00a0original air date\u00a0is january18,2009",
430 "context": "create table table_11589522_3 (title varchar, original_air_date varchar, PRIMARY KEY (title))",
431 "answer": "select title from table_11589522_3 where original_air_date = \"january18,2009\""
432 },
433 {
434 "question": "What is the largest ethnic group in 2002 for the cyrillic name, other name of \u0431\u0435\u0448\u043a\u0430?",
435 "context": "create table table_2562572_54 (largest_ethnic_group__2002_ varchar, cyrillic_name_other_names varchar, PRIMARY KEY (largest_ethnic_group__2002_))",
436 "answer": "select largest_ethnic_group__2002_ from table_2562572_54 where cyrillic_name_other_names = \"\u0431\u0435\u0448\u043a\u0430\""
437 },
438 {
439 "question": "Name the english translation of 219",
440 "context": "create table table_13003460_1 (english_translation varchar, word_number varchar, PRIMARY KEY (english_translation))",
441 "answer": "select english_translation from table_13003460_1 where word_number = \"219\""
442 },
443 {
444 "question": "What conference is Tennessee?",
445 "context": "create table table_26423157_2 (conference varchar, school varchar, PRIMARY KEY (conference))",
446 "answer": "select conference from table_26423157_2 where school = \"tennessee\""
447 },
448 {
449 "question": "List the names and the locations that the enzymes can make an effect.",
450 "context": "create table enzyme (name varchar, location varchar, PRIMARY KEY (name))",
451 "answer": "select name, location from enzyme"
452 },
453 {
454 "question": "When portsmouth is the city of license who is the licensee?",
455 "context": "create table table_1949746_1 (licensee varchar, city_of_license varchar, PRIMARY KEY (licensee))",
456 "answer": "select licensee from table_1949746_1 where city_of_license = \"portsmouth\""
457 },
458 {
459 "question": "How many viewers in millions watched the episode 23:55 minutes long?",
460 "context": "create table table_1849243_1 (viewers__in_millions_ varchar, run_time varchar, PRIMARY KEY (viewers__in_millions_))",
461 "answer": "select viewers__in_millions_ from table_1849243_1 where run_time = \"23:55\""
462 },
463 {
464 "question": "What are the names of perpetrators?",
465 "context": "create table perpetrator (people_id varchar, PRIMARY KEY (people_id)); create table people (name varchar, people_id varchar, PRIMARY KEY (name))",
466 "answer": "select t1.name from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id"
467 },
468 {
469 "question": "What is the theme for Audition week?",
470 "context": "create table table_26250176_1 (theme varchar, week__number varchar, PRIMARY KEY (theme))",
471 "answer": "select theme from table_26250176_1 where week__number = \"audition\""
472 },
473 {
474 "question": "What are all the states (class) when the successor was Joseph Anderson ( DR )?",
475 "context": "create table table_224839_3 (state__class_ varchar, successor varchar, PRIMARY KEY (state__class_))",
476 "answer": "select state__class_ from table_224839_3 where successor = \"joseph anderson ( dr )\""
477 },
478 {
479 "question": "What is the record when the high points is listed as Stephen Curry (32)?",
480 "context": "create table table_27755784_8 (record varchar, high_points varchar, PRIMARY KEY (record))",
481 "answer": "select record from table_27755784_8 where high_points = \"stephen curry (32)\""
482 },
483 {
484 "question": "Who had the most high points and rebounds than charles oakley (9)?",
485 "context": "create table table_13812785_8 (high_points varchar, high_rebounds varchar, PRIMARY KEY (high_points))",
486 "answer": "select high_points from table_13812785_8 where high_rebounds = \"charles oakley (9)\""
487 },
488 {
489 "question": "What is the 2fm for rnag 94.4?",
490 "context": "create table table_18475946_2 (rnag__mhz_ varchar, PRIMARY KEY (rnag__mhz_))",
491 "answer": "select 2 as fm__mhz_ from table_18475946_2 where rnag__mhz_ = \"94.4\""
492 },
493 {
494 "question": "Name the total number of hdtv for eurotic tv",
495 "context": "create table table_15887683_17 (hdtv varchar, television_service varchar, PRIMARY KEY (hdtv))",
496 "answer": "select count(hdtv) from table_15887683_17 where television_service = \"eurotic tv\""
497 },
498 {
499 "question": "What background does the person from New york, New york, have?",
500 "context": "create table table_1289860_2 (background varchar, hometown varchar, PRIMARY KEY (background))",
501 "answer": "select background from table_1289860_2 where hometown = \"new york, new york\""
502 },
503 {
504 "question": "What was team Toshiba's round 4 score?",
505 "context": "create table table_16815824_1 (round4 integer, team varchar, PRIMARY KEY (round4))",
506 "answer": "select min(round4) from table_16815824_1 where team = \"team toshiba\""
507 },
508 {
509 "question": "What are the id of students who registered course 301?",
510 "context": "create table student_course_attendance (student_id varchar, course_id varchar, PRIMARY KEY (student_id))",
511 "answer": "select student_id from student_course_attendance where course_id = 301"
512 },
513 {
514 "question": "List all club names in ascending order of start year.",
515 "context": "create table club (name varchar, start_year varchar, PRIMARY KEY (name))",
516 "answer": "select name from club order by start_year"
517 },
518 {
519 "question": "When the earning per share is listed as 22.0 what is the year to april?",
520 "context": "create table table_18077713_1 (year_to_april varchar, earnings_per_share__\u00a2_ varchar, PRIMARY KEY (year_to_april))",
521 "answer": "select count(year_to_april) from table_18077713_1 where earnings_per_share__\u00a2_ = \"22.0\""
522 },
523 {
524 "question": "What is the name of the candidate where the incumbent is named James P. Buchanan?",
525 "context": "create table table_1342331_43 (candidates varchar, incumbent varchar, PRIMARY KEY (candidates))",
526 "answer": "select candidates from table_1342331_43 where incumbent = \"james p. buchanan\""
527 },
528 {
529 "question": "What is the name of the war where the Ottoman sultan was Selim I?",
530 "context": "create table table_24706337_1 (name_of_the_war varchar, ottoman_sultan varchar, PRIMARY KEY (name_of_the_war))",
531 "answer": "select name_of_the_war from table_24706337_1 where ottoman_sultan = \"selim i\""
532 },
533 {
534 "question": "How many were the show's average weekly ranking when it reached No. 2 in average nightly ranking?",
535 "context": "create table table_15358729_6 (average_weekly_rank varchar, average_nightly_rank varchar, PRIMARY KEY (average_weekly_rank))",
536 "answer": "select count(average_weekly_rank) from table_15358729_6 where average_nightly_rank = \"no. 2\""
537 },
538 {
539 "question": "How many assessment notes are there in total?",
540 "context": "create table assessment_notes (id varchar, PRIMARY KEY (id))",
541 "answer": "select count(*) from assessment_notes"
542 },
543 {
544 "question": "What is the name of the actress that was nominated for best actress in a leading role in the film Chopin: Desire for love?",
545 "context": "create table table_10236830_6 (actors_name varchar, film_name varchar, nomination varchar, PRIMARY KEY (actors_name))",
546 "answer": "select actors_name from table_10236830_6 where film_name = \"chopin: desire for love\" and nomination = \"best actress in a leading role\""
547 },
548 {
549 "question": "meadowlands sports complex is the circuit at which city/location?",
550 "context": "create table table_10707142_2 (city_location varchar, circuit varchar, PRIMARY KEY (city_location))",
551 "answer": "select city_location from table_10707142_2 where circuit = \"meadowlands sports complex\""
552 },
553 {
554 "question": "What are the networks whose version of the show includes the judges batuhan zeynio\u011flu piatti murat bozok erol kaynar?",
555 "context": "create table table_28190363_1 (network varchar, judges varchar, PRIMARY KEY (network))",
556 "answer": "select network from table_28190363_1 where judges = \"batuhan zeynio\u011flu piatti murat bozok erol kaynar\""
557 },
558 {
559 "question": "How many dominant religions are in \u0111ala?",
560 "context": "create table table_2562572_30 (dominant_religion__2002_ varchar, settlement varchar, PRIMARY KEY (dominant_religion__2002_))",
561 "answer": "select count(dominant_religion__2002_) from table_2562572_30 where settlement = \"\u0111ala\""
562 },
563 {
564 "question": "Name the payout for espn for music city bowl",
565 "context": "create table table_24427210_1 (payout___us$__ varchar, tv varchar, bowl_game varchar, PRIMARY KEY (payout___us$__))",
566 "answer": "select payout___us$__ from table_24427210_1 where tv = \"espn\" and bowl_game = \"music city bowl\""
567 },
568 {
569 "question": "What was the air date of the episod that had 456.58 thousand viewers?",
570 "context": "create table table_23114705_7 (original_air_date varchar, nz_viewers__thousand_ varchar, PRIMARY KEY (original_air_date))",
571 "answer": "select original_air_date from table_23114705_7 where nz_viewers__thousand_ = \"456.58\""
572 },
573 {
574 "question": "When fc oberau is the oberbayern a what is the oberpfalz?",
575 "context": "create table table_23224961_1 (oberpfalz varchar, oberbayern_a varchar, PRIMARY KEY (oberpfalz))",
576 "answer": "select oberpfalz from table_23224961_1 where oberbayern_a = \"fc oberau\""
577 },
578 {
579 "question": "Where is Tamunosiki Atorudibo from",
580 "context": "create table table_1231316_4 (country varchar, athlete varchar, PRIMARY KEY (country))",
581 "answer": "select country from table_1231316_4 where athlete = \"tamunosiki atorudibo\""
582 },
583 {
584 "question": "Which Allied Force targetted Woensdrecht?",
585 "context": "create table table_1160161_12 (allied_forces varchar, target varchar, PRIMARY KEY (allied_forces))",
586 "answer": "select allied_forces from table_1160161_12 where target = \"woensdrecht\""
587 },
588 {
589 "question": "Show ids for all documents in type CV without expense budgets.",
590 "context": "create table documents_with_expenses (document_id varchar, document_type_code varchar, PRIMARY KEY (document_id)); create table documents (document_id varchar, document_type_code varchar, PRIMARY KEY (document_id))",
591 "answer": "select document_id from documents where document_type_code = \"cv\" except select document_id from documents_with_expenses"
592 },
593 {
594 "question": "Name the centerfold model when interview subject is steve jobs",
595 "context": "create table table_1566848_6 (centerfold_model varchar, interview_subject varchar, PRIMARY KEY (centerfold_model))",
596 "answer": "select centerfold_model from table_1566848_6 where interview_subject = \"steve jobs\""
597 },
598 {
599 "question": "What is the number eliminated when kelly and brendan are safe?",
600 "context": "create table table_12305325_4 (eliminated varchar, safe varchar, PRIMARY KEY (eliminated))",
601 "answer": "select count(eliminated) from table_12305325_4 where safe = \"kelly and brendan\""
602 },
603 {
604 "question": "Name the mixed doubles when tour is hong kong super series",
605 "context": "create table table_14496232_2 (mixed_doubles varchar, tour varchar, PRIMARY KEY (mixed_doubles))",
606 "answer": "select mixed_doubles from table_14496232_2 where tour = \"hong kong super series\""
607 },
608 {
609 "question": "Name the most of 2500-3000ft",
610 "context": "create table table_1456056_1 (id varchar, PRIMARY KEY (id))",
611 "answer": "select max(2500 as _3000ft) from table_1456056_1"
612 },
613 {
614 "question": "which team#2 played against poseidon neoi porroi",
615 "context": "create table table_21434618_1 (team__number2 varchar, team__number1 varchar, PRIMARY KEY (team__number2))",
616 "answer": "select team__number2 from table_21434618_1 where team__number1 = \"poseidon neoi porroi\""
617 },
618 {
619 "question": "What is the ISIN associated with the maturity date of 3/11/2011?",
620 "context": "create table table_21692771_1 (isin varchar, maturity varchar, PRIMARY KEY (isin))",
621 "answer": "select isin from table_21692771_1 where maturity = \"3/11/2011\""
622 },
623 {
624 "question": "What is the gpa per capita (nominal) for the country with gdp (nominal) is $52.0 billion?",
625 "context": "create table table_11780179_1 (gdp_per_capita__nominal_ varchar, gdp__nominal_ varchar, PRIMARY KEY (gdp_per_capita__nominal_))",
626 "answer": "select gdp_per_capita__nominal_ from table_11780179_1 where gdp__nominal_ = \"$52.0 billion\""
627 },
628 {
629 "question": "Name the host for john rotz and howard cosell",
630 "context": "create table table_22514845_5 (s_host varchar, s_analyst varchar, PRIMARY KEY (s_host))",
631 "answer": "select s_host from table_22514845_5 where s_analyst = \"john rotz and howard cosell\""
632 },
633 {
634 "question": "Name the total number of party for willis alston",
635 "context": "create table table_2668243_18 (party varchar, incumbent varchar, PRIMARY KEY (party))",
636 "answer": "select count(party) from table_2668243_18 where incumbent = \"willis alston\""
637 },
638 {
639 "question": "Which organisation hired the most number of research staff? List the organisation id, type and detail.",
640 "context": "create table organisations (organisation_id varchar, organisation_type varchar, organisation_details varchar, PRIMARY KEY (organisation_id)); create table research_staff (employer_organisation_id varchar, PRIMARY KEY (employer_organisation_id))",
641 "answer": "select t1.organisation_id, t1.organisation_type, t1.organisation_details from organisations as t1 join research_staff as t2 on t1.organisation_id = t2.employer_organisation_id group by t1.organisation_id order by count(*) desc limit 1"
642 },
643 {
644 "question": "How many paper types did Ian Drolet design stamps on?",
645 "context": "create table table_11900773_6 (paper_type varchar, design varchar, PRIMARY KEY (paper_type))",
646 "answer": "select count(paper_type) from table_11900773_6 where design = \"ian drolet\""
647 },
648 {
649 "question": "What barony is Ballycunningham in?",
650 "context": "create table table_30120566_1 (barony varchar, townland varchar, PRIMARY KEY (barony))",
651 "answer": "select barony from table_30120566_1 where townland = \"ballycunningham\""
652 },
653 {
654 "question": "how many video out connections does the sounddock portable have?",
655 "context": "create table table_24384861_1 (video_out varchar, version varchar, PRIMARY KEY (video_out))",
656 "answer": "select count(video_out) from table_24384861_1 where version = \"sounddock portable\""
657 },
658 {
659 "question": "What is the composition at Valles lava dome?",
660 "context": "create table table_1081235_1 (composition varchar, name_of_lava_dome varchar, PRIMARY KEY (composition))",
661 "answer": "select composition from table_1081235_1 where name_of_lava_dome = \"valles lava dome\""
662 },
663 {
664 "question": "Who had the highest points against new york?",
665 "context": "create table table_23211041_5 (high_points varchar, team varchar, PRIMARY KEY (high_points))",
666 "answer": "select high_points from table_23211041_5 where team = \"new york\""
667 },
668 {
669 "question": "How many submission of the night occurred when the fighter was matt wiman?",
670 "context": "create table table_21114902_1 (submissions_of_the_night integer, fighter varchar, PRIMARY KEY (submissions_of_the_night))",
671 "answer": "select max(submissions_of_the_night) from table_21114902_1 where fighter = \"matt wiman\""
672 },
673 {
674 "question": "What was Great Britain's Round 1 score?",
675 "context": "create table table_16815824_1 (round1 varchar, team varchar, PRIMARY KEY (round1))",
676 "answer": "select round1 from table_16815824_1 where team = \"great britain\""
677 },
678 {
679 "question": "where is Fisk University located?",
680 "context": "create table table_262481_2 (location varchar, institution varchar, PRIMARY KEY (location))",
681 "answer": "select location from table_262481_2 where institution = \"fisk university\""
682 },
683 {
684 "question": "What are the mm dimensions of the Plustek Mobileoffice D28 Corporate?",
685 "context": "create table table_16409745_1 (dimensions__mm_ varchar, product varchar, PRIMARY KEY (dimensions__mm_))",
686 "answer": "select dimensions__mm_ from table_16409745_1 where product = \"plustek mobileoffice d28 corporate\""
687 },
688 {
689 "question": "How many times has the points total for the afc cup competion been 289?",
690 "context": "create table table_14460937_1 (afc_cup varchar, points__total_500_ varchar, PRIMARY KEY (afc_cup))",
691 "answer": "select count(afc_cup) from table_14460937_1 where points__total_500_ = 289"
692 },
693 {
694 "question": "What is the famous for where the finished is 5th?",
695 "context": "create table table_14345690_5 (famous_for varchar, finished varchar, PRIMARY KEY (famous_for))",
696 "answer": "select famous_for from table_14345690_5 where finished = \"5th\""
697 },
698 {
699 "question": "How many people in the sorata municipality when the quiabaya municipality has 33?",
700 "context": "create table table_2509202_2 (sorata_municipality varchar, quiabaya_municipality varchar, PRIMARY KEY (sorata_municipality))",
701 "answer": "select sorata_municipality from table_2509202_2 where quiabaya_municipality = \"33\""
702 },
703 {
704 "question": "What year was a movie with the original title La Leggenda del Santo Bevitore submitted?",
705 "context": "create table table_10321805_1 (year__ceremony_ varchar, original_title varchar, PRIMARY KEY (year__ceremony_))",
706 "answer": "select year__ceremony_ from table_10321805_1 where original_title = \"la leggenda del santo bevitore\""
707 },
708 {
709 "question": "which countries' tv channels are not playing any cartoon written by Todd Casey?",
710 "context": "create table tv_channel (country varchar, id varchar, PRIMARY KEY (country)); create table tv_channel (country varchar, PRIMARY KEY (country)); create table cartoon (channel varchar, written_by varchar, PRIMARY KEY (channel))",
711 "answer": "select country from tv_channel except select t1.country from tv_channel as t1 join cartoon as t2 on t1.id = t2.channel where t2.written_by = 'todd casey'"
712 },
713 {
714 "question": "How many railways are there?",
715 "context": "create table railway (id varchar, PRIMARY KEY (id))",
716 "answer": "select count(*) from railway"
717 },
718 {
719 "question": "Which province is grey and bell electorate in",
720 "context": "create table table_1024710_2 (province varchar, electorate varchar, PRIMARY KEY (province))",
721 "answer": "select province from table_1024710_2 where electorate = \"grey and bell\""
722 },
723 {
724 "question": "Name the total number of status for eldon",
725 "context": "create table table_171361_2 (status varchar, official_name varchar, PRIMARY KEY (status))",
726 "answer": "select count(status) from table_171361_2 where official_name = \"eldon\""
727 },
728 {
729 "question": "How many were wounded when the complement was 173 off 2059 men?",
730 "context": "create table table_11793221_2 (wounded varchar, complement varchar, PRIMARY KEY (wounded))",
731 "answer": "select wounded from table_11793221_2 where complement = \"173 off 2059 men\""
732 },
733 {
734 "question": "What is the height in inches of contestants who are from the province of La Rioja?",
735 "context": "create table table_23476629_2 (height__in_ varchar, province varchar, PRIMARY KEY (height__in_))",
736 "answer": "select height__in_ from table_23476629_2 where province = \"la rioja\""
737 },
738 {
739 "question": "Who directed the episode that had 3.55 million viewers?",
740 "context": "create table table_29897962_1 (directed_by varchar, us_viewers__million_ varchar, PRIMARY KEY (directed_by))",
741 "answer": "select directed_by from table_29897962_1 where us_viewers__million_ = \"3.55\""
742 },
743 {
744 "question": "What type of school is Cordoba University?",
745 "context": "create table table_2076608_3 (type varchar, school varchar, PRIMARY KEY (type))",
746 "answer": "select type from table_2076608_3 where school = \"cordoba university\""
747 },
748 {
749 "question": "What's the percentage of votes for other candidates in the county where Bush got 51.6% of the votes?",
750 "context": "create table table_1304443_2 (others_percentage varchar, bush_percentage varchar, PRIMARY KEY (others_percentage))",
751 "answer": "select others_percentage from table_1304443_2 where bush_percentage = \"51.6%\""
752 },
753 {
754 "question": "Name the conventional for defter",
755 "context": "create table table_2008069_2 (conventional varchar, uyghur___yen\u0261i_yezik\u0322__ varchar, PRIMARY KEY (conventional))",
756 "answer": "select conventional from table_2008069_2 where uyghur___yen\u0261i_yezik\u0322__ = \"defter\""
757 },
758 {
759 "question": "List the lowest super league for a 0 champion league.",
760 "context": "create table table_28068645_8 (super_league integer, champions_league varchar, PRIMARY KEY (super_league))",
761 "answer": "select min(super_league) from table_28068645_8 where champions_league = 0"
762 },
763 {
764 "question": "How many total itv viewers were there for the episode with official itv ratings of 10.24 million?",
765 "context": "create table table_27319183_7 (total_itv_viewers__millions_ varchar, official_itv_rating__millions_ varchar, PRIMARY KEY (total_itv_viewers__millions_))",
766 "answer": "select total_itv_viewers__millions_ from table_27319183_7 where official_itv_rating__millions_ = \"10.24\""
767 },
768 {
769 "question": "Who scored the most points against Washington?",
770 "context": "create table table_15780049_5 (high_points varchar, team varchar, PRIMARY KEY (high_points))",
771 "answer": "select high_points from table_15780049_5 where team = \"washington\""
772 },
773 {
774 "question": "How many odd of winning have 6th as the division?",
775 "context": "create table table_20195922_3 (odds_of_winning__1in_ varchar, divisions varchar, PRIMARY KEY (odds_of_winning__1in_))",
776 "answer": "select odds_of_winning__1in_ from table_20195922_3 where divisions = \"6th\""
777 },
778 {
779 "question": "What is the minimum possible for the NJCAA championships?",
780 "context": "create table table_22319599_1 (njcaa_championships integer, PRIMARY KEY (njcaa_championships))",
781 "answer": "select min(njcaa_championships) from table_22319599_1"
782 },
783 {
784 "question": "What range does type FJ/PB/SCP work at?",
785 "context": "create table table_21538523_1 (range__m_ varchar, type varchar, PRIMARY KEY (range__m_))",
786 "answer": "select range__m_ from table_21538523_1 where type = \"fj/pb/scp\""
787 },
788 {
789 "question": "What is the title written by David Mamet?",
790 "context": "create table table_10908676_7 (title varchar, written_by varchar, PRIMARY KEY (title))",
791 "answer": "select title from table_10908676_7 where written_by = \"david mamet\""
792 },
793 {
794 "question": "Find the last names of students with major 50.",
795 "context": "create table student (lname varchar, major varchar, PRIMARY KEY (lname))",
796 "answer": "select lname from student where major = 50"
797 },
798 {
799 "question": "Show all distinct building descriptions.",
800 "context": "create table apartment_buildings (building_description varchar, PRIMARY KEY (building_description))",
801 "answer": "select distinct building_description from apartment_buildings"
802 },
803 {
804 "question": "What is the 3'utr sequence with a variant id of ad'6a 4?",
805 "context": "create table table_14332822_1 (variant_id varchar, PRIMARY KEY (variant_id))",
806 "answer": "select 3 as \u2019utr_sequence from table_14332822_1 where variant_id = \"ad'6a 4\""
807 },
808 {
809 "question": "Who is the person that has no friend?",
810 "context": "create table personfriend (name varchar, PRIMARY KEY (name)); create table person (name varchar, PRIMARY KEY (name))",
811 "answer": "select name from person except select name from personfriend"
812 },
813 {
814 "question": "What is the dominant religion in Gornji Tavankut?",
815 "context": "create table table_2562572_26 (dominant_religion__2002_ varchar, settlement varchar, PRIMARY KEY (dominant_religion__2002_))",
816 "answer": "select dominant_religion__2002_ from table_2562572_26 where settlement = \"gornji tavankut\""
817 },
818 {
819 "question": "what are all the date withdrawn for service entered on 21 november 1945",
820 "context": "create table table_11662133_3 (date_withdrawn varchar, date_entered_service varchar, PRIMARY KEY (date_withdrawn))",
821 "answer": "select date_withdrawn from table_11662133_3 where date_entered_service = \"21 november 1945\""
822 },
823 {
824 "question": "What are the document ids for the budget type code 'SF'?",
825 "context": "create table documents_with_expenses (document_id varchar, budget_type_code varchar, PRIMARY KEY (document_id))",
826 "answer": "select document_id from documents_with_expenses where budget_type_code = 'sf'"
827 },
828 {
829 "question": "How man students were from Maryland in Fall 05?",
830 "context": "create table table_15055594_6 (fall_05 varchar, states varchar, PRIMARY KEY (fall_05))",
831 "answer": "select fall_05 from table_15055594_6 where states = \"maryland\""
832 },
833 {
834 "question": "How many original artists were there for the Group Performance?",
835 "context": "create table table_26250176_1 (original_artist varchar, theme varchar, PRIMARY KEY (original_artist))",
836 "answer": "select count(original_artist) from table_26250176_1 where theme = \"group performance\""
837 },
838 {
839 "question": "Who was the mediator in k\u014dhaku number 53?",
840 "context": "create table table_1315616_1 (mediator varchar, k\u014dhaku__number varchar, PRIMARY KEY (mediator))",
841 "answer": "select mediator from table_1315616_1 where k\u014dhaku__number = 53"
842 },
843 {
844 "question": "Find the name of all customers.",
845 "context": "create table customers (customer_name varchar, PRIMARY KEY (customer_name))",
846 "answer": "select customer_name from customers"
847 },
848 {
849 "question": "How many reviewers listed?",
850 "context": "create table reviewer (id varchar, PRIMARY KEY (id))",
851 "answer": "select count(*) from reviewer"
852 },
853 {
854 "question": "Which province has a density of 971.4?",
855 "context": "create table table_1067441_1 (province varchar, density varchar, PRIMARY KEY (province))",
856 "answer": "select province from table_1067441_1 where density = \"971.4\""
857 },
858 {
859 "question": "What is the lowest number associated with Tonkolili?",
860 "context": "create table table_18103265_1 (tonkolili integer, PRIMARY KEY (tonkolili))",
861 "answer": "select min(tonkolili) from table_18103265_1"
862 },
863 {
864 "question": "Who was replaced as manager on June 20?",
865 "context": "create table table_29414946_3 (outgoing_manager varchar, date_of_appointment varchar, PRIMARY KEY (outgoing_manager))",
866 "answer": "select outgoing_manager from table_29414946_3 where date_of_appointment = \"june 20\""
867 },
868 {
869 "question": "Name the home team for manuka oval",
870 "context": "create table table_14312471_3 (home_team varchar, ground varchar, PRIMARY KEY (home_team))",
871 "answer": "select home_team from table_14312471_3 where ground = \"manuka oval\""
872 },
873 {
874 "question": "Name the running with for elizabeth falco",
875 "context": "create table table_1855841_1 (running_with__in_team_ varchar, candidate varchar, PRIMARY KEY (running_with__in_team_))",
876 "answer": "select running_with__in_team_ from table_1855841_1 where candidate = \"elizabeth falco\""
877 },
878 {
879 "question": "What was the result of the open cup when they finished 4th in the regular season?",
880 "context": "create table table_12002388_1 (open_cup varchar, reg_season varchar, PRIMARY KEY (open_cup))",
881 "answer": "select open_cup from table_12002388_1 where reg_season = \"4th\""
882 },
883 {
884 "question": "find the number of distinct country codes of all players.",
885 "context": "create table players (country_code varchar, PRIMARY KEY (country_code))",
886 "answer": "select count(distinct country_code) from players"
887 },
888 {
889 "question": "How many 4wi were recorded by the player with an economy of 4.17?",
890 "context": "create table table_27922491_20 (economy varchar, PRIMARY KEY (economy))",
891 "answer": "select 4 as wi from table_27922491_20 where economy = \"4.17\""
892 },
893 {
894 "question": "Name the date of appointment for sacked and 14th position replaced by marco kostmann",
895 "context": "create table table_17327264_3 (date_of_appointment varchar, replaced_by varchar, manner_of_departure varchar, position_in_table varchar, PRIMARY KEY (date_of_appointment))",
896 "answer": "select date_of_appointment from table_17327264_3 where manner_of_departure = \"sacked\" and position_in_table = \"14th\" and replaced_by = \"marco kostmann\""
897 },
898 {
899 "question": "How many air dates where directed by jim donovan?",
900 "context": "create table table_18424435_5 (us_air_date varchar, directed_by varchar, PRIMARY KEY (us_air_date))",
901 "answer": "select count(us_air_date) from table_18424435_5 where directed_by = \"jim donovan\""
902 },
903 {
904 "question": "List each owner's first name, last name, and the size of his for her dog.",
905 "context": "create table owners (first_name varchar, last_name varchar, owner_id varchar, PRIMARY KEY (first_name)); create table dogs (size_code varchar, owner_id varchar, PRIMARY KEY (size_code))",
906 "answer": "select t1.first_name, t1.last_name, t2.size_code from owners as t1 join dogs as t2 on t1.owner_id = t2.owner_id"
907 },
908 {
909 "question": "what is the amount where the area is new brunswick",
910 "context": "create table table_29012710_1 (production__hectolitres_ varchar, province varchar, PRIMARY KEY (production__hectolitres_))",
911 "answer": "select production__hectolitres_ from table_29012710_1 where province = \"new brunswick\""
912 },
913 {
914 "question": "Name the ebit for eps being 1.78",
915 "context": "create table table_20614109_1 (earnings_before_interest_and_taxes__\u20acm_ varchar, earnings_per_share__\u20ac_ varchar, PRIMARY KEY (earnings_before_interest_and_taxes__\u20acm_))",
916 "answer": "select earnings_before_interest_and_taxes__\u20acm_ from table_20614109_1 where earnings_per_share__\u20ac_ = \"1.78\""
917 },
918 {
919 "question": "Name the miles for jeff gordon",
920 "context": "create table table_2144863_1 (miles__km_ varchar, driver varchar, PRIMARY KEY (miles__km_))",
921 "answer": "select miles__km_ from table_2144863_1 where driver = \"jeff gordon\""
922 },
923 {
924 "question": "What is the nickname of staff with first name as Janessa and last name as Sawayn?",
925 "context": "create table staff (nickname varchar, first_name varchar, last_name varchar, PRIMARY KEY (nickname))",
926 "answer": "select nickname from staff where first_name = \"janessa\" and last_name = \"sawayn\""
927 },
928 {
929 "question": "What was the winning time in the year when the odds of the winner were 2.94?",
930 "context": "create table table_21676617_1 (winning_time__km_rate_ varchar, odds_of_winner varchar, PRIMARY KEY (winning_time__km_rate_))",
931 "answer": "select winning_time__km_rate_ from table_21676617_1 where odds_of_winner = \"2.94\""
932 },
933 {
934 "question": "Name the television service when primafila hot club",
935 "context": "create table table_15887683_6 (television_service varchar, content varchar, PRIMARY KEY (television_service))",
936 "answer": "select television_service from table_15887683_6 where content = \"primafila hot club\""
937 },
938 {
939 "question": "When 22' 37.06 100.090mph is the time for Monday August 24th how many times are there for Friday August 28th?",
940 "context": "create table table_23465864_3 (fri_28_aug varchar, mon_24_aug varchar, PRIMARY KEY (fri_28_aug))",
941 "answer": "select count(fri_28_aug) from table_23465864_3 where mon_24_aug = \"22' 37.06 100.090mph\""
942 },
943 {
944 "question": "Show all book categories and the number of books in each category.",
945 "context": "create table book_club (category varchar, PRIMARY KEY (category))",
946 "answer": "select category, count(*) from book_club group by category"
947 },
948 {
949 "question": "List the phone numbers of all employees.",
950 "context": "create table employee (phone varchar, PRIMARY KEY (phone))",
951 "answer": "select phone from employee"
952 },
953 {
954 "question": "Show all donor names.",
955 "context": "create table endowment (donator_name varchar, PRIMARY KEY (donator_name))",
956 "answer": "select distinct donator_name from endowment"
957 },
958 {
959 "question": "What was the opearint profit (s$m) associated with an expenditure (s$m) of 12,127.8?",
960 "context": "create table table_161591_2 (operating_profit__s$m_ varchar, expenditure__s$m_ varchar, PRIMARY KEY (operating_profit__s$m_))",
961 "answer": "select operating_profit__s$m_ from table_161591_2 where expenditure__s$m_ = \"12,127.8\""
962 },
963 {
964 "question": "What premieres had a finale on May 25, 2004?",
965 "context": "create table table_175980_2 (premiere varchar, finale varchar, PRIMARY KEY (premiere))",
966 "answer": "select premiere from table_175980_2 where finale = \"may 25, 2004\""
967 },
968 {
969 "question": "Find the names of the items that did not receive any review.",
970 "context": "create table item (title varchar, i_id varchar, PRIMARY KEY (title)); create table review (title varchar, i_id varchar, PRIMARY KEY (title))",
971 "answer": "select title from item where not i_id in (select i_id from review)"
972 },
973 {
974 "question": "who is the writer of the episode with prod.code 30-17",
975 "context": "create table table_13403120_1 (writer_s_ varchar, prodcode varchar, PRIMARY KEY (writer_s_))",
976 "answer": "select writer_s_ from table_13403120_1 where prodcode = \"30-17\""
977 },
978 {
979 "question": "Who wrote the episode that 2.93 million viewers?",
980 "context": "create table table_28019988_2 (written_by varchar, us_viewers__million_ varchar, PRIMARY KEY (written_by))",
981 "answer": "select written_by from table_28019988_2 where us_viewers__million_ = \"2.93\""
982 },
983 {
984 "question": "If the district name is the Academy of Flint, what is the authorizing agency?",
985 "context": "create table table_22665117_1 (authorizing_agency varchar, district_name varchar, PRIMARY KEY (authorizing_agency))",
986 "answer": "select authorizing_agency from table_22665117_1 where district_name = \"academy of flint\""
987 },
988 {
989 "question": "Find the unit of measurement and product category code of product named \"chervil\".",
990 "context": "create table ref_product_categories (unit_of_measure varchar, product_category_code varchar, PRIMARY KEY (unit_of_measure)); create table products (product_category_code varchar, product_name varchar, PRIMARY KEY (product_category_code))",
991 "answer": "select t2.unit_of_measure, t2.product_category_code from products as t1 join ref_product_categories as t2 on t1.product_category_code = t2.product_category_code where t1.product_name = \"chervil\""
992 },
993 {
994 "question": "Name the class 1-200 for university of hertfordshire for university of warwick",
995 "context": "create table table_1936678_1 (class_1 varchar, best_uk_team varchar, class_1a varchar, PRIMARY KEY (class_1))",
996 "answer": "select class_1 - 200 from table_1936678_1 where best_uk_team = \"university of hertfordshire\" and class_1a = \"university of warwick\""
997 },
998 {
999 "question": "If there are 11 lifts, what is the base elevation?",
1000 "context": "create table table_25762852_1 (base_elevation__feet_ integer, lifts varchar, PRIMARY KEY (base_elevation__feet_))",
1001 "answer": "select max(base_elevation__feet_) from table_25762852_1 where lifts = 11"
1002 },
1003 {
1004 "question": "Which civil parish is for the townland clooncugger?",
1005 "context": "create table table_30121096_1 (civil_parish varchar, townland varchar, PRIMARY KEY (civil_parish))",
1006 "answer": "select civil_parish from table_30121096_1 where townland = \"clooncugger\""
1007 },
1008 {
1009 "question": "What is the decor of room Recluse and defiance?",
1010 "context": "create table rooms (decor varchar, roomname varchar, PRIMARY KEY (decor))",
1011 "answer": "select decor from rooms where roomname = \"recluse and defiance\""
1012 },
1013 {
1014 "question": "When did the episode featuring a master using Brazilian jiu-jitsu air?",
1015 "context": "create table table_14937957_1 (original_airdate varchar, martial_art_style varchar, PRIMARY KEY (original_airdate))",
1016 "answer": "select original_airdate from table_14937957_1 where martial_art_style = \"brazilian jiu-jitsu\""
1017 },
1018 {
1019 "question": "Name the country for hannes arch",
1020 "context": "create table table_20036882_2 (country varchar, winning_pilot varchar, PRIMARY KEY (country))",
1021 "answer": "select country from table_20036882_2 where winning_pilot = \"hannes arch\""
1022 },
1023 {
1024 "question": "Who was the wenning witcher when ezequiel astacio was the losing pitcher?",
1025 "context": "create table table_13710464_1 (winning_pitcher varchar, losing_pitcher varchar, PRIMARY KEY (winning_pitcher))",
1026 "answer": "select winning_pitcher from table_13710464_1 where losing_pitcher = \"ezequiel astacio\""
1027 },
1028 {
1029 "question": "What was the doctor when the author was Gary Hopkins category:articles with hcards?",
1030 "context": "create table table_1620397_5 (doctor varchar, author varchar, PRIMARY KEY (doctor))",
1031 "answer": "select doctor from table_1620397_5 where author = \"gary hopkins category:articles with hcards\""
1032 },
1033 {
1034 "question": "Who is the together we can do more when democratic coalition is ren\u00e9 alinco ( ppd )?",
1035 "context": "create table table_2651755_1 (together_we_can_do_more varchar, democratic_coalition varchar, PRIMARY KEY (together_we_can_do_more))",
1036 "answer": "select together_we_can_do_more from table_2651755_1 where democratic_coalition = \"ren\u00e9 alinco ( ppd )\""
1037 },
1038 {
1039 "question": "Who had the high assist in the game where the record is 13-11?",
1040 "context": "create table table_18813011_6 (high_assists varchar, record varchar, PRIMARY KEY (high_assists))",
1041 "answer": "select high_assists from table_18813011_6 where record = \"13-11\""
1042 },
1043 {
1044 "question": "Who directed the film with the title three summer days?",
1045 "context": "create table table_22265716_1 (director varchar, film_title_used_in_nomination varchar, PRIMARY KEY (director))",
1046 "answer": "select director from table_22265716_1 where film_title_used_in_nomination = \"three summer days\""
1047 },
1048 {
1049 "question": "What is the location of the Moorabbin Oval stadium?",
1050 "context": "create table table_28885977_1 (location varchar, stadium varchar, PRIMARY KEY (location))",
1051 "answer": "select location from table_28885977_1 where stadium = \"moorabbin oval\""
1052 },
1053 {
1054 "question": "what is th copa libertadores 1997 is qf?",
1055 "context": "create table table_14310205_1 (copa_libertadores_1997 varchar, supercopa_1996 varchar, PRIMARY KEY (copa_libertadores_1997))",
1056 "answer": "select copa_libertadores_1997 from table_14310205_1 where supercopa_1996 = \"qf\""
1057 },
1058 {
1059 "question": "what is the fuel propulsion where the fleet series (quantity) is 310-329 (20)?",
1060 "context": "create table table_10007452_3 (fuel_propulsion varchar, fleet_series__quantity_ varchar, PRIMARY KEY (fuel_propulsion))",
1061 "answer": "select fuel_propulsion from table_10007452_3 where fleet_series__quantity_ = \"310-329 (20)\""
1062 },
1063 {
1064 "question": "What is the marketing region code that has the most drama workshop groups?",
1065 "context": "create table drama_workshop_groups (marketing_region_code varchar, PRIMARY KEY (marketing_region_code))",
1066 "answer": "select marketing_region_code from drama_workshop_groups group by marketing_region_code order by count(*) desc limit 1"
1067 },
1068 {
1069 "question": "How many distinct locations have the things with service detail 'Unsatisfied' been located in?",
1070 "context": "create table timed_locations_of_things (location_code varchar, thing_id varchar, PRIMARY KEY (location_code)); create table things (thing_id varchar, service_details varchar, PRIMARY KEY (thing_id))",
1071 "answer": "select count(distinct t2.location_code) from things as t1 join timed_locations_of_things as t2 on t1.thing_id = t2.thing_id where t1.service_details = 'unsatisfied'"
1072 },
1073 {
1074 "question": "For each phone, show its names and total number of stocks.",
1075 "context": "create table phone_market (num_of_stock integer, phone_id varchar, PRIMARY KEY (num_of_stock)); create table phone (name varchar, phone_id varchar, PRIMARY KEY (name))",
1076 "answer": "select t2.name, sum(t1.num_of_stock) from phone_market as t1 join phone as t2 on t1.phone_id = t2.phone_id group by t2.name"
1077 },
1078 {
1079 "question": "Find the subject ID, name of subject and the corresponding number of courses for each subject, and sort by the course count in ascending order.",
1080 "context": "create table courses (subject_id varchar, PRIMARY KEY (subject_id)); create table subjects (subject_name varchar, subject_id varchar, PRIMARY KEY (subject_name))",
1081 "answer": "select t1.subject_id, t2.subject_name, count(*) from courses as t1 join subjects as t2 on t1.subject_id = t2.subject_id group by t1.subject_id order by count(*)"
1082 },
1083 {
1084 "question": "When \u0440\u0430\u0442\u043a\u043e\u0432\u043e is cyrillic name other names and village is the type and orthodox Christianity is the dominant religion of 2002 what is the settlement?",
1085 "context": "create table table_2562572_25 (settlement varchar, cyrillic_name_other_names varchar, dominant_religion__2002_ varchar, type varchar, PRIMARY KEY (settlement))",
1086 "answer": "select settlement from table_2562572_25 where dominant_religion__2002_ = \"orthodox christianity\" and type = \"village\" and cyrillic_name_other_names = \"\u0440\u0430\u0442\u043a\u043e\u0432\u043e\""
1087 },
1088 {
1089 "question": "What are all of the order # where authentic artist is maroon 5",
1090 "context": "create table table_26250227_1 (order__number varchar, original_artist varchar, PRIMARY KEY (order__number))",
1091 "answer": "select order__number from table_26250227_1 where original_artist = \"maroon 5\""
1092 },
1093 {
1094 "question": "How many problems are there for product voluptatem?",
1095 "context": "create table problems (product_id varchar, PRIMARY KEY (product_id)); create table product (product_id varchar, product_name varchar, PRIMARY KEY (product_id))",
1096 "answer": "select count(*) from product as t1 join problems as t2 on t1.product_id = t2.product_id where t1.product_name = \"voluptatem\""
1097 },
1098 {
1099 "question": "Who was the Best Male Lyricist if Neshia Nee won the Best Male Record?",
1100 "context": "create table table_22546460_4 (best_male_lyricist varchar, best_male_record varchar, PRIMARY KEY (best_male_lyricist))",
1101 "answer": "select best_male_lyricist from table_22546460_4 where best_male_record = \"neshia nee\""
1102 },
1103 {
1104 "question": "What is listed in built for when the original number is 24d?",
1105 "context": "create table table_29071587_1 (built_for varchar, original_no varchar, PRIMARY KEY (built_for))",
1106 "answer": "select built_for from table_29071587_1 where original_no = \"24d\""
1107 },
1108 {
1109 "question": "What is the maximum elevation in netherlands?",
1110 "context": "create table table_24285393_1 (maximum_elevation varchar, country_or_region varchar, PRIMARY KEY (maximum_elevation))",
1111 "answer": "select maximum_elevation from table_24285393_1 where country_or_region = \"netherlands\""
1112 },
1113 {
1114 "question": "What is the nationality of the player from Vancouver Canucks?",
1115 "context": "create table table_1013129_3 (nationality varchar, nhl_team varchar, PRIMARY KEY (nationality))",
1116 "answer": "select nationality from table_1013129_3 where nhl_team = \"vancouver canucks\""
1117 },
1118 {
1119 "question": "When did the term begin that ended January 3, 1995?",
1120 "context": "create table table_224672_2 (term_began varchar, term_ended varchar, PRIMARY KEY (term_began))",
1121 "answer": "select term_began from table_224672_2 where term_ended = \"january 3, 1995\""
1122 },
1123 {
1124 "question": "Return the minister who left office at the latest time.",
1125 "context": "create table party (minister varchar, left_office varchar, PRIMARY KEY (minister))",
1126 "answer": "select minister from party order by left_office desc limit 1"
1127 },
1128 {
1129 "question": "List the names of products that are not in any event.",
1130 "context": "create table products (product_name varchar, product_id varchar, PRIMARY KEY (product_name)); create table products_in_events (product_name varchar, product_id varchar, PRIMARY KEY (product_name))",
1131 "answer": "select product_name from products where not product_id in (select product_id from products_in_events)"
1132 },
1133 {
1134 "question": "What is the total number of second place finishes when the city & nation was Chicago, USA?",
1135 "context": "create table table_2146364_2 (second_place varchar, city_ varchar, _nation varchar, PRIMARY KEY (second_place))",
1136 "answer": "select count(second_place) from table_2146364_2 where city_ & _nation = \"chicago, usa\""
1137 },
1138 {
1139 "question": "Name the ppv for sky famiglia and dar 16:9 for mtv dance",
1140 "context": "create table table_15887683_10 (ppv varchar, television_service varchar, package_option varchar, dar varchar, PRIMARY KEY (ppv))",
1141 "answer": "select ppv from table_15887683_10 where package_option = \"sky famiglia\" and dar = \"16:9\" and television_service = \"mtv dance\""
1142 },
1143 {
1144 "question": "List all public schools and their locations.",
1145 "context": "create table university (school varchar, location varchar, affiliation varchar, PRIMARY KEY (school))",
1146 "answer": "select school, location from university where affiliation = 'public'"
1147 },
1148 {
1149 "question": "What is the original air date when the u.s. viewers in millions was 5.39?",
1150 "context": "create table table_27720737_1 (original_air_date varchar, us_viewers__million_ varchar, PRIMARY KEY (original_air_date))",
1151 "answer": "select original_air_date from table_27720737_1 where us_viewers__million_ = \"5.39\""
1152 },
1153 {
1154 "question": "Name the writers for swedish sailor",
1155 "context": "create table table_19852975_3 (writer_s_ varchar, arties_disguises varchar, PRIMARY KEY (writer_s_))",
1156 "answer": "select writer_s_ from table_19852975_3 where arties_disguises = \"swedish sailor\""
1157 },
1158 {
1159 "question": "Who has the fastest lap where Beno\u00eet Tr\u00e9luyer got the pole position?",
1160 "context": "create table table_22379931_2 (fastest_lap varchar, pole_position varchar, PRIMARY KEY (fastest_lap))",
1161 "answer": "select fastest_lap from table_22379931_2 where pole_position = \"beno\u00eet tr\u00e9luyer\""
1162 },
1163 {
1164 "question": "Name the english gloss for ha\u014b\u021f\u2019\u00e1\u014bna",
1165 "context": "create table table_1499774_5 (english_gloss varchar, santee_sisseton varchar, PRIMARY KEY (english_gloss))",
1166 "answer": "select english_gloss from table_1499774_5 where santee_sisseton = \"ha\u014b\u021f\u2019\u00e1\u014bna\""
1167 },
1168 {
1169 "question": "How many times did the team achieve an overrall record of mu, 21-19?",
1170 "context": "create table table_16201038_4 (last_5_meetings varchar, overall_record varchar, PRIMARY KEY (last_5_meetings))",
1171 "answer": "select count(last_5_meetings) from table_16201038_4 where overall_record = \"mu, 21-19\""
1172 },
1173 {
1174 "question": "What is them two (the two) when you and i is ng\u0153balngu?",
1175 "context": "create table table_1015914_24 (them_two__the_two_ varchar, you_and_i varchar, PRIMARY KEY (them_two__the_two_))",
1176 "answer": "select them_two__the_two_ from table_1015914_24 where you_and_i = \"ng\u0153balngu\""
1177 },
1178 {
1179 "question": "When the change (2010 to 2011) is +1.0% what is the change (2011 to 2012)?",
1180 "context": "create table table_14752049_6 (change__2011_to_2012_ varchar, change__2010_to_2011_ varchar, PRIMARY KEY (change__2011_to_2012_))",
1181 "answer": "select change__2011_to_2012_ from table_14752049_6 where change__2010_to_2011_ = \"+1.0%\""
1182 },
1183 {
1184 "question": "What is the most popular full name of the actors?",
1185 "context": "create table actor (first_name varchar, last_name varchar, PRIMARY KEY (first_name))",
1186 "answer": "select first_name, last_name from actor group by first_name, last_name order by count(*) desc limit 1"
1187 },
1188 {
1189 "question": "What is the Sipe Sipe Municipality minimum if the language is Quechua?",
1190 "context": "create table table_2509113_2 (sipe_sipe_municipality integer, language varchar, PRIMARY KEY (sipe_sipe_municipality))",
1191 "answer": "select min(sipe_sipe_municipality) from table_2509113_2 where language = \"quechua\""
1192 },
1193 {
1194 "question": "What are the results of the elections in which Ted Strickland is seeking re-election?",
1195 "context": "create table table_1805191_36 (results varchar, incumbent varchar, PRIMARY KEY (results))",
1196 "answer": "select results from table_1805191_36 where incumbent = \"ted strickland\""
1197 },
1198 {
1199 "question": "How many production stage managers worked with Gabriel di Chiara as the Male Rep?",
1200 "context": "create table table_22410780_1 (production_stagemanager varchar, male_rep varchar, PRIMARY KEY (production_stagemanager))",