question_id
int64
1
80.3k
completion
stringlengths
1
5.32k
201
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23"
202
SELECT "Pole Position", "Fastest Lap", "Winning Driver", "Winning Constructor", "Report" FROM "Table" WHERE "Round" = "1.0" AND "Pole Position" = "Ayrton Senna" AND "Fastest Lap" = "Michael Schumacher";
203
SELECT "Date" FROM "Table" WHERE "Pole Position" = "Alain Prost" AND "Winning Driver" = "Damon Hill"
204
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
205
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
206
SELECT SUM("Attendance") FROM "Table" WHERE "Week" = "6"
207
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
208
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
209
SELECT "Pole Position" FROM "Table" WHERE "Race" = "Argentine Grand Prix" AND "Date" = "13 January"
210
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23"
211
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23"
212
SELECT "Constructor" FROM "Table" WHERE "Race" = "Swedish Grand Prix"
213
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23"
214
SELECT "Race Name" FROM "Table" WHERE "Circuit" = "II Cape South Easter Trophy"
215
SELECT "Winning driver" FROM "Table" WHERE "Constructor" = "Brabham - Climax"
216
SELECT "Report" FROM "Table" WHERE "Winning driver" = "Mike Spence";
217
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
218
SELECT COUNT(*) FROM "Table" WHERE "Winning driver" = "I Rostock Osthafenkurs"
219
SELECT "Date" FROM "Table" WHERE "Race Name" = "Halle-Saale-Schleife circuit"
220
SELECT SUM("Population") FROM "Table" WHERE "State" = "California";
221
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
222
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
223
SELECT "Constructor" FROM "Table" WHERE "Race Name" = "RedEx Trophy"
224
SELECT COUNT(*) FROM "Table" WHERE "Constructor" = "Ferrari"
225
SELECT "TV" FROM "Table" WHERE "Game site" = "Tampa Stadium" AND "Opponent" = "ABC";
226
SELECT COUNT(*) FROM "Table" WHERE "Date" = "November 23, 1980"
227
SELECT SUM("Kickoff [a ]") FROM "Table" WHERE "Week" = "Kickoff"
228
SELECT SUM("Attendance") FROM "Table" WHERE "Result" = "77,098";
229
SELECT "Attendance" FROM "Table" WHERE "Record" = "61,350"
230
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23" AND "Result" = "L 24-10"
231
SELECT "Date" FROM "Table" WHERE "Race Name" = "Silverstone circuit"
232
SELECT "Date" FROM "Table" WHERE "Constructor" = "Fangio"
233
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Apple" AND "Model" = "iPhone 14"
234
SELECT "Winning driver" FROM "Table" WHERE "Constructor" = "Fangio"
235
SELECT SUM("Viewers (in millions)") FROM "Table" WHERE "Season" = "14.71"
236
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
237
SELECT SUM("Power Capacity (GW)") FROM "Table" WHERE "Number of Generators" = "781";
238
SELECT SUM("Capacity factor") FROM "Table" WHERE "Power Source" = "Hydro" AND "Annual Energy" = "120.2";
239
SELECT SUM("Power Capacity (GW)") FROM "Table" WHERE "Capacity factor" = "0.463"
240
SELECT COUNT(*) FROM "Table" WHERE "Power Capacity (GW)" = "78.7"
241
SELECT SUM("Capacity factor") FROM "Table" WHERE "Annual Energy (billion kWh)" = "4048"
242
SELECT "Model" FROM "Table" WHERE "Engine make/Capacity" = "16000" AND "Torque Nm@rpm" = "600 @ 1700";
243
SELECT "GVM (kg) Technical Capacity" FROM "Table" WHERE "Engine make/Capacity" = "15.180E"
244
SELECT "Torque Nm@rpm" FROM "Table" WHERE "Engine make/Capacity" = "MWM 6.10 TCA-EURO III (Turbo Intercooler)" AND "GVM (kg) Technical Capacity" = "23000"
245
SELECT "Power" FROM "Table" WHERE "Model" = "13.180"
246
SELECT "GCM (kg) Technical Capacity" FROM "Table" WHERE "Transmission Make/Capacity" = "Eaton FS 5306-A Manual Synchromesh 6 Speed"
247
SELECT "Model" FROM "Table" WHERE "Engine make/Capacity" = "Eaton FS-6306 A Manual Synchromesh 6 Speed"
248
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23" AND "Type" = "Drawing Tablet"
249
SELECT "Comparisons" FROM "Table" WHERE "Hub Base Class" = "USB RE-Enumeration Required"
250
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23" AND "Model" = "Wireless Combo keyboard and mouse"
251
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23"
252
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23" AND "Model" = "Wireless Combo keyboard and mouse"
253
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
254
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
255
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
256
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23" AND "Year" = "2022" AND "Color" = "White" AND "Author" = "Maya Chen" AND "Cuisine" = "Italian" AND "Rating" = "4.2" AND "City" = "Boston" AND "Price Range" = "$$$" AND "Job Title" = "Software Engineer" AND "No." = "35" AND "School/Club Tea...
257
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23"
258
SELECT "Date" FROM "Table" WHERE "Location" = "Mexico" AND "Purse( $ )" > 0
259
SELECT "University Name" FROM "Table" WHERE "Acronym" = "USF";
260
SELECT "Acronym" FROM "Table" WHERE "University Name" = "Beirut Arab University"
261
SELECT "Acronym" FROM "Table" WHERE "Website" = "ul.edu.lb"
262
SELECT "Registration notes" FROM "Table" WHERE "University Name" = "usek.edu.lb"
263
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
264
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
265
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
266
SELECT SUM("Purse( $ )") FROM "Table" WHERE "Location" = "The Transamerica";
267
SELECT SUM("Purse( $ )") FROM "Table" WHERE "Winner" = "George Archer (2)"
268
SELECT "Date" FROM "Table" WHERE "Location" = "Washington" AND "Purse( $ )" > 0 AND "Winner" = "George Archer (2)" AND "Score" > 0
269
SELECT SUM("Purse( $ )") FROM "Table" WHERE "Location" = "Texas" AND "Purse( $ )" > "330105.1624276874";
270
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23"
271
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
272
SELECT "Title" FROM "Table" WHERE "Season no." = "2"
273
SELECT SUM("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
274
SELECT SUM("Season no.") FROM "Table" WHERE "Series no." = "47"
275
SELECT "Production code" FROM "Table" WHERE "Original air date" = "76.0"
276
SELECT MAX("Season #") FROM "Table" WHERE "Season #" = "3";
277
SELECT SUM("Purse( $ )") FROM "Table" WHERE "Location" = "New York";
278
SELECT MAX("Price") FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
279
SELECT SUM("Score") FROM "Table" WHERE "Location" = "Oregon";
280
SELECT "car plates (since 1937)", "Voivodeship Separate city", "Area in 1000km² (1930)", "Population in 1000 (1931)" FROM "Table" WHERE "Capital" = "Lubelskie" AND "Area in 1000km² (1930)" < 1000
281
SELECT SUM("Population") FROM "Table" WHERE "State" = "California";
282
SELECT "car plates (since 1937)" FROM "Table" WHERE "Capital" = "Wilno"
283
SELECT SUM("Population") FROM "Table" WHERE "State" = "California" AND "Area in 1000km² (1930)" BETWEEN 30 AND 34
284
SELECT SUM("Points") FROM "Table" WHERE "Lost" = "26";
285
SELECT "Stage (Winner)", "General classification", "Mountains classification", "Points classification", "Combination classification", "Team Classification" FROM "Table" WHERE "Winner" = "Bradley Wiggins"
286
SELECT SUM("Stage (Winner)") FROM "Table" WHERE "General classification" = "Alexander Vinokourov";
287
SELECT AVG("Average") FROM "Table" WHERE "Country" = "Spain"
288
SELECT "Delegate" FROM "Table" WHERE "Swimsuit" = "Evening Gown" AND "Average" = "7.831"
289
SELECT COUNT(*) FROM "Table" WHERE "Delegate" = "Israel"
290
SELECT "Swimsuit" FROM "Table" WHERE "Delegate" = "South Africa"
291
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
292
SELECT COUNT(*) FROM "Table" WHERE "Hometown" = "Pennsauken, NJ";
293
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
294
SELECT "Hometown" FROM "Table" WHERE "Position" = "Pitcher"
295
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
296
SELECT "Hometown" FROM "Table" WHERE "Player" = "Jay Bruce";
297
SELECT "Price" FROM "Table" WHERE "Brand" = "Samsung" AND "Model" = "Galaxy S23";
298
SELECT "Hometown" FROM "Table" WHERE "Position" = "Catcher";
299
SELECT "Position" FROM "Table" WHERE "School" = "West Brook Senior High School"
300
SELECT "Hometown" FROM "Table" WHERE "School" = "West Brook Senior High School";