aherntech/sparc
Dataset Card for SParC SParC is a context-dependant multi-turn version of the Spider task 1.0. This dataset provides a chat-bot oriented test set for text-to-sql problems. Additional details may be obtained in the paper: https://arxiv.org/abs/1906.02285 Paper Abstract We present SParC, a dataset for cross-domainSemanticParsing inContext that consists of 4,298 coherent question sequences (12k+ individual questions annotated with SQL queries). It is obtained from… See the full description on the dataset page: https://huggingface.co/datasets/aherntech/sparc.
1128
1[2 {3 "db_id": "flight_2",4 "final_query": "SELECT Country FROM AIRLINES WHERE Airline = \"JetBlue Airways\"",5 "final_utterance": "What country is Jetblue Airways affiliated with?",6 "interaction_utterance": [7 "What are all the airlines?",8 "Of these, which is Jetblue Airways?",9 "What is the country corresponding it?"10 ],11 "interaction_query": [12 "SELECT * FROM AIRLINES",13 "SELECT * FROM AIRLINES WHERE Airline = \"JetBlue Airways\"",14 "SELECT Country FROM AIRLINES WHERE Airline = \"JetBlue Airways\""15 ]16 },17 {18 "db_id": "flight_2",19 "final_query": "SELECT Abbreviation FROM AIRLINES WHERE Airline = \"JetBlue Airways\"",20 "final_utterance": "Which abbreviation corresponds to Jetblue Airways?",21 "interaction_utterance": [22 "What are all the abbreviations?",23 "What is the abbreviation for Jetblue Airways?"24 ],25 "interaction_query": [26 "SELECT Abbreviation FROM AIRLINES",27 "SELECT Abbreviation FROM AIRLINES WHERE Airline = \"JetBlue Airways\""28 ]29 },30 {31 "db_id": "flight_2",32 "final_query": "SELECT Airline , Abbreviation FROM AIRLINES WHERE Country = \"USA\"",33 "final_utterance": "What are the airline names and abbreviations for airlines in the USA?",34 "interaction_utterance": [35 "List all airline names and their abbreviations.",36 "Of these, list only those in the USA."37 ],38 "interaction_query": [39 "SELECT Airline , Abbreviation FROM AIRLINES",40 "SELECT Airline , Abbreviation FROM AIRLINES WHERE Country = \"USA\""41 ]42 },43 {44 "db_id": "flight_2",45 "final_query": "SELECT AirportCode , AirportName FROM AIRPORTS WHERE city = \"Anthony\"",46 "final_utterance": "Give the airport code and airport name corresonding to the city Anthony.",47 "interaction_utterance": [48 "Find all information about the airport in the city Anthony.",49 "What is the airport code and airport name?"50 ],51 "interaction_query": [52 "SELECT * FROM AIRPORTS WHERE city = \"Anthony\"",53 "SELECT AirportCode , AirportName FROM AIRPORTS WHERE city = \"Anthony\""54 ]55 },56 {57 "db_id": "flight_2",58 "final_query": "SELECT count(*) FROM AIRLINES",59 "final_utterance": "What is the total number of airlines?",60 "interaction_utterance": [61 "What are all the airlines?",62 "How many are there?"63 ],64 "interaction_query": [65 "SELECT * FROM AIRLINES",66 "SELECT count(*) FROM AIRLINES"67 ]68 },69 {70 "db_id": "flight_2",71 "final_query": "SELECT count(*) FROM AIRPORTS",72 "final_utterance": "Return the number of airports.",73 "interaction_utterance": [74 "What are all the airports?",75 "How many are there?"76 ],77 "interaction_query": [78 "SELECT * FROM AIRPORTS",79 "SELECT count(*) FROM AIRPORTS"80 ]81 },82 {83 "db_id": "flight_2",84 "final_query": "SELECT count(*) FROM FLIGHTS",85 "final_utterance": "Return the number of flights.",86 "interaction_utterance": [87 "What are all the flights?",88 "How many are there?"89 ],90 "interaction_query": [91 "SELECT * FROM FLIGHTS",92 "SELECT count(*) FROM FLIGHTS"93 ]94 },95 {96 "db_id": "flight_2",97 "final_query": "SELECT Airline FROM AIRLINES WHERE Abbreviation = \"UAL\"",98 "final_utterance": "Give the airline with abbreviation 'UAL'.",99 "interaction_utterance": [100 "What are all the airline names?",101 "Of this, which has the abbreviation 'UAL'?"102 ],103 "interaction_query": [104 "SELECT Airline FROM AIRLINES",105 "SELECT Airline FROM AIRLINES WHERE Abbreviation = \"UAL\""106 ]107 },108 {109 "db_id": "flight_2",110 "final_query": "SELECT count(*) FROM AIRLINES WHERE Country = \"USA\"",111 "final_utterance": "Return the number of airlines in the USA.",112 "interaction_utterance": [113 "What are the names of the airlines in the USA?",114 "How many are there?"115 ],116 "interaction_query": [117 "SELECT airline FROM AIRLINES WHERE Country = \"USA\"",118 "SELECT count(*) FROM AIRLINES WHERE Country = \"USA\""119 ]120 },121 {122 "db_id": "flight_2",123 "final_query": "SELECT City , Country FROM AIRPORTS WHERE AirportName = \"Alton\"",124 "final_utterance": "Give the city and country for the Alton airport.",125 "interaction_utterance": [126 "What are the city and country for all airports?",127 "Of these, what are the city and country for Alton airport?"128 ],129 "interaction_query": [130 "SELECT City , Country FROM AIRPORTS",131 "SELECT City , Country FROM AIRPORTS WHERE AirportName = \"Alton\""132 ]133 },134 {135 "db_id": "flight_2",136 "final_query": "SELECT AirportName FROM AIRPORTS WHERE AirportCode = \"AKO\"",137 "final_utterance": "Return the name of the airport with code 'AKO'.",138 "interaction_utterance": [139 "What are all the airport names?",140 "Of these, which has code 'AKO'?"141 ],142 "interaction_query": [143 "SELECT AirportName FROM AIRPORTS",144 "SELECT AirportName FROM AIRPORTS WHERE AirportCode = \"AKO\""145 ]146 },147 {148 "db_id": "flight_2",149 "final_query": "SELECT AirportName FROM AIRPORTS WHERE City = \"Aberdeen\"",150 "final_utterance": "What are the names of airports in Aberdeen?",151 "interaction_utterance": [152 "What are all the airport names?",153 "Which is in Aberdeen?"154 ],155 "interaction_query": [156 "SELECT AirportName FROM AIRPORTS",157 "SELECT AirportName FROM AIRPORTS WHERE City = \"Aberdeen\""158 ]159 },160 {161 "db_id": "flight_2",162 "final_query": "SELECT count(*) FROM FLIGHTS WHERE SourceAirport = \"APG\"",163 "final_utterance": "Count the number of flights departing from 'APG'.",164 "interaction_utterance": [165 "What are all the flights departing from 'APG'?",166 "How many are there?"167 ],168 "interaction_query": [169 "SELECT * FROM FLIGHTS WHERE SourceAirport = \"APG\"",170 "SELECT count(*) FROM FLIGHTS WHERE SourceAirport = \"APG\""171 ]172 },173 {174 "db_id": "flight_2",175 "final_query": "SELECT count(*) FROM FLIGHTS WHERE DestAirport = \"ATO\"",176 "final_utterance": "Count the number of flights into ATO.",177 "interaction_utterance": [178 "What flights land in ATO?",179 "How many are there?"180 ],181 "interaction_query": [182 "SELECT * FROM FLIGHTS WHERE DestAirport = \"ATO\"",183 "SELECT count(*) FROM FLIGHTS WHERE DestAirport = \"ATO\""184 ]185 },186 {187 "db_id": "flight_2",188 "final_query": "SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\"",189 "final_utterance": "Return the number of flights departing from Aberdeen.",190 "interaction_utterance": [191 "What are all the flights derparting from Aberdeen?",192 "How many are there?"193 ],194 "interaction_query": [195 "SELECT * FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\"",196 "SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\""197 ]198 },199 {200 "db_id": "flight_2",201 "final_query": "SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\"",202 "final_utterance": "Return the number of flights arriving in Aberdeen.",203 "interaction_utterance": [204 "What are all the flights arriving in Aberdeen.",205 "How many are there?"206 ],207 "interaction_query": [208 "SELECT * FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\"",209 "SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\""210 ]211 },212 {213 "db_id": "flight_2",214 "final_query": "SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode JOIN AIRPORTS AS T3 ON T1.SourceAirport = T3.AirportCode WHERE T2.City = \"Ashley\" AND T3.City = \"Aberdeen\"",215 "final_utterance": "How many flights fly from Aberdeen to Ashley?",216 "interaction_utterance": [217 "What are all the flights that leave from Aberdeen?",218 "Of those, which land in Ashley?",219 "How many are there?"220 ],221 "interaction_query": [222 "SELECT * FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\"",223 "SELECT * FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode JOIN AIRPORTS AS T3 ON T1.SourceAirport = T3.AirportCode WHERE T2.City = \"Ashley\" AND T3.City = \"Aberdeen\"",224 "SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode JOIN AIRPORTS AS T3 ON T1.SourceAirport = T3.AirportCode WHERE T2.City = \"Ashley\" AND T3.City = \"Aberdeen\""225 ]226 },227 {228 "db_id": "flight_2",229 "final_query": "SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T1.Airline = T2.uid WHERE T2.Airline = \"JetBlue Airways\"",230 "final_utterance": "Give the number of Jetblue Airways flights.",231 "interaction_utterance": [232 "What are all the flights on Jetblue Airways?",233 "How many are there?"234 ],235 "interaction_query": [236 "SELECT * FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T1.Airline = T2.uid WHERE T2.Airline = \"JetBlue Airways\"",237 "SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T1.Airline = T2.uid WHERE T2.Airline = \"JetBlue Airways\""238 ]239 },240 {241 "db_id": "flight_2",242 "final_query": "SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline = T1.uid WHERE T1.Airline = \"United Airlines\" AND T2.DestAirport = \"ASY\"",243 "final_utterance": "Count the number of United Airlines flights arriving in ASY Airport.",244 "interaction_utterance": [245 "What are the United Airlines flights?",246 "How many are there?",247 "How many land in ASY Airport?"248 ],249 "interaction_query": [250 "SELECT * FROM AIRLINES WHERE Airline = \"United Airlines\"",251 "SELECT count(*) FROM AIRLINES WHERE Airline = \"United Airlines\"",252 "SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline = T1.uid WHERE T1.Airline = \"United Airlines\" AND T2.DestAirport = \"ASY\""253 ]254 },255 {256 "db_id": "flight_2",257 "final_query": "SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline = T1.uid WHERE T1.Airline = \"United Airlines\" AND T2.SourceAirport = \"AHD\"",258 "final_utterance": "Return the number of United Airlines flights leaving from AHD Airport.",259 "interaction_utterance": [260 "What are the United Airlines flights?",261 "Which ones leave from AHD?",262 "How many are there?"263 ],264 "interaction_query": [265 "SELECT * FROM AIRLINES WHERE Airline = \"United Airlines\"",266 "SELECT * FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline = T1.uid WHERE T1.Airline = \"United Airlines\" AND T2.SourceAirport = \"AHD\"",267 "SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline = T1.uid WHERE T1.Airline = \"United Airlines\" AND T2.SourceAirport = \"AHD\""268 ]269 },270 {271 "db_id": "flight_2",272 "final_query": "SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode JOIN AIRLINES AS T3 ON T3.uid = T1.Airline WHERE T2.City = \"Aberdeen\" AND T3.Airline = \"United Airlines\"",273 "final_utterance": "Count the number of United Airlines flights that arrive in Aberdeen.",274 "interaction_utterance": [275 "Which United Airlines flights fly into Aberdeen?",276 "How many are there?"277 ],278 "interaction_query": [279 "SELECT * FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode JOIN AIRLINES AS T3 ON T3.uid = T1.Airline WHERE T2.City = \"Aberdeen\" AND T3.Airline = \"United Airlines\"",280 "SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode JOIN AIRLINES AS T3 ON T3.uid = T1.Airline WHERE T2.City = \"Aberdeen\" AND T3.Airline = \"United Airlines\""281 ]282 },283 {284 "db_id": "flight_2",285 "final_query": "SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1",286 "final_utterance": "Which city has the most frequent destination airport?",287 "interaction_utterance": [288 "Name all cities that have destination airports.",289 "Order them by number of arriving flights.",290 "Which one has the most?"291 ],292 "interaction_query": [293 "SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport",294 "SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport GROUP BY T1.City ORDER BY count(*) DESC",295 "SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1"296 ]297 },298 {299 "db_id": "flight_2",300 "final_query": "SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.SourceAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1",301 "final_utterance": "Which city is the most frequent source airport?",302 "interaction_utterance": [303 "Name all cities that have source airports.",304 "Order them by number of departing flights.",305 "Which one has the most?"306 ],307 "interaction_query": [308 "SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.SourceAirport",309 "SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.SourceAirport GROUP BY T1.City ORDER BY count(*) DESC",310 "SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.SourceAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1"311 ]312 },313 {314 "db_id": "flight_2",315 "final_query": "SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport OR T1.AirportCode = T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) DESC LIMIT 1",316 "final_utterance": "What is the airport code of the airport with the most flights?",317 "interaction_utterance": [318 "What are airport codes of any airport with a arriving flight?",319 "Also include codes of airports with departure flights.",320 "Which one has the highest number of flights?"321 ],322 "interaction_query": [323 "SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport",324 "SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport OR T1.AirportCode = T2.SourceAirport",325 "SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport OR T1.AirportCode = T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) DESC LIMIT 1"326 ]327 },328 {329 "db_id": "flight_2",330 "final_query": "SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport OR T1.AirportCode = T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) LIMIT 1",331 "final_utterance": "Give the code of the airport with the least flights.",332 "interaction_utterance": [333 "What are airport codes of any airport with a arriving flight?",334 "Also include codes of airports with departure flights.",335 "Which one has the least number of flights?"336 ],337 "interaction_query": [338 "SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport",339 "SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport OR T1.AirportCode = T2.SourceAirport",340 "SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport OR T1.AirportCode = T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) LIMIT 1"341 ]342 },343 {344 "db_id": "flight_2",345 "final_query": "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline ORDER BY count(*) DESC LIMIT 1",346 "final_utterance": "What airline serves the most flights?",347 "interaction_utterance": [348 "Count the number of flights by airline.",349 "Which airline has the most?"350 ],351 "interaction_query": [352 "SELECT count(*) , T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline",353 "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline ORDER BY count(*) DESC LIMIT 1"354 ]355 },356 {357 "db_id": "flight_2",358 "final_query": "SELECT T1.Abbreviation , T1.Country FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline ORDER BY count(*) LIMIT 1",359 "final_utterance": "What is the abbreviation of the airilne has the fewest flights and what country is it in?",360 "interaction_utterance": [361 "What are all the airline abbreviations and what countries are they in?",362 "Order them by the number of flights that they have.",363 "Which one has the fewest?"364 ],365 "interaction_query": [366 "SELECT Abbreviation , Country FROM AIRLINES",367 "SELECT T1.Abbreviation , T1.Country FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline ORDER BY count(*)",368 "SELECT T1.Abbreviation , T1.Country FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline ORDER BY count(*) LIMIT 1"369 ]370 },371 {372 "db_id": "flight_2",373 "final_query": "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"AHD\"",374 "final_utterance": "Which airlines have a flight with source airport AHD?",375 "interaction_utterance": [376 "Which flights leave from AHD?",377 "What are their airlines?"378 ],379 "interaction_query": [380 "SELECT * FROM FLIGHTS WHERE SourceAirport = \"AHD\"",381 "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"AHD\""382 ]383 },384 {385 "db_id": "flight_2",386 "final_query": "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.DestAirport = \"AHD\"",387 "final_utterance": "Which airlines have a flight with destination airport AHD?",388 "interaction_utterance": [389 "Which flights arrive in AHD?",390 "What are their airlines?"391 ],392 "interaction_query": [393 "SELECT * FROM FLIGHTS WHERE DestAirport = \"AHD\"",394 "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.DestAirport = \"AHD\""395 ]396 },397 {398 "db_id": "flight_2",399 "final_query": "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"APG\" INTERSECT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"CVO\"",400 "final_utterance": "Which airlines have departing flights from both APG and CVO airports?",401 "interaction_utterance": [402 "Which airlines have flights departing from APG?",403 "Of those, which also have flights from CVO?"404 ],405 "interaction_query": [406 "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"APG\"",407 "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"APG\" INTERSECT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"CVO\""408 ]409 },410 {411 "db_id": "flight_2",412 "final_query": "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"CVO\" EXCEPT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"APG\"",413 "final_utterance": "Which airlines have departures from CVO but not from APG airports?",414 "interaction_utterance": [415 "Which airlines have flights from CVO?",416 "Of these, which do not have flights from APG?"417 ],418 "interaction_query": [419 "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"CVO\"",420 "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"CVO\" EXCEPT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = \"APG\""421 ]422 },423 {424 "db_id": "flight_2",425 "final_query": "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline HAVING count(*) > 10",426 "final_utterance": "Which airlines have at least 10 flights?",427 "interaction_utterance": [428 "What are all the airlines?",429 "Which ones have more than 10 flights?"430 ],431 "interaction_query": [432 "SELECT DISTINCT Airline FROM AIRLINES",433 "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline HAVING count(*) > 10"434 ]435 },436 {437 "db_id": "flight_2",438 "final_query": "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline HAVING count(*) < 200",439 "final_utterance": "Which airlines have less than 200 flights?",440 "interaction_utterance": [441 "What are all the airlines?",442 "Which ones have less than 200 flights?"443 ],444 "interaction_query": [445 "SELECT DISTINCT Airline FROM AIRLINES",446 "SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline HAVING count(*) < 200"447 ]448 },449 {450 "db_id": "flight_2",451 "final_query": "SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T2.uid = T1.Airline WHERE T2.Airline = \"United Airlines\"",452 "final_utterance": "Which flight numbers correspond to United Airlines flights?",453 "interaction_utterance": [454 "What are all the flight numbers?",455 "Which belong to United Airlines?"456 ],457 "interaction_query": [458 "SELECT FlightNo FROM FLIGHTS",459 "SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T2.uid = T1.Airline WHERE T2.Airline = \"United Airlines\""460 ]461 },462 {463 "db_id": "flight_2",464 "final_query": "SELECT FlightNo FROM FLIGHTS WHERE SourceAirport = \"APG\"",465 "final_utterance": "Give the flight numbers of flights leaving from APG.",466 "interaction_utterance": [467 "What are all the flight numbers?",468 "Of these, which correspond to flights leaving from APG?"469 ],470 "interaction_query": [471 "SELECT FlightNo FROM FLIGHTS",472 "SELECT FlightNo FROM FLIGHTS WHERE SourceAirport = \"APG\""473 ]474 },475 {476 "db_id": "flight_2",477 "final_query": "SELECT FlightNo FROM FLIGHTS WHERE DestAirport = \"APG\"",478 "final_utterance": "Give the flight numbers of flights landing at APG.",479 "interaction_utterance": [480 "What are all the flight numbers?",481 "Also, which numbers are for flights that land in APG?"482 ],483 "interaction_query": [484 "SELECT FlightNo FROM FLIGHTS",485 "SELECT FlightNo FROM FLIGHTS WHERE DestAirport = \"APG\""486 ]487 },488 {489 "db_id": "flight_2",490 "final_query": "SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\"",491 "final_utterance": "Give the flight numbers of flights leaving from Aberdeen.",492 "interaction_utterance": [493 "What are all the flight numbers?",494 "Of these, which are departure flights?",495 "Which leave from Aberdeen?"496 ],497 "interaction_query": [498 "SELECT FlightNo FROM FLIGHTS",499 "SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode",500 "SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\""501 ]502 },503 {504 "db_id": "flight_2",505 "final_query": "SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\"",506 "final_utterance": "Give the flight numbers of flights arriving in Aberdeen.",507 "interaction_utterance": [508 "What are all the flight numbers?",509 "Of these, which are arrival flights?",510 "Which land in Aberdeen?"511 ],512 "interaction_query": [513 "SELECT FlightNo FROM FLIGHTS",514 "SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode",515 "SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.City = \"Aberdeen\""516 ]517 },518 {519 "db_id": "flight_2",520 "final_query": "SELECT count(*) FROM Flights AS T1 JOIN Airports AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.city = \"Aberdeen\" OR T2.city = \"Abilene\"",521 "final_utterance": "How many flights land in Aberdeen or Abilene?",522 "interaction_utterance": [523 "What flights land in Aberdeen?",524 "Also include flights that land in Abilene.",525 "How many are there?"526 ],527 "interaction_query": [528 "SELECT * FROM Flights AS T1 JOIN Airports AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.city = \"Aberdeen\"",529 "SELECT * FROM Flights AS T1 JOIN Airports AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.city = \"Aberdeen\" OR T2.city = \"Abilene\"",530 "SELECT count(*) FROM Flights AS T1 JOIN Airports AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.city = \"Aberdeen\" OR T2.city = \"Abilene\""531 ]532 },533 {534 "db_id": "flight_2",535 "final_query": "SELECT AirportName FROM Airports WHERE AirportCode NOT IN (SELECT SourceAirport FROM Flights UNION SELECT DestAirport FROM Flights)",536 "final_utterance": "Which airports do not have departing or arriving flights?",537 "interaction_utterance": [538 "What are the source airports?",539 "Also include the destination airports.",540 "Which airports are not included?"541 ],542 "interaction_query": [543 "SELECT SourceAirport FROM Flights",544 "SELECT SourceAirport FROM Flights UNION SELECT DestAirport FROM Flights",545 "SELECT AirportName FROM Airports WHERE AirportCode NOT IN (SELECT SourceAirport FROM Flights UNION SELECT DestAirport FROM Flights)"546 ]547 },548 {549 "db_id": "pets_1",550 "final_query": "SELECT count(*) FROM pets WHERE weight > 10",551 "final_utterance": "How many pets have a greater weight than 10?",552 "interaction_utterance": [553 "What information is there on pets?",554 "Which pets weigh more than 10?",555 "How many are there?"556 ],557 "interaction_query": [558 "SELECT * FROM pets",559 "SELECT * FROM pets WHERE weight > 10",560 "SELECT count(*) FROM pets WHERE weight > 10"561 ]562 },563 {564 "db_id": "pets_1",565 "final_query": "SELECT weight FROM pets ORDER BY pet_age LIMIT 1",566 "final_utterance": "How much does the youngest dog weigh?",567 "interaction_utterance": [568 "Order the pets by age",569 "How much does each one weigh?",570 "What about the first one?"571 ],572 "interaction_query": [573 "SELECT * FROM pets ORDER BY pet_age",574 "SELECT weight FROM pets ORDER BY pet_age",575 "SELECT weight FROM pets ORDER BY pet_age LIMIT 1"576 ]577 },578 {579 "db_id": "pets_1",580 "final_query": "SELECT max(weight) , petType FROM pets GROUP BY petType",581 "final_utterance": "List the maximum weight and type for each type of pet.",582 "interaction_utterance": [583 "What are the different types of pets?",584 "For each of those types, what is the maximum weight?"585 ],586 "interaction_query": [587 "SELECT DISTINCT petType FROM pets",588 "SELECT max(weight) , petType FROM pets GROUP BY petType"589 ]590 },591 {592 "db_id": "pets_1",593 "final_query": "SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.age > 20",594 "final_utterance": "How many pets are owned by students that have an age greater than 20?",595 "interaction_utterance": [596 "Which pets are owned by students older than 20?",597 "How many are there?"598 ],599 "interaction_query": [600 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.age > 20",601 "SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.age > 20"602 ]603 },604 {605 "db_id": "pets_1",606 "final_query": "SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T2.petid = T3.petid WHERE T1.sex = 'F' AND T3.pettype = 'dog'",607 "final_utterance": "How many dog pets are raised by female students?",608 "interaction_utterance": [609 "Who are the female students?",610 "Of those, who has a pet?",611 "How many of those have dogs?"612 ],613 "interaction_query": [614 "SELECT * FROM student WHERE sex = 'F'",615 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.sex = 'F'",616 "SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T2.petid = T3.petid WHERE T1.sex = 'F' AND T3.pettype = 'dog'"617 ]618 },619 {620 "db_id": "pets_1",621 "final_query": "SELECT count(DISTINCT pettype) FROM pets",622 "final_utterance": "How many different types of pet are there?",623 "interaction_utterance": [624 "What are the different pet types?",625 "How many exist?"626 ],627 "interaction_query": [628 "SELECT DISTINCT pettype FROM pets",629 "SELECT count(DISTINCT pettype) FROM pets"630 ]631 },632 {633 "db_id": "pets_1",634 "final_query": "SELECT DISTINCT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat' OR T3.pettype = 'dog'",635 "final_utterance": "What are the first names of every student who has a cat or dog as a pet?",636 "interaction_utterance": [637 "what is the first name of every student?",638 "Of those names, which ones correspond to somebody who has a cat?",639 "Also, combine those names with those who have a dog."640 ],641 "interaction_query": [642 "SELECT DISTINCT T1.Fname FROM student AS T1",643 "SELECT DISTINCT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat'",644 "SELECT DISTINCT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat' OR T3.pettype = 'dog'"645 ]646 },647 {648 "db_id": "pets_1",649 "final_query": "SELECT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat' INTERSECT SELECT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog'",650 "final_utterance": "What are the students' first names who have both cats and dogs as pets?",651 "interaction_utterance": [652 "Which students have a dog as their type of pet?",653 "Who also has a cat?",654 "What are their first names?"655 ],656 "interaction_query": [657 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog'",658 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat' INTERSECT SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog'",659 "SELECT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat' INTERSECT SELECT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog'"660 ]661 },662 {663 "db_id": "pets_1",664 "final_query": "SELECT major , age FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat')",665 "final_utterance": "What major is every student who does not own a cat as a pet, and also how old are they?",666 "interaction_utterance": [667 "Which students have a cat as their pets?",668 "What are they majoring in?",669 "Also, how old are they?"670 ],671 "interaction_query": [672 "SELECT * FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat')",673 "SELECT major FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat')",674 "SELECT major , age FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat')"675 ]676 },677 {678 "db_id": "pets_1",679 "final_query": "SELECT stuid FROM student EXCEPT SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat'",680 "final_utterance": "What are the ids of the students who do not own cats as pets?",681 "interaction_utterance": [682 "What is every student's id?",683 "Of those ids, which correspond to those who own cats as pets?",684 "List all the other ids."685 ],686 "interaction_query": [687 "SELECT stuid FROM student",688 "SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat'",689 "SELECT stuid FROM student EXCEPT SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat'"690 ]691 },692 {693 "db_id": "pets_1",694 "final_query": "SELECT T1.fname , T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog' AND T1.stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat')",695 "final_utterance": "What is the first name of every student who has a dog but does not have a cat?",696 "interaction_utterance": [697 "Which students have dogs?",698 "Of those, who does not own a cat?",699 "What are their first names and ages?"700 ],701 "interaction_query": [702 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog'",703 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog' EXCEPT SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat'",704 "SELECT T1.fname , T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog' EXCEPT SELECT T1.fname , T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat'"705 ]706 },707 {708 "db_id": "pets_1",709 "final_query": "SELECT pettype , weight FROM pets ORDER BY pet_age LIMIT 1",710 "final_utterance": "What type of pet is the youngest animal, and how much does it weigh?",711 "interaction_utterance": [712 "Who is the youngest pet?",713 "What type are they?",714 "Also, how much do they weigh?"715 ],716 "interaction_query": [717 "SELECT * FROM pets ORDER BY pet_age LIMIT 1",718 "SELECT pettype FROM pets ORDER BY pet_age LIMIT 1",719 "SELECT pettype , weight FROM pets ORDER BY pet_age LIMIT 1"720 ]721 },722 {723 "db_id": "pets_1",724 "final_query": "SELECT petid , weight FROM pets WHERE pet_age > 1",725 "final_utterance": "What is the id and weight of every pet who is older than 1?",726 "interaction_utterance": [727 "What are ids of every pet?",728 "For those, which refer to pets older than 1?",729 "Also, how much do they weigh?"730 ],731 "interaction_query": [732 "SELECT petid FROM pets",733 "SELECT petid FROM pets WHERE pet_age > 1",734 "SELECT petid , weight FROM pets WHERE pet_age > 1"735 ]736 },737 {738 "db_id": "pets_1",739 "final_query": "SELECT avg(pet_age) , max(pet_age) , pettype FROM pets GROUP BY pettype",740 "final_utterance": "What is the average and maximum age for each pet type?",741 "interaction_utterance": [742 "What are the different pet types?",743 "For each of those, what is the maximum age?",744 "What about the average age?"745 ],746 "interaction_query": [747 "SELECT DISTINCT pettype FROM pets",748 "SELECT max(pet_age) , pettype FROM pets GROUP BY pettype",749 "SELECT avg(pet_age) , pettype FROM pets GROUP BY pettype"750 ]751 },752 {753 "db_id": "pets_1",754 "final_query": "SELECT avg(weight) , pettype FROM pets GROUP BY pettype",755 "final_utterance": "What is the average weight for each type of pet?",756 "interaction_utterance": [757 "What information is there on pets?",758 "For each pet type, what is the average weight?"759 ],760 "interaction_query": [761 "SELECT * FROM pets",762 "SELECT avg(weight) , pettype FROM pets GROUP BY pettype"763 ]764 },765 {766 "db_id": "pets_1",767 "final_query": "SELECT DISTINCT T1.fname , T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid",768 "final_utterance": "What are the different first names and ages of the students who do have pets?",769 "interaction_utterance": [770 "Which students have pets?",771 "What are the different first names?",772 "Also, what are their ages?"773 ],774 "interaction_query": [775 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid",776 "SELECT DISTINCT T1.fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid",777 "SELECT DISTINCT T1.fname , T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid"778 ]779 },780 {781 "db_id": "pets_1",782 "final_query": "SELECT T2.petid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.Lname = 'Smith'",783 "final_utterance": "What is the id of the pet owned by the student whose last name is 'Smith'?",784 "interaction_utterance": [785 "Which students have pets?",786 "Of those, whose last name is smith?",787 "What is their pet's id?"788 ],789 "interaction_query": [790 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid",791 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.Lname = 'Smith'",792 "SELECT T2.petid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.Lname = 'Smith'"793 ]794 },795 {796 "db_id": "pets_1",797 "final_query": "SELECT count(*) , T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid GROUP BY T1.stuid",798 "final_utterance": "For students who have pets, how many pets does each student have?",799 "interaction_utterance": [800 "Which of the students have pets?",801 "How many pets does each of them have?"802 ],803 "interaction_query": [804 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid",805 "SELECT count(*) , T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid GROUP BY T1.stuid"806 ]807 },808 {809 "db_id": "pets_1",810 "final_query": "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",811 "final_utterance": "What is the first name and gender of the all the students who have more than one pet?",812 "interaction_utterance": [813 "What is the first name and sex of each student?",814 "Which of those belong to somebody who has more than one pet?"815 ],816 "interaction_query": [817 "SELECT T1.fname , T1.sex FROM student AS T1",818 "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"819 ]820 },821 {822 "db_id": "pets_1",823 "final_query": "SELECT T1.lname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pet_age = 3 AND T3.pettype = 'cat'",824 "final_utterance": "What is the last name of the student who has a cat that is 3 years old?",825 "interaction_utterance": [826 "What is the id of the three-year old cat?",827 "Who is the owner of that cat?",828 "What is their last name?"829 ],830 "interaction_query": [831 "SELECT petid FROM pets WHERE pet_age = 3 AND pettype = 'cat'",832 "SELECT * FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pet_age = 3 AND T3.pettype = 'cat'",833 "SELECT T1.lname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pet_age = 3 AND T3.pettype = 'cat'"834 ]835 },836 {837 "db_id": "pets_1",838 "final_query": "SELECT avg(age) FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid)",839 "final_utterance": "What is the average age for all students who do not own any pets?",840 "interaction_utterance": [841 "Which students do not own any pets?",842 "What is their average age?"843 ],844 "interaction_query": [845 "SELECT * FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid)",846 "SELECT avg(age) FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid)"847 ]848 },849 {850 "db_id": "world_1",851 "final_query": "SELECT Name FROM country WHERE IndepYear > 1950",852 "final_utterance": "Give the names of the nations that were founded after 1950.",853 "interaction_utterance": [854 "What are the names of all the countries?",855 "Give the names of the ones that became independent after 1950."856 ],857 "interaction_query": [858 "SELECT Name FROM country",859 "SELECT Name FROM country WHERE IndepYear > 1950"860 ]861 },862 {863 "db_id": "world_1",864 "final_query": "SELECT count(*) FROM country WHERE GovernmentForm = \"Republic\"",865 "final_utterance": "How many countries have governments that are republics?",866 "interaction_utterance": [867 "How many countries are there?",868 "Out of those, how many have a republic as their form of government?"869 ],870 "interaction_query": [871 "SELECT count(*) FROM country",872 "SELECT count(*) FROM country WHERE GovernmentForm = \"Republic\""873 ]874 },875 {876 "db_id": "world_1",877 "final_query": "SELECT sum(SurfaceArea) FROM country WHERE Region = \"Caribbean\"",878 "final_utterance": "How much surface area do the countires in the Carribean cover together?",879 "interaction_utterance": [880 "What are the countries in the Carribean region?",881 "What is the surface area of each of those countries?",882 "Find the total surface area of the above."883 ],884 "interaction_query": [885 "SELECT * FROM country WHERE Region = \"Caribbean\"",886 "SELECT SurfaceArea FROM country WHERE Region = \"Caribbean\"",887 "SELECT sum(SurfaceArea) FROM country WHERE Region = \"Caribbean\""888 ]889 },890 {891 "db_id": "world_1",892 "final_query": "SELECT Continent FROM country WHERE Name = \"Anguilla\"",893 "final_utterance": "What is the continent name which Anguilla belongs to?",894 "interaction_utterance": [895 "What continent does each country belong to?",896 "Which one does Anguila belong to?"897 ],898 "interaction_query": [899 "SELECT Continent FROM country",900 "SELECT Continent FROM country WHERE Name = \"Anguilla\""901 ]902 },903 {904 "db_id": "world_1",905 "final_query": "SELECT Region FROM country AS T1 JOIN city AS T2 ON T1.Code = T2.CountryCode WHERE T2.Name = \"Kabul\"",906 "final_utterance": "What region is Kabul in?",907 "interaction_utterance": [908 "What are the names of all the regions?",909 "Which of those is the city Kabul located in?"910 ],911 "interaction_query": [912 "SELECT Region FROM country",913 "SELECT Region FROM country AS T1 JOIN city AS T2 ON T1.Code = T2.CountryCode WHERE T2.Name = \"Kabul\""914 ]915 },916 {917 "db_id": "world_1",918 "final_query": "SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = \"Aruba\" ORDER BY Percentage DESC LIMIT 1",919 "final_utterance": "What language is predominantly spoken in Aruba?",920 "interaction_utterance": [921 "What are all the languages?",922 "What are the languages spoken in Aruba?",923 "Which one is the most popular?"924 ],925 "interaction_query": [926 "SELECT LANGUAGE FROM countrylanguage",927 "SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = \"Aruba\"",928 "SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = \"Aruba\" ORDER BY Percentage DESC LIMIT 1"929 ]930 },931 {932 "db_id": "world_1",933 "final_query": "SELECT Population , LifeExpectancy FROM country WHERE Name = \"Brazil\"",934 "final_utterance": "Give me Brazil\u2019s population and life expectancies.",935 "interaction_utterance": [936 "What are the population and life expectancies for all countries?",937 "Of those, which ones are for the country Brazil?"938 ],939 "interaction_query": [940 "SELECT Population , LifeExpectancy FROM country",941 "SELECT Population , LifeExpectancy FROM country WHERE Name = \"Brazil\""942 ]943 },944 {945 "db_id": "world_1",946 "final_query": "SELECT Population , Region FROM country WHERE Name = \"Angola\"",947 "final_utterance": "What region does Angola belong to and what is its population?",948 "interaction_utterance": [949 "Which region is Angola in?",950 "For that country, what is its population?"951 ],952 "interaction_query": [953 "SELECT Region FROM country WHERE Name = \"Angola\"",954 "SELECT Population FROM country WHERE Name = \"Angola\""955 ]956 },957 {958 "db_id": "world_1",959 "final_query": "SELECT avg(LifeExpectancy) FROM country WHERE Region = \"Central Africa\"",960 "final_utterance": "How long is the people\u2019s average life expectancy in Central Africa?",961 "interaction_utterance": [962 "What are the life expectancies for all the countries?",963 "What are the life expectancies for the countries in the region of Central Africa?",964 "What is the average of those?"965 ],966 "interaction_query": [967 "SELECT LifeExpectancy FROM country",968 "SELECT LifeExpectancy FROM country WHERE Region = \"Central Africa\"",969 "SELECT avg(LifeExpectancy) FROM country WHERE Region = \"Central Africa\""970 ]971 },972 {973 "db_id": "world_1",974 "final_query": "SELECT Name FROM country WHERE Continent = \"Asia\" ORDER BY LifeExpectancy LIMIT 1",975 "final_utterance": "Give the name of the country in Asia with the lowest life expectancy.",976 "interaction_utterance": [977 "What are the names of the countries in Asia?",978 "Which one has the shortest life expectancy?"979 ],980 "interaction_query": [981 "SELECT Name FROM country WHERE Continent = \"Asia\"",982 "SELECT Name FROM country WHERE Continent = \"Asia\" ORDER BY LifeExpectancy LIMIT 1"983 ]984 },985 {986 "db_id": "world_1",987 "final_query": "SELECT sum(Population) , max(GNP) FROM country WHERE Continent = \"Asia\"",988 "final_utterance": "How many people live in Asia, and what is the largest GNP among them?",989 "interaction_utterance": [990 "How many people live in Asia?",991 "What about the largest GNP among them?"992 ],993 "interaction_query": [994 "SELECT sum(Population) FROM country WHERE Continent = \"Asia\"",995 "SELECT max(GNP) FROM country WHERE Continent = \"Asia\""996 ]997 },998 {999 "db_id": "world_1",1000 "final_query": "SELECT avg(LifeExpectancy) FROM country WHERE Continent = \"Africa\" AND GovernmentForm = \"Republic\"",1001 "final_utterance": "Give the average life expectancy for countries in Africa which are republics?",1002 "interaction_utterance": [1003 "Which countries are in Africa?",1004 "Which countries are also republics?",1005 "What is the average of their life expectancies?"1006 ],1007 "interaction_query": [1008 "SELECT * FROM country WHERE Continent = \"Africa\"",1009 "SELECT * FROM country WHERE Continent = \"Africa\" AND GovernmentForm = \"Republic\"",1010 "SELECT avg(LifeExpectancy) FROM country WHERE Continent = \"Africa\" AND GovernmentForm = \"Republic\""1011 ]1012 },1013 {1014 "db_id": "world_1",1015 "final_query": "SELECT sum(SurfaceArea) FROM country WHERE Continent = \"Asia\" OR Continent = \"Europe\"",1016 "final_utterance": "Give the total surface area covered by countries in Asia or Europe.",1017 "interaction_utterance": [1018 "What are the countries in the continents of Asia or Europe?",1019 "What is the surface area of each country?",1020 "What is the total surface area summed up?"1021 ],1022 "interaction_query": [1023 "SELECT * FROM country WHERE Continent = \"Asia\" OR Continent = \"Europe\"",1024 "SELECT SurfaceArea FROM country WHERE Continent = \"Asia\" OR Continent = \"Europe\"",1025 "SELECT sum(SurfaceArea) FROM country WHERE Continent = \"Asia\" OR Continent = \"Europe\""1026 ]1027 },1028 {1029 "db_id": "world_1",1030 "final_query": "SELECT sum(Population) FROM city WHERE District = \"Gelderland\"",1031 "final_utterance": "What is the total population of Gelderland district?",1032 "interaction_utterance": [1033 "What are the populations of each city in the district of Gelderland?",1034 "What is the total population in that district?"1035 ],1036 "interaction_query": [1037 "SELECT Population FROM city WHERE District = \"Gelderland\"",1038 "SELECT sum(Population) FROM city WHERE District = \"Gelderland\""1039 ]1040 },1041 {1042 "db_id": "world_1",1043 "final_query": "SELECT avg(GNP) , sum(population) FROM country WHERE GovernmentForm = \"US Territory\"",1044 "final_utterance": "Give the mean GNP and total population of nations which are considered US territory.",1045 "interaction_utterance": [1046 "What are all the nations?",1047 "Which of those have a government that is a US territory?",1048 "For those, what is the average GNP and total population?"1049 ],1050 "interaction_query": [1051 "SELECT * FROM country",1052 "SELECT * FROM country WHERE GovernmentForm = \"US Territory\"",1053 "SELECT avg(GNP) , sum(population) FROM country WHERE GovernmentForm = \"US Territory\""1054 ]1055 },1056 {1057 "db_id": "world_1",1058 "final_query": "SELECT count(DISTINCT LANGUAGE) FROM countrylanguage",1059 "final_utterance": "What is the number of distinct languages used around the world?",1060 "interaction_utterance": [1061 "What are all the distinct languages used around the world?",1062 "How many are there?"1063 ],1064 "interaction_query": [1065 "SELECT DISTINCT LANGUAGE FROM countrylanguage",1066 "SELECT count(DISTINCT LANGUAGE) FROM countrylanguage"1067 ]1068 },1069 {1070 "db_id": "world_1",1071 "final_query": "SELECT count(DISTINCT GovernmentForm) FROM country WHERE Continent = \"Africa\"",1072 "final_utterance": "How many different forms of governments are there in Africa?",1073 "interaction_utterance": [1074 "What are the distinct forms of government in the continent of Africa?",1075 "How many are there?"1076 ],1077 "interaction_query": [1078 "SELECT DISTINCT GovernmentForm FROM country WHERE Continent = \"Africa\"",1079 "SELECT count(DISTINCT GovernmentForm) FROM country WHERE Continent = \"Africa\""1080 ]1081 },1082 {1083 "db_id": "world_1",1084 "final_query": "SELECT COUNT(T2.Language) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = \"Aruba\"",1085 "final_utterance": "How many languages are spoken in Aruba?",1086 "interaction_utterance": [1087 "What is the information about the country Aruba?",1088 "What are the languages used in Aruba?",1089 "How many are there?"1090 ],1091 "interaction_query": [1092 "SELECT * FROM country WHERE Name = \"Aruba\"",1093 "SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = \"Aruba\"",1094 "SELECT COUNT(T2.Language) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = \"Aruba\""1095 ]1096 },1097 {1098 "db_id": "world_1",1099 "final_query": "SELECT COUNT(*) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = \"Afghanistan\" AND IsOfficial = \"T\"",1100 "final_utterance": "How many official languages are spoken in Afghanistan?",1101 "interaction_utterance": [1102 "What are the languages used in Afghanistan?",1103 "Of those, how many are the official languages?"1104 ],1105 "interaction_query": [1106 "SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = \"Afghanistan\"",1107 "SELECT COUNT(*) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = \"Afghanistan\" AND IsOfficial = \"T\""1108 ]1109 },1110 {1111 "db_id": "world_1",1112 "final_query": "SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Name ORDER BY COUNT(*) DESC LIMIT 1",1113 "final_utterance": "Give the name of the nation that uses the greatest amount of languages.",1114 "interaction_utterance": [1115 "How many languages are spoken in each country?",1116 "Which country speaks the most?"1117 ],1118 "interaction_query": [1119 "SELECT count(*) , T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Name",1120 "SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Name ORDER BY COUNT(*) DESC LIMIT 1"1121 ]1122 },1123 {1124 "db_id": "world_1",1125 "final_query": "SELECT T1.Continent FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Continent ORDER BY COUNT(*) DESC LIMIT 1",1126 "final_utterance": "Which continent speaks the most languages?",1127 "interaction_utterance": [1128 "How many languages are spoken on each continent?",1129 "Which one speaks the most languages?"1130 ],1131 "interaction_query": [1132 "SELECT COUNT(*) , T1.Continent FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Continent",1133 "SELECT T1.Continent FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Continent ORDER BY COUNT(*) DESC LIMIT 1"1134 ]1135 },1136 {1137 "db_id": "world_1",1138 "final_query": "SELECT COUNT(*) FROM (SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"Dutch\")",1139 "final_utterance": "What is the number of nations that use English and Dutch?",1140 "interaction_utterance": [1141 "What are the countries that speak English?",1142 "Which of those also speak Dutch?",1143 "How many of them are there?"1144 ],1145 "interaction_query": [1146 "SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\"",1147 "SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"Dutch\"",1148 "SELECT COUNT(*) FROM (SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"Dutch\")"1149 ]1150 },1151 {1152 "db_id": "world_1",1153 "final_query": "SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"French\"",1154 "final_utterance": "Give the names of nations that speak both English and French.",1155 "interaction_utterance": [1156 "What are the names of countries which speak English?",1157 "Of those countries, what are the names of the nations that speak French as well?"1158 ],1159 "interaction_query": [1160 "SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\"",1161 "SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"French\""1162 ]1163 },1164 {1165 "db_id": "world_1",1166 "final_query": "SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\" AND T2.IsOfficial = \"T\" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"French\" AND T2.IsOfficial = \"T\"",1167 "final_utterance": "Give the names of countries with English and French as official languages.",1168 "interaction_utterance": [1169 "What are the official languages of each country?",1170 "Of those countries, give the names of the ones that have English as one of the official languages.",1171 "Of those, which also have French as another official language?"1172 ],1173 "interaction_query": [1174 "SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.IsOfficial = \"T\"",1175 "SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\" AND T2.IsOfficial = \"T\"",1176 "SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\" AND T2.IsOfficial = \"T\" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"French\" AND T2.IsOfficial = \"T\""1177 ]1178 },1179 {1180 "db_id": "world_1",1181 "final_query": "SELECT COUNT( DISTINCT Continent) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"Chinese\"",1182 "final_utterance": "How many continents speak Chinese?",1183 "interaction_utterance": [1184 "In which countries is Chinese spoken?",1185 "Which distinct continents are they in?",1186 "How many of them are there?"1187 ],1188 "interaction_query": [1189 "SELECT T1.name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"Chinese\"",1190 "SELECT DISTINCT T1.Continent FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"Chinese\"",1191 "SELECT COUNT( DISTINCT Continent) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"Chinese\""1192 ]1193 },1194 {1195 "db_id": "world_1",1196 "final_query": "SELECT DISTINCT T1.Region FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = \"English\" OR T2.Language = \"Dutch\"",1197 "final_utterance": "Which regions speak Dutch or English?",1198 "interaction_utterance": [1199 "What are all the different regions?",1200 "Which of those speak Dutch or English?"