marceldrhr/Llama-Text2SQL
This is an adjusted column names version from DominikLindorfer/SQL-LLaMA (https://huggingface.co/datasets/DominikLindorfer/SQL-LLaMA)
16
1[2 {3 "response": "SELECT delegate FROM table_1825751_14 WHERE pageant = \"Elite Model Look\" AND year > 1993.0",4 "context": "CREATE TABLE table_1825751_14 (delegate VARCHAR, pageant VARCHAR, year VARCHAR)",5 "instruction": "where pageant is elite model look and year is bigger than 1993.0, who is the delegate?"6 },7 {8 "response": "SELECT COUNT(year) FROM table_1825751_14 WHERE pageant = \"Miss Globe International\" AND delegate = \"Karen Loren Medrano Agustin\"",9 "context": "CREATE TABLE table_1825751_14 (year VARCHAR, pageant VARCHAR, delegate VARCHAR)",10 "instruction": "How many years was the pageant miss globe international and delegate was karen loren medrano agustin?"11 },12 {13 "response": "SELECT COUNT(pageant) FROM table_1825751_14 WHERE delegate = \"Margaret Ann Awitan Bayot\"",14 "context": "CREATE TABLE table_1825751_14 (pageant VARCHAR, delegate VARCHAR)",15 "instruction": "How many pageants were margaret ann awitan bayot the delegate of?"16 },17 {18 "response": "SELECT AVG(num_employees) FROM department WHERE ranking BETWEEN 10 AND 15",19 "context": "CREATE TABLE department (num_employees INTEGER, ranking INTEGER)",20 "instruction": "What is the average number of employees of the departments whose rank is between 10 and 15?"21 },22 {23 "response": "SELECT DISTINCT T1.creation FROM department AS T1 JOIN management AS T2 ON T1.department_id = T2.department_id JOIN head AS T3 ON T2.head_id = T3.head_id WHERE T3.born_state = 'Alabama'",24 "context": "CREATE TABLE department (creation VARCHAR, department_id VARCHAR); CREATE TABLE management (department_id VARCHAR, head_id VARCHAR); CREATE TABLE head (head_id VARCHAR, born_state VARCHAR)",25 "instruction": "What are the distinct creation years of the departments managed by a secretary born in state 'Alabama'?"26 },27 {28 "response": "SELECT location FROM table_182499_1 WHERE substrate = \"Coproporphyrinogen III\"",29 "context": "CREATE TABLE table_182499_1 (location VARCHAR, substrate VARCHAR)",30 "instruction": "give the location of subtrate coproporphyrinogen iii"31 },32 {33 "response": "SELECT T1.name, T1.num_employees FROM department AS T1 JOIN management AS T2 ON T1.department_id = T2.department_id WHERE T2.temporary_acting = 'Yes'",34 "context": "CREATE TABLE management (department_id VARCHAR, temporary_acting VARCHAR); CREATE TABLE department (name VARCHAR, num_employees VARCHAR, department_id VARCHAR)",35 "instruction": "Show the name and number of employees for the departments managed by heads whose temporary acting value is 'Yes'?"36 },37 {38 "response": "SELECT COUNT(*) FROM department WHERE NOT department_id IN (SELECT department_id FROM management)",39 "context": "CREATE TABLE management (department_id VARCHAR); CREATE TABLE department (department_id VARCHAR)",40 "instruction": "How many departments are led by heads who are not mentioned?"41 },42 {43 "response": "SELECT T3.born_state FROM department AS T1 JOIN management AS T2 ON T1.department_id = T2.department_id JOIN head AS T3 ON T2.head_id = T3.head_id WHERE T1.name = 'Treasury' INTERSECT SELECT T3.born_state FROM department AS T1 JOIN management AS T2 ON T1.department_id = T2.department_id JOIN head AS T3 ON T2.head_id = T3.head_id WHERE T1.name = 'Homeland Security'",44 "context": "CREATE TABLE management (department_id VARCHAR, head_id VARCHAR); CREATE TABLE head (born_state VARCHAR, head_id VARCHAR); CREATE TABLE department (department_id VARCHAR, name VARCHAR)",45 "instruction": "List the states where both the secretary of 'Treasury' department and the secretary of 'Homeland Security' were born."46 },47 {48 "response": "SELECT T1.department_id, T1.name, COUNT(*) FROM management AS T2 JOIN department AS T1 ON T1.department_id = T2.department_id GROUP BY T1.department_id HAVING COUNT(*) > 1",49 "context": "CREATE TABLE management (department_id VARCHAR); CREATE TABLE department (department_id VARCHAR, name VARCHAR)",50 "instruction": "Which department has more than 1 head at a time? List the id, name and the number of heads."51 },52 {53 "response": "SELECT COUNT(binibining_pilipinas_international) FROM table_1825751_4 WHERE binibining_pilipinas_world = \"Maria Karla Bautista\"",54 "context": "CREATE TABLE table_1825751_4 (binibining_pilipinas_international VARCHAR, binibining_pilipinas_world VARCHAR)",55 "instruction": "How many winners of binibining pilipinas-International when Maria Karla Bautista won binibining pilipinas-world?"56 },57 {58 "response": "SELECT date FROM table_name_59 WHERE venue = \"punt road oval\"",59 "context": "CREATE TABLE table_name_59 (date VARCHAR, venue VARCHAR)",60 "instruction": "What day did the VFL play Punt Road Oval?"61 },62 {63 "response": "SELECT COUNT(miss_universe_philippines) FROM table_1825751_4 WHERE binibining_pilipinas_international = \"Margaret Ann Bayot\"",64 "context": "CREATE TABLE table_1825751_4 (miss_universe_philippines VARCHAR, binibining_pilipinas_international VARCHAR)",65 "instruction": "When Margaret Ann Bayot won binibining pilipinas-international, how many winners of Miss Universe Philippines were there?"66 },67 {68 "response": "SELECT binibining_pilipinas_international FROM table_1825751_4 WHERE miss_universe_philippines = \"Gionna Cabrera\"",69 "context": "CREATE TABLE table_1825751_4 (binibining_pilipinas_international VARCHAR, miss_universe_philippines VARCHAR)",70 "instruction": "Who was the winner of binibining pilipinas-International wheh Gionna Cabrera won Miss Universe Philippines?"71 },72 {73 "response": "SELECT serial_no FROM table_name_71 WHERE colour = \"black\" AND pilot_car_no > 2 AND engine_no = 1008",74 "context": "CREATE TABLE table_name_71 (serial_no VARCHAR, engine_no VARCHAR, colour VARCHAR, pilot_car_no VARCHAR)",75 "instruction": "What is the serial number of the pilot car that is black, has a pilot car number larger than 2, and an engine number of 1008?"76 },77 {78 "response": "SELECT T2.Year, T1.Official_Name FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID = T2.Host_city_ID",79 "context": "CREATE TABLE city (Official_Name VARCHAR, City_ID VARCHAR); CREATE TABLE farm_competition (Year VARCHAR, Host_city_ID VARCHAR)",80 "instruction": "Show the years and the official names of the host cities of competitions."81 },82 {83 "response": "SELECT T1.Official_Name FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID = T2.Host_city_ID GROUP BY T2.Host_city_ID HAVING COUNT(*) > 1",84 "context": "CREATE TABLE farm_competition (Host_city_ID VARCHAR); CREATE TABLE city (Official_Name VARCHAR, City_ID VARCHAR)",85 "instruction": "Show the official names of the cities that have hosted more than one competition."86 },87 {88 "response": "SELECT T2.Theme FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID = T2.Host_city_ID WHERE T1.Population > 1000",89 "context": "CREATE TABLE city (City_ID VARCHAR, Population INTEGER); CREATE TABLE farm_competition (Theme VARCHAR, Host_city_ID VARCHAR)",90 "instruction": "Please show the themes of competitions with host cities having populations larger than 1000."91 },92 {93 "response": "SELECT T1.course_name FROM courses AS T1 JOIN student_course_registrations AS T2 ON T1.course_id = T2.course_Id GROUP BY T1.course_id ORDER BY COUNT(*) DESC LIMIT 1",94 "context": "CREATE TABLE courses (course_name VARCHAR, course_id VARCHAR); CREATE TABLE student_course_registrations (course_Id VARCHAR)",95 "instruction": "which course has most number of registered students?"96 },97 {98 "response": "SELECT COUNT(cover_date) FROM table_18305523_2 WHERE story_title = \"DEVASTATION DERBY! (Part 1)\"",99 "context": "CREATE TABLE table_18305523_2 (cover_date VARCHAR, story_title VARCHAR)",100 "instruction": "How many cover dates does the story \"Devastation Derby! (part 1)\" have?"101 },102 {103 "response": "SELECT student_id FROM students WHERE NOT student_id IN (SELECT student_id FROM student_course_attendance)",104 "context": "CREATE TABLE student_course_attendance (student_id VARCHAR); CREATE TABLE students (student_id VARCHAR)",105 "instruction": "List the id of students who never attends courses?"106 },107 {108 "response": "SELECT T1.student_id, T2.course_name FROM student_course_registrations AS T1 JOIN courses AS T2 ON T1.course_id = T2.course_id",109 "context": "CREATE TABLE courses (course_name VARCHAR, course_id VARCHAR); CREATE TABLE student_course_registrations (student_id VARCHAR, course_id VARCHAR)",110 "instruction": "What are the ids of all students for courses and what are the names of those courses?"111 },112 {113 "response": "SELECT COUNT(*) FROM courses AS T1 JOIN student_course_attendance AS T2 ON T1.course_id = T2.course_id WHERE T1.course_name = \"English\"",114 "context": "CREATE TABLE student_course_attendance (course_id VARCHAR); CREATE TABLE courses (course_id VARCHAR, course_name VARCHAR)",115 "instruction": "How many students attend course English?"116 },117 {118 "response": "SELECT T1.student_details FROM students AS T1 JOIN student_course_registrations AS T2 ON T1.student_id = T2.student_id GROUP BY T1.student_id ORDER BY COUNT(*) DESC LIMIT 1",119 "context": "CREATE TABLE students (student_details VARCHAR, student_id VARCHAR); CREATE TABLE student_course_registrations (student_id VARCHAR)",120 "instruction": "What is detail of the student who registered the most number of courses?"121 },122 {123 "response": "SELECT SUM(platform) FROM table_name_98 WHERE frequency__per_hour_ = 4 AND destination = \"west croydon\"",124 "context": "CREATE TABLE table_name_98 (platform INTEGER, frequency__per_hour_ VARCHAR, destination VARCHAR)",125 "instruction": "what is the platform when the frequency (per hour) is 4 and the destination is west croydon?"126 },127 {128 "response": "SELECT T3.course_name, COUNT(*) FROM students AS T1 JOIN student_course_registrations AS T2 ON T1.student_id = T2.student_id JOIN courses AS T3 ON T2.course_id = T3.course_id GROUP BY T2.course_id",129 "context": "CREATE TABLE students (student_id VARCHAR); CREATE TABLE courses (course_name VARCHAR, course_id VARCHAR); CREATE TABLE student_course_registrations (course_id VARCHAR, student_id VARCHAR)",130 "instruction": "How many registed students do each course have? List course name and the number of their registered students?"131 },132 {133 "response": "SELECT MAX(platform) FROM table_name_32 WHERE frequency__per_hour_ = 4 AND operator = \"london overground\" AND destination = \"west croydon\"",134 "context": "CREATE TABLE table_name_32 (platform INTEGER, destination VARCHAR, frequency__per_hour_ VARCHAR, operator VARCHAR)",135 "instruction": "what is the highest platform number when the frequency (per hour) is 4, the operator is london overground and the destination is west croydon?"136 },137 {138 "response": "SELECT T3.cell_mobile_number FROM candidates AS T1 JOIN candidate_assessments AS T2 ON T1.candidate_id = T2.candidate_id JOIN people AS T3 ON T1.candidate_id = T3.person_id WHERE T2.asessment_outcome_code = \"Fail\"",139 "context": "CREATE TABLE candidates (candidate_id VARCHAR); CREATE TABLE people (cell_mobile_number VARCHAR, person_id VARCHAR); CREATE TABLE candidate_assessments (candidate_id VARCHAR, asessment_outcome_code VARCHAR)",140 "instruction": "Find the cell mobile number of the candidates whose assessment code is \"Fail\"?"141 },142 {143 "response": "SELECT DISTINCT T1.city FROM addresses AS T1 JOIN people_addresses AS T2 ON T1.address_id = T2.address_id",144 "context": "CREATE TABLE addresses (city VARCHAR, address_id VARCHAR); CREATE TABLE people_addresses (address_id VARCHAR)",145 "instruction": "Find distinct cities of addresses of people?"146 },147 {148 "response": "SELECT departure FROM table_18333678_2 WHERE going_to = \"Bourne\" AND arrival = \"11.45\"",149 "context": "CREATE TABLE table_18333678_2 (departure VARCHAR, going_to VARCHAR, arrival VARCHAR)",150 "instruction": "when does the train arriving at bourne at 11.45 departure "151 },152 {153 "response": "SELECT monarch FROM table_name_67 WHERE heir = \"robert curthose\" AND reason = \"father became king\"",154 "context": "CREATE TABLE table_name_67 (monarch VARCHAR, heir VARCHAR, reason VARCHAR)",155 "instruction": "Who is the Monarch whose Heir is Robert Curthose when the Reason is that the father became king?"156 },157 {158 "response": "SELECT departure FROM table_18333678_2 WHERE arrival = \"11.45\" AND going_to = \"Stamford East\"",159 "context": "CREATE TABLE table_18333678_2 (departure VARCHAR, arrival VARCHAR, going_to VARCHAR)",160 "instruction": "when does the train arriving at stamford east at 11.45 departure "161 },162 {163 "response": "SELECT DISTINCT T1.city FROM addresses AS T1 JOIN people_addresses AS T2 ON T1.address_id = T2.address_id JOIN students AS T3 ON T2.person_id = T3.student_id",164 "context": "CREATE TABLE students (student_id VARCHAR); CREATE TABLE addresses (city VARCHAR, address_id VARCHAR); CREATE TABLE people_addresses (address_id VARCHAR, person_id VARCHAR)",165 "instruction": "Find distinct cities of address of students?"166 },167 {168 "response": "SELECT course_id FROM student_course_registrations WHERE student_id = 121 UNION SELECT course_id FROM student_course_attendance WHERE student_id = 121",169 "context": "CREATE TABLE student_course_attendance (course_id VARCHAR, student_id VARCHAR); CREATE TABLE student_course_registrations (course_id VARCHAR, student_id VARCHAR)",170 "instruction": "Find the id of courses which are registered or attended by student whose id is 121?"171 },172 {173 "response": "SELECT * FROM student_course_registrations WHERE NOT student_id IN (SELECT student_id FROM student_course_attendance)",174 "context": "CREATE TABLE student_course_attendance (student_id VARCHAR); CREATE TABLE student_course_registrations (student_id VARCHAR)",175 "instruction": "What are all info of students who registered courses but not attended courses?"176 },177 {178 "response": "SELECT T2.student_id FROM courses AS T1 JOIN student_course_registrations AS T2 ON T1.course_id = T2.course_id WHERE T1.course_name = \"statistics\" ORDER BY T2.registration_date",179 "context": "CREATE TABLE student_course_registrations (student_id VARCHAR, course_id VARCHAR, registration_date VARCHAR); CREATE TABLE courses (course_id VARCHAR, course_name VARCHAR)",180 "instruction": "List the id of students who registered course statistics in the order of registration date."181 },182 {183 "response": "SELECT T2.student_id FROM courses AS T1 JOIN student_course_attendance AS T2 ON T1.course_id = T2.course_id WHERE T1.course_name = \"statistics\" ORDER BY T2.date_of_attendance",184 "context": "CREATE TABLE student_course_attendance (student_id VARCHAR, course_id VARCHAR, date_of_attendance VARCHAR); CREATE TABLE courses (course_id VARCHAR, course_name VARCHAR)",185 "instruction": "List the id of students who attended statistics courses in the order of attendance date."186 },187 {188 "response": "SELECT tottenham_hotspur_career FROM table_name_26 WHERE goals = \"10\" AND nationality = \"england\" AND position = \"df\" AND club_apps = \"118\"",189 "context": "CREATE TABLE table_name_26 (tottenham_hotspur_career VARCHAR, club_apps VARCHAR, position VARCHAR, goals VARCHAR, nationality VARCHAR)",190 "instruction": "What were the years of the Tottenham Hotspur career for the player with 10 goals, from England, played the df position, and had 118 club apps?"191 },192 {193 "response": "SELECT zip_code, AVG(mean_temperature_f) FROM weather WHERE date LIKE \"8/%\" GROUP BY zip_code",194 "context": "CREATE TABLE weather (zip_code VARCHAR, mean_temperature_f INTEGER, date VARCHAR)",195 "instruction": "For each zip code, return the average mean temperature of August there."196 },197 {198 "response": "SELECT name FROM table_name_27 WHERE authority = \"state\" AND roll = 318",199 "context": "CREATE TABLE table_name_27 (name VARCHAR, authority VARCHAR, roll VARCHAR)",200 "instruction": "Which school has a state authority and a roll of 318?"201 },202 {203 "response": "SELECT mlb_team FROM table_18373863_2 WHERE years_played = \"2008\" AND fcsl_team = \"DeLand\"",204 "context": "CREATE TABLE table_18373863_2 (mlb_team VARCHAR, years_played VARCHAR, fcsl_team VARCHAR)",205 "instruction": "when deland is the fcsl team and 2008 is the year played who is the mlb team?"206 },207 {208 "response": "SELECT Regular AS season FROM table_name_25 WHERE tournament < 2 AND total > 0 AND team = \"kansas\"",209 "context": "CREATE TABLE table_name_25 (Regular VARCHAR, team VARCHAR, tournament VARCHAR, total VARCHAR)",210 "instruction": "How many regular season titles did Kansas receive when they received fewer than 2 tournament titles and more than 0 total titles?"211 },212 {213 "response": "SELECT start_station_name, start_station_id FROM trip WHERE start_date LIKE \"8/%\" GROUP BY start_station_name ORDER BY COUNT(*) DESC LIMIT 1",214 "context": "CREATE TABLE trip (start_station_name VARCHAR, start_station_id VARCHAR, start_date VARCHAR)",215 "instruction": "Which start station had the most trips starting from August? Give me the name and id of the station."216 },217 {218 "response": "SELECT home_team FROM table_name_39 WHERE away_team = \"geelong\"",219 "context": "CREATE TABLE table_name_39 (home_team VARCHAR, away_team VARCHAR)",220 "instruction": "Which home team played against Geelong?"221 },222 {223 "response": "SELECT id FROM station WHERE city = \"San Francisco\" INTERSECT SELECT station_id FROM status GROUP BY station_id HAVING AVG(bikes_available) > 10",224 "context": "CREATE TABLE status (id VARCHAR, station_id VARCHAR, city VARCHAR, bikes_available INTEGER); CREATE TABLE station (id VARCHAR, station_id VARCHAR, city VARCHAR, bikes_available INTEGER)",225 "instruction": "What are the ids of stations that are located in San Francisco and have average bike availability above 10."226 },227 {228 "response": "SELECT T1.name, T1.id FROM station AS T1 JOIN status AS T2 ON T1.id = T2.station_id GROUP BY T2.station_id HAVING AVG(T2.bikes_available) > 14 UNION SELECT name, id FROM station WHERE installation_date LIKE \"12/%\"",229 "context": "CREATE TABLE station (name VARCHAR, id VARCHAR); CREATE TABLE station (name VARCHAR, id VARCHAR, installation_date VARCHAR); CREATE TABLE status (station_id VARCHAR, bikes_available INTEGER)",230 "instruction": "What are the names and ids of stations that had more than 14 bikes available on average or were installed in December?"231 },232 {233 "response": "SELECT greek__modern_ FROM table_1841901_1 WHERE polish__extinct_ = \"s\u0142ysza\u0142e\u015b by\u0142 / s\u0142ysza\u0142a\u015b by\u0142a\"",234 "context": "CREATE TABLE table_1841901_1 (greek__modern_ VARCHAR, polish__extinct_ VARCHAR)",235 "instruction": "Name the greek modern for s\u0142ysza\u0142e\u015b by\u0142 / s\u0142ysza\u0142a\u015b by\u0142a"236 },237 {238 "response": "SELECT zip_code FROM weather GROUP BY zip_code ORDER BY AVG(mean_sea_level_pressure_inches) LIMIT 1",239 "context": "CREATE TABLE weather (zip_code VARCHAR, mean_sea_level_pressure_inches INTEGER)",240 "instruction": "What is the zip code in which the average mean sea level pressure is the lowest?"241 },242 {243 "response": "SELECT us_air_date FROM table_18424435_4 WHERE canadian_viewers__million_ = \"1.452\"",244 "context": "CREATE TABLE table_18424435_4 (us_air_date VARCHAR, canadian_viewers__million_ VARCHAR)",245 "instruction": "What was the air date in the U.S. for the episode that had 1.452 million Canadian viewers?"246 },247 {248 "response": "SELECT T1.id FROM trip AS T1 JOIN weather AS T2 ON T1.zip_code = T2.zip_code GROUP BY T2.zip_code HAVING AVG(T2.mean_temperature_f) > 60",249 "context": "CREATE TABLE trip (id VARCHAR, zip_code VARCHAR); CREATE TABLE weather (zip_code VARCHAR, mean_temperature_f INTEGER)",250 "instruction": "Give me ids for all the trip that took place in a zip code area with average mean temperature above 60."251 },252 {253 "response": "SELECT date, zip_code FROM weather WHERE min_dew_point_f < (SELECT MIN(min_dew_point_f) FROM weather WHERE zip_code = 94107)",254 "context": "CREATE TABLE weather (date VARCHAR, zip_code VARCHAR, min_dew_point_f INTEGER)",255 "instruction": "On which day and in which zip code was the min dew point lower than any day in zip code 94107?"256 },257 {258 "response": "SELECT T1.id, T2.installation_date FROM trip AS T1 JOIN station AS T2 ON T1.end_station_id = T2.id",259 "context": "CREATE TABLE station (installation_date VARCHAR, id VARCHAR); CREATE TABLE trip (id VARCHAR, end_station_id VARCHAR)",260 "instruction": "For each trip, return its ending station's installation date."261 },262 {263 "response": "SELECT MIN(ligue_1_titles) FROM table_name_80 WHERE position_in_2012_13 = \"010 12th\" AND number_of_seasons_in_ligue_1 > 56",264 "context": "CREATE TABLE table_name_80 (ligue_1_titles INTEGER, position_in_2012_13 VARCHAR, number_of_seasons_in_ligue_1 VARCHAR)",265 "instruction": "I want to know the lowest ligue 1 titles for position in 2012-13 of 010 12th and number of seasons in ligue 1 more than 56"266 },267 {268 "response": "SELECT written_by FROM table_18424435_3 WHERE canadian_viewers__million_ = \"1.816\"",269 "context": "CREATE TABLE table_18424435_3 (written_by VARCHAR, canadian_viewers__million_ VARCHAR)",270 "instruction": "Who wrote the episodes watched by 1.816 million people in Canada?"271 },272 {273 "response": "SELECT median_house__hold_income FROM table_1840495_2 WHERE place = \"Upper Arlington\"",274 "context": "CREATE TABLE table_1840495_2 (median_house__hold_income VARCHAR, place VARCHAR)",275 "instruction": "For upper Arlington, what was the median household income?"276 },277 {278 "response": "SELECT T1.name FROM station AS T1 JOIN status AS T2 ON T1.id = T2.station_id GROUP BY T2.station_id HAVING AVG(bikes_available) > 10 EXCEPT SELECT name FROM station WHERE city = \"San Jose\"",279 "context": "CREATE TABLE station (name VARCHAR, id VARCHAR); CREATE TABLE status (station_id VARCHAR); CREATE TABLE station (name VARCHAR, city VARCHAR, bikes_available INTEGER)",280 "instruction": "What are names of stations that have average bike availability above 10 and are not located in San Jose city?"281 },282 {283 "response": "SELECT median_house__hold_income FROM table_1840495_2 WHERE population = 2188",284 "context": "CREATE TABLE table_1840495_2 (median_house__hold_income VARCHAR, population VARCHAR)",285 "instruction": "If the population is 2188, what was the median household income?"286 },287 {288 "response": "SELECT date, mean_temperature_f, mean_humidity FROM weather ORDER BY max_gust_speed_mph DESC LIMIT 3",289 "context": "CREATE TABLE weather (date VARCHAR, mean_temperature_f VARCHAR, mean_humidity VARCHAR, max_gust_speed_mph VARCHAR)",290 "instruction": "What are the date, mean temperature and mean humidity for the top 3 days with the largest max gust speeds?"291 },292 {293 "response": "SELECT per_capita_income FROM table_1840495_2 WHERE median_house__hold_income = \"$57,407\"",294 "context": "CREATE TABLE table_1840495_2 (per_capita_income VARCHAR, median_house__hold_income VARCHAR)",295 "instruction": "If the median income is $57,407, what is the per capita income?"296 },297 {298 "response": "SELECT T1.name, T1.long, AVG(T2.duration) FROM station AS T1 JOIN trip AS T2 ON T1.id = T2.start_station_id GROUP BY T2.start_station_id",299 "context": "CREATE TABLE station (name VARCHAR, long VARCHAR, id VARCHAR); CREATE TABLE trip (duration INTEGER, start_station_id VARCHAR)",300 "instruction": "For each station, return its longitude and the average duration of trips that started from the station."301 },302 {303 "response": "SELECT original_air_date FROM table_18427769_1 WHERE directed_by = \"Di Drew\"",304 "context": "CREATE TABLE table_18427769_1 (original_air_date VARCHAR, directed_by VARCHAR)",305 "instruction": "If Di Drew is the director, what was the original air date for episode A Whole Lot to Lose?"306 },307 {308 "response": "SELECT DISTINCT zip_code FROM weather EXCEPT SELECT DISTINCT zip_code FROM weather WHERE max_dew_point_f >= 70",309 "context": "CREATE TABLE weather (zip_code VARCHAR, max_dew_point_f VARCHAR)",310 "instruction": "Find all the zip codes in which the max dew point have never reached 70."311 },312 {313 "response": "SELECT COUNT(population__2010_census_) FROM table_184334_2 WHERE s_barangay = 51",314 "context": "CREATE TABLE table_184334_2 (population__2010_census_ VARCHAR, s_barangay VARCHAR)",315 "instruction": "What is the population (2010 census) if s barangay is 51?"316 },317 {318 "response": "SELECT home_team AS score FROM table_name_46 WHERE home_team = \"melbourne\"",319 "context": "CREATE TABLE table_name_46 (home_team VARCHAR)",320 "instruction": "When melbourne was the home team what was their score?"321 },322 {323 "response": "SELECT date, max_temperature_f - min_temperature_f FROM weather ORDER BY max_temperature_f - min_temperature_f LIMIT 1",324 "context": "CREATE TABLE weather (date VARCHAR, max_temperature_f VARCHAR, min_temperature_f VARCHAR)",325 "instruction": "Find the day in which the difference between the max temperature and min temperature was the smallest. Also report the difference."326 },327 {328 "response": "SELECT zip_code FROM weather GROUP BY zip_code HAVING AVG(mean_humidity) < 70 INTERSECT SELECT zip_code FROM trip GROUP BY zip_code HAVING COUNT(*) >= 100",329 "context": "CREATE TABLE weather (zip_code VARCHAR, mean_humidity INTEGER); CREATE TABLE trip (zip_code VARCHAR, mean_humidity INTEGER)",330 "instruction": "Give me the zip code where the average mean humidity is below 70 and at least 100 trips took place."331 },332 {333 "response": "SELECT COUNT(*) FROM station AS T1 JOIN trip AS T2 JOIN station AS T3 JOIN trip AS T4 ON T1.id = T2.start_station_id AND T2.id = T4.id AND T3.id = T4.end_station_id WHERE T1.city = \"Mountain View\" AND T3.city = \"Palo Alto\"",334 "context": "CREATE TABLE station (city VARCHAR, id VARCHAR); CREATE TABLE trip (end_station_id VARCHAR, id VARCHAR); CREATE TABLE station (id VARCHAR, city VARCHAR); CREATE TABLE trip (start_station_id VARCHAR, id VARCHAR)",335 "instruction": "How many trips started from Mountain View city and ended at Palo Alto city?"336 },337 {338 "response": "SELECT MIN(owned_since) FROM table_1847523_2 WHERE station = \"KERO-TV\"",339 "context": "CREATE TABLE table_1847523_2 (owned_since INTEGER, station VARCHAR)",340 "instruction": "What is the minimum stations owned since kero-tv?"341 },342 {343 "response": "SELECT lyric_fm__mhz_ FROM table_18475946_2 WHERE rnag__mhz_ = \"93.2\"",344 "context": "CREATE TABLE table_18475946_2 (lyric_fm__mhz_ VARCHAR, rnag__mhz_ VARCHAR)",345 "instruction": "What is the lyric fm for rnag 93.2?"346 },347 {348 "response": "SELECT world_ranking__1_ FROM table_name_54 WHERE ranking_la__2_ = \"5th\" AND year_of_publication = \"2008\"",349 "context": "CREATE TABLE table_name_54 (world_ranking__1_ VARCHAR, ranking_la__2_ VARCHAR, year_of_publication VARCHAR)",350 "instruction": "In 2008, what was the world ranking that ranked 5th in L.A.?"351 },352 {353 "response": "SELECT COUNT(played) FROM table_name_24 WHERE goals_for > 34 AND goals_against > 63",354 "context": "CREATE TABLE table_name_24 (played VARCHAR, goals_for VARCHAR, goals_against VARCHAR)",355 "instruction": "what is the total number of played when the goals for is more than 34 and goals against is more than 63?"356 },357 {358 "response": "SELECT SUM(goals_for) FROM table_name_50 WHERE position < 8 AND losses < 10 AND goals_against < 35 AND played < 38",359 "context": "CREATE TABLE table_name_50 (goals_for INTEGER, played VARCHAR, goals_against VARCHAR, position VARCHAR, losses VARCHAR)",360 "instruction": "what is the sum of goals for when the position is less than 8, the losses is less than 10 the goals against is less than 35 and played is less than 38?"361 },362 {363 "response": "SELECT state__class_ FROM table_1847180_3 WHERE date_of_successors_formal_installation = \"May 11, 1966\"",364 "context": "CREATE TABLE table_1847180_3 (state__class_ VARCHAR, date_of_successors_formal_installation VARCHAR)",365 "instruction": "What was the state (class) where the new successor was formally installed on May 11, 1966?"366 },367 {368 "response": "SELECT MAX(gold) FROM table_name_18 WHERE rank = \"12\" AND nation = \"vietnam\"",369 "context": "CREATE TABLE table_name_18 (gold INTEGER, rank VARCHAR, nation VARCHAR)",370 "instruction": "what is the highest gold when the rank is 12 for the nation vietnam?"371 },372 {373 "response": "SELECT Publication_Date FROM publication ORDER BY Price LIMIT 3",374 "context": "CREATE TABLE publication (Publication_Date VARCHAR, Price VARCHAR)",375 "instruction": "List the publication dates of publications with 3 lowest prices."376 },377 {378 "response": "SELECT T1.Title, T2.Publication_Date FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID",379 "context": "CREATE TABLE book (Title VARCHAR, Book_ID VARCHAR); CREATE TABLE publication (Publication_Date VARCHAR, Book_ID VARCHAR)",380 "instruction": "Show the title and publication dates of books."381 },382 {383 "response": "SELECT Publication_Date FROM publication GROUP BY Publication_Date ORDER BY COUNT(*) DESC LIMIT 1",384 "context": "CREATE TABLE publication (Publication_Date VARCHAR)",385 "instruction": "Please show the most common publication date."386 },387 {388 "response": "SELECT date FROM table_name_73 WHERE attendance = \"9,535\"",389 "context": "CREATE TABLE table_name_73 (date VARCHAR, attendance VARCHAR)",390 "instruction": "Which Date has an Attendance of 9,535?"391 },392 {393 "response": "SELECT COUNT(commentator) FROM table_184803_4 WHERE broadcaster = \"ORF\"",394 "context": "CREATE TABLE table_184803_4 (commentator VARCHAR, broadcaster VARCHAR)",395 "instruction": "how many people commentated where broadcaster is orf"396 },397 {398 "response": "SELECT team FROM table_name_96 WHERE high_rebounds = \"smith (10)\"",399 "context": "CREATE TABLE table_name_96 (team VARCHAR, high_rebounds VARCHAR)",400 "instruction": "Name the team which has high rebounds of smith (10)"401 },402 {403 "response": "SELECT broadcast_date FROM table_1849243_1 WHERE archive = \"16mm t/r\"",404 "context": "CREATE TABLE table_1849243_1 (broadcast_date VARCHAR, archive VARCHAR)",405 "instruction": "What is the broadcast date of the 16mm t/r episode?"406 },407 {408 "response": "SELECT tyre FROM table_name_51 WHERE rounds = \"14-15\" AND engine = \"ford cosworth dfv 3.0 v8\" AND chassis = \"m23\"",409 "context": "CREATE TABLE table_name_51 (tyre VARCHAR, chassis VARCHAR, rounds VARCHAR, engine VARCHAR)",410 "instruction": "When the engine Ford Cosworth DFV 3.0 v8 has a chassis of m23 and in rounds 14-15, what is its Tyre?"411 },412 {413 "response": "SELECT el_canal_de_las_estrellas FROM table_18498743_1 WHERE ma\u00f1ana_es_para_siempre = \"Impreuna pentru totdeauna\"",414 "context": "CREATE TABLE table_18498743_1 (el_canal_de_las_estrellas VARCHAR, ma\u00f1ana_es_para_siempre VARCHAR)",415 "instruction": "state el canal de las estrellas where ma\u00f1ana es para siempre is impreuna pentru totdeauna"416 },417 {418 "response": "SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID ORDER BY T2.Year DESC",419 "context": "CREATE TABLE musical (Musical_ID VARCHAR, Year VARCHAR); CREATE TABLE actor (Name VARCHAR, Musical_ID VARCHAR)",420 "instruction": "Show names of actors in descending order of the year their musical is awarded."421 },422 {423 "response": "SELECT series FROM table_name_73 WHERE visitor = \"vancouver\" AND date = \"april 16\"",424 "context": "CREATE TABLE table_name_73 (series VARCHAR, visitor VARCHAR, date VARCHAR)",425 "instruction": "What is the series score of the game with Vancouver as the visiting team on April 16?"426 },427 {428 "response": "SELECT other FROM table_1850282_7 WHERE species = \"Chironius multiventris septentrionalis\"",429 "context": "CREATE TABLE table_1850282_7 (other VARCHAR, species VARCHAR)",430 "instruction": "Name the other for chironius multiventris septentrionalis"431 },432 {433 "response": "SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID WHERE T2.Name = \"The Phantom of the Opera\"",434 "context": "CREATE TABLE actor (Name VARCHAR, Musical_ID VARCHAR); CREATE TABLE musical (Musical_ID VARCHAR, Name VARCHAR)",435 "instruction": "Show names of actors that have appeared in musical with name \"The Phantom of the Opera\"."436 },437 {438 "response": "SELECT mexico FROM table_18498743_1 WHERE ma\u00f1ana_es_para_siempre = \"Love Never Dies\"",439 "context": "CREATE TABLE table_18498743_1 (mexico VARCHAR, ma\u00f1ana_es_para_siempre VARCHAR)",440 "instruction": "what is the mexico stat where ma\u00f1ana es para siempre is love never dies"441 },442 {443 "response": "SELECT COUNT(season) FROM table_1850339_2 WHERE army___navy_score = \"10 Dec. 2016 at Baltimore, MD (M&T Bank Stadium)\"",444 "context": "CREATE TABLE table_1850339_2 (season VARCHAR, army___navy_score VARCHAR)",445 "instruction": "How many different season have an Army - Navy score of 10 dec. 2016 at Baltimore, MD (M&T Bank Stadium)?"446 },447 {448 "response": "SELECT MIN(crowd) FROM table_name_79 WHERE home_team = \"richmond\"",449 "context": "CREATE TABLE table_name_79 (crowd INTEGER, home_team VARCHAR)",450 "instruction": "What is the lowest crowd with home team richmond?"451 },452 {453 "response": "SELECT COUNT(tourism_receipts__2003___as__percentage_of_exports_) FROM table_18524_6 WHERE tourism_competitiveness__2011___ttci_ = \"3.26\"",454 "context": "CREATE TABLE table_18524_6 (tourism_receipts__2003___as__percentage_of_exports_ VARCHAR, tourism_competitiveness__2011___ttci_ VARCHAR)",455 "instruction": "Name the tourism receipts 2003 for tourism competitiveness 3.26"456 },457 {458 "response": "SELECT COUNT(tourism_receipts__2011___us) AS $_per_capita_ FROM table_18524_6 WHERE tourism_receipts__2003___as__percentage_of_gdp_ = \"13.5\"",459 "context": "CREATE TABLE table_18524_6 (tourism_receipts__2011___us VARCHAR, tourism_receipts__2003___as__percentage_of_gdp_ VARCHAR)",460 "instruction": "Name the total number of tourism receipts 2011 where tourism receipts 2003 13.5"461 },462 {463 "response": "SELECT object_type FROM table_name_56 WHERE apparent_magnitude > 9.6 AND right_ascension___j2000__ = \"17h59m02.0s\"",464 "context": "CREATE TABLE table_name_56 (object_type VARCHAR, apparent_magnitude VARCHAR, right_ascension___j2000__ VARCHAR)",465 "instruction": "Which object has an Apparent magnitude larger than 9.6, and a Right ascension ( J2000 ) of 17h59m02.0s?"466 },467 {468 "response": "SELECT name FROM user_profiles WHERE email LIKE '%superstar%' OR email LIKE '%edu%'",469 "context": "CREATE TABLE user_profiles (name VARCHAR, email VARCHAR)",470 "instruction": "Find the names of users whose emails contain \u2018superstar\u2019 or \u2018edu\u2019."471 },472 {473 "response": "SELECT date_of_vacancy FROM table_18522916_5 WHERE outgoing_manager = \"Daniel Uberti\"",474 "context": "CREATE TABLE table_18522916_5 (date_of_vacancy VARCHAR, outgoing_manager VARCHAR)",475 "instruction": "Name the date of vacancy for daniel uberti"476 },477 {478 "response": "SELECT AVG(rank) FROM table_name_45 WHERE NOT percentage = \"56%\" AND loss < 4",479 "context": "CREATE TABLE table_name_45 (rank INTEGER, loss VARCHAR, percentage VARCHAR)",480 "instruction": "What's the rank for a team that has a percentage of 56% and a loss smaller than 4?"481 },482 {483 "response": "SELECT T1.name FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid = T2.f1 GROUP BY T2.f1 HAVING COUNT(*) > (SELECT COUNT(*) FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid = T2.f1 WHERE T1.name = 'Tyler Swift')",484 "context": "CREATE TABLE follows (f1 VARCHAR); CREATE TABLE user_profiles (name VARCHAR, uid VARCHAR)",485 "instruction": "Find the names of the users whose number of followers is greater than that of the user named \"Tyler Swift\"."486 },487 {488 "response": "SELECT T1.name, T1.email FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid = T2.f1 GROUP BY T2.f1 HAVING COUNT(*) > 1",489 "context": "CREATE TABLE follows (f1 VARCHAR); CREATE TABLE user_profiles (name VARCHAR, email VARCHAR, uid VARCHAR)",490 "instruction": "Find the name and email for the users who have more than one follower."491 },492 {493 "response": "SELECT team FROM table_name_8 WHERE make = \"buick regal\" AND driver = \"bobby hillin jr. (r)\"",494 "context": "CREATE TABLE table_name_8 (team VARCHAR, make VARCHAR, driver VARCHAR)",495 "instruction": "What team does bobby hillin jr. (r) drive a buick regal for?"496 },497 {498 "response": "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\"",499 "context": "CREATE TABLE follows (f1 VARCHAR, f2 VARCHAR); CREATE TABLE user_profiles (uid VARCHAR, name VARCHAR)",500 "instruction": "Find the id of users who are followed by Mary and Susan."501 },502 {503 "response": "SELECT T2.f1 FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid = T2.f2 WHERE T1.name = \"Mary\" OR T1.name = \"Susan\"",504 "context": "CREATE TABLE follows (f1 VARCHAR, f2 VARCHAR); CREATE TABLE user_profiles (uid VARCHAR, name VARCHAR)",505 "instruction": "Find the id of users who are followed by Mary or Susan."506 },507 {508 "response": "SELECT votes_given FROM table_1855841_1 WHERE running_with__in_team_ = \"Michael Russo, Genevy Dimitrion , Manny Ortega\"",509 "context": "CREATE TABLE table_1855841_1 (votes_given VARCHAR, running_with__in_team_ VARCHAR)",510 "instruction": "Name the votes given for michael russo, genevy dimitrion , manny ortega"511 },512 {513 "response": "SELECT MAX(grid) FROM table_name_99 WHERE constructor = \"mclaren - mercedes\" AND driver = \"david coulthard\" AND laps < 66",514 "context": "CREATE TABLE table_name_99 (grid INTEGER, laps VARCHAR, constructor VARCHAR, driver VARCHAR)",515 "instruction": "What is the highest grid value with constructor Mclaren - Mercedes, driver David Coulthard, and has fewer than 66 laps?"516 },517 {518 "response": "SELECT T1.name, COUNT(*) FROM user_profiles AS T1 JOIN tweets AS T2 ON T1.uid = T2.uid GROUP BY T2.uid HAVING COUNT(*) > 1",519 "context": "CREATE TABLE tweets (uid VARCHAR); CREATE TABLE user_profiles (name VARCHAR, uid VARCHAR)",520 "instruction": "Find the name of the user who tweeted more than once, and number of tweets tweeted by them."521 },522 {523 "response": "SELECT new_entries_this_round FROM table_1859269_1 WHERE round = \"Semi-finals\"",524 "context": "CREATE TABLE table_1859269_1 (new_entries_this_round VARCHAR, round VARCHAR)",525 "instruction": "If the round is the semi-finals, what are the new entries this round?"526 },527 {528 "response": "SELECT attribute_data_type FROM Attribute_Definitions GROUP BY attribute_data_type HAVING COUNT(*) > 3",529 "context": "CREATE TABLE Attribute_Definitions (attribute_data_type VARCHAR)",530 "instruction": "Find the list of attribute data types possessed by more than 3 attribute definitions."531 },532 {533 "response": "SELECT catalog_level_name, catalog_level_number FROM Catalog_Structure WHERE catalog_level_number BETWEEN 5 AND 10",534 "context": "CREATE TABLE Catalog_Structure (catalog_level_name VARCHAR, catalog_level_number INTEGER)",535 "instruction": "Find the name and level of catalog structure with level between 5 and 10."536 },537 {538 "response": "SELECT away_team AS score FROM table_name_42 WHERE venue = \"corio oval\"",539 "context": "CREATE TABLE table_name_42 (away_team VARCHAR, venue VARCHAR)",540 "instruction": "What was the away team score at Corio Oval?"541 },542 {543 "response": "SELECT catalog_publisher FROM catalogs GROUP BY catalog_publisher ORDER BY COUNT(*) DESC LIMIT 1",544 "context": "CREATE TABLE catalogs (catalog_publisher VARCHAR)",545 "instruction": "Which catalog publisher has published the most catalogs?"546 },547 {548 "response": "SELECT t1.catalog_entry_name FROM Catalog_Contents AS t1 JOIN Catalog_Contents_Additional_Attributes AS t2 ON t1.catalog_entry_id = t2.catalog_entry_id WHERE t2.attribute_value = (SELECT attribute_value FROM Catalog_Contents_Additional_Attributes GROUP BY attribute_value ORDER BY COUNT(*) DESC LIMIT 1)",549 "context": "CREATE TABLE Catalog_Contents_Additional_Attributes (catalog_entry_id VARCHAR, attribute_value VARCHAR); CREATE TABLE Catalog_Contents (catalog_entry_name VARCHAR, catalog_entry_id VARCHAR); CREATE TABLE Catalog_Contents_Additional_Attributes (attribute_value VARCHAR)",550 "instruction": "What are the entry names of catalog with the attribute possessed by most entries."551 },552 {553 "response": "SELECT t1.catalog_entry_name FROM Catalog_Contents AS t1 JOIN Catalog_Contents_Additional_Attributes AS t2 ON t1.catalog_entry_id = t2.catalog_entry_id WHERE t2.catalog_level_number = \"8\"",554 "context": "CREATE TABLE Catalog_Contents_Additional_Attributes (catalog_entry_id VARCHAR, catalog_level_number VARCHAR); CREATE TABLE Catalog_Contents (catalog_entry_name VARCHAR, catalog_entry_id VARCHAR)",555 "instruction": "Find the names of catalog entries with level number 8."556 },557 {558 "response": "SELECT t1.attribute_name, t1.attribute_id FROM Attribute_Definitions AS t1 JOIN Catalog_Contents_Additional_Attributes AS t2 ON t1.attribute_id = t2.attribute_id WHERE t2.attribute_value = 0",559 "context": "CREATE TABLE Catalog_Contents_Additional_Attributes (attribute_id VARCHAR, attribute_value VARCHAR); CREATE TABLE Attribute_Definitions (attribute_name VARCHAR, attribute_id VARCHAR)",560 "instruction": "Find the name and attribute ID of the attribute definitions with attribute value 0."561 },562 {563 "response": "SELECT date_of_latest_revision FROM Catalogs GROUP BY date_of_latest_revision HAVING COUNT(*) > 1",564 "context": "CREATE TABLE Catalogs (date_of_latest_revision VARCHAR)",565 "instruction": "Find the dates on which more than one revisions were made."566 },567 {568 "response": "SELECT township FROM table_18600760_12 WHERE longitude = \"-98.741656\"",569 "context": "CREATE TABLE table_18600760_12 (township VARCHAR, longitude VARCHAR)",570 "instruction": "Which township has a longitude of -98.741656?"571 },572 {573 "response": "SELECT COUNT(ansi_code) FROM table_18600760_13 WHERE latitude = \"48.247662\"",574 "context": "CREATE TABLE table_18600760_13 (ansi_code VARCHAR, latitude VARCHAR)",575 "instruction": "How many places associated with latitude 48.247662?"576 },577 {578 "response": "SELECT end_date FROM table_name_8 WHERE governor = \"richard j. oglesby\" AND term = \"1885\u20131889\"",579 "context": "CREATE TABLE table_name_8 (end_date VARCHAR, governor VARCHAR, term VARCHAR)",580 "instruction": "What is the end date of the term for Governor of richard j. oglesby, and a Term of 1885\u20131889?"581 },582 {583 "response": "SELECT site FROM table_name_5 WHERE orbit = \"leo\" AND decay___utc__ = \"still in orbit\" AND function = \"magnetosphere research\"",584 "context": "CREATE TABLE table_name_5 (site VARCHAR, function VARCHAR, orbit VARCHAR, decay___utc__ VARCHAR)",585 "instruction": "What site has an orbit of Leo, a decay (UTC) of still in orbit, and a magnetosphere research?"586 },587 {588 "response": "SELECT date_and_time___utc__ FROM table_name_23 WHERE orbit = \"sub-orbital\" AND function = \"aeronomy research\" AND rocket = \"nike orion\" AND site = \"poker flat\"",589 "context": "CREATE TABLE table_name_23 (date_and_time___utc__ VARCHAR, site VARCHAR, rocket VARCHAR, orbit VARCHAR, function VARCHAR)",590 "instruction": "What date and time has a sub-orbital of orbit, a function of aeronomy research, and a Nike Orion rocket, as well as a Poker Flat site?"591 },592 {593 "response": "SELECT runner_up FROM table_name_26 WHERE winning_score = \u221216(68 - 70 - 65 - 65 = 268)",594 "context": "CREATE TABLE table_name_26 (runner_up VARCHAR, winning_score VARCHAR)",595 "instruction": "who is the runner-up when the winning score is \u221216 (68-70-65-65=268)?"596 },597 {598 "response": "SELECT departure_date, arrival_date FROM Flight WHERE origin = \"Los Angeles\" AND destination = \"Honolulu\"",599 "context": "CREATE TABLE Flight (departure_date VARCHAR, arrival_date VARCHAR, origin VARCHAR, destination VARCHAR)",600 "instruction": "Show me the departure date and arrival date for all flights from Los Angeles to Honolulu."601 },602 {603 "response": "SELECT final__bronze_medal_match FROM table_18602462_21 WHERE quarterfinals = \"Houdet ( FRA ) W 6-2, 6-1\"",604 "context": "CREATE TABLE table_18602462_21 (final__bronze_medal_match VARCHAR, quarterfinals VARCHAR)",605 "instruction": "When houdet ( fra ) w 6-2, 6-1 is the quarterfinals what is the final/bronze medal match?"606 },607 {608 "response": "SELECT final__bronze_medal_match FROM table_18602462_21 WHERE event = \"Mixed Quad Singles\"",609 "context": "CREATE TABLE table_18602462_21 (final__bronze_medal_match VARCHAR, event VARCHAR)",610 "instruction": "When mixed quad singles is the event what is the final/bronze medal match?"611 },612 {613 "response": "SELECT T1.flno FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.aid = T2.aid WHERE T2.name = \"Airbus A340-300\"",614 "context": "CREATE TABLE Flight (flno VARCHAR, aid VARCHAR); CREATE TABLE Aircraft (aid VARCHAR, name VARCHAR)",615 "instruction": "Show all flight numbers with aircraft Airbus A340-300."616 },617 {618 "response": "SELECT COUNT(round_of_32) FROM table_18602462_22 WHERE round_of_16 = \"Polidori ( ITA ) W 6-1, 3-6, 6-3\"",619 "context": "CREATE TABLE table_18602462_22 (round_of_32 VARCHAR, round_of_16 VARCHAR)",620 "instruction": "How many round of 32 results are followed by Polidori ( Ita ) w 6-1, 3-6, 6-3 in the round of 16?"621 },622 {623 "response": "SELECT T2.name FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.aid = T2.aid GROUP BY T1.aid HAVING COUNT(*) >= 2",624 "context": "CREATE TABLE Aircraft (name VARCHAR, aid VARCHAR); CREATE TABLE Flight (aid VARCHAR)",625 "instruction": "Show names for all aircraft with at least two flights."626 },627 {628 "response": "SELECT MIN(rank) FROM table_name_59 WHERE country = \"united states\" AND wins < 3",629 "context": "CREATE TABLE table_name_59 (rank INTEGER, country VARCHAR, wins VARCHAR)",630 "instruction": "Who is the lowest ranked player from the United States that has less than 3 Wins?"631 },632 {633 "response": "SELECT T3.name FROM Employee AS T1 JOIN Certificate AS T2 ON T1.eid = T2.eid JOIN Aircraft AS T3 ON T3.aid = T2.aid WHERE T1.name = \"John Williams\"",634 "context": "CREATE TABLE Aircraft (name VARCHAR, aid VARCHAR); CREATE TABLE Employee (eid VARCHAR, name VARCHAR); CREATE TABLE Certificate (eid VARCHAR, aid VARCHAR)",635 "instruction": "Show names for all aircrafts of which John Williams has certificates."636 },637 {638 "response": "SELECT score FROM table_name_93 WHERE visitor = \"edmonton\"",639 "context": "CREATE TABLE table_name_93 (score VARCHAR, visitor VARCHAR)",640 "instruction": "What is the score of the game that had a visiting team of Edmonton?"641 },642 {643 "response": "SELECT T1.name FROM Employee AS T1 JOIN Certificate AS T2 ON T1.eid = T2.eid JOIN Aircraft AS T3 ON T3.aid = T2.aid WHERE T3.name = \"Boeing 737-800\" INTERSECT SELECT T1.name FROM Employee AS T1 JOIN Certificate AS T2 ON T1.eid = T2.eid JOIN Aircraft AS T3 ON T3.aid = T2.aid WHERE T3.name = \"Airbus A340-300\"",644 "context": "CREATE TABLE Employee (name VARCHAR, eid VARCHAR); CREATE TABLE Certificate (eid VARCHAR, aid VARCHAR); CREATE TABLE Aircraft (aid VARCHAR, name VARCHAR)",645 "instruction": "Show names for all employees who have certificates on both Boeing 737-800 and Airbus A340-300."646 },647 {648 "response": "SELECT name FROM Employee EXCEPT SELECT T1.name FROM Employee AS T1 JOIN Certificate AS T2 ON T1.eid = T2.eid JOIN Aircraft AS T3 ON T3.aid = T2.aid WHERE T3.name = \"Boeing 737-800\"",649 "context": "CREATE TABLE Certificate (eid VARCHAR, aid VARCHAR); CREATE TABLE Employee (name VARCHAR, eid VARCHAR); CREATE TABLE Employee (name VARCHAR); CREATE TABLE Aircraft (aid VARCHAR, name VARCHAR)",650 "instruction": "Show names for all employees who do not have certificate of Boeing 737-800."651 },652 {653 "response": "SELECT T1.name, T1.salary FROM Employee AS T1 JOIN Certificate AS T2 ON T1.eid = T2.eid GROUP BY T1.eid ORDER BY COUNT(*) DESC LIMIT 1",654 "context": "CREATE TABLE Certificate (eid VARCHAR); CREATE TABLE Employee (name VARCHAR, salary VARCHAR, eid VARCHAR)",655 "instruction": "what is the salary and name of the employee who has the most number of aircraft certificates?"656 },657 {658 "response": "SELECT T1.name FROM Employee AS T1 JOIN Certificate AS T2 ON T1.eid = T2.eid JOIN Aircraft AS T3 ON T3.aid = T2.aid WHERE T3.distance > 5000 GROUP BY T1.eid ORDER BY COUNT(*) DESC LIMIT 1",659 "context": "CREATE TABLE Aircraft (aid VARCHAR, distance INTEGER); CREATE TABLE Employee (name VARCHAR, eid VARCHAR); CREATE TABLE Certificate (eid VARCHAR, aid VARCHAR)",660 "instruction": "What is the salary and name of the employee who has the most number of certificates on aircrafts with distance more than 5000?"661 },662 {663 "response": "SELECT score FROM table_name_17 WHERE venue = \"hampden park\" AND runners_up = \"rangers\" AND winners = \"hibernian\"",664 "context": "CREATE TABLE table_name_17 (score VARCHAR, winners VARCHAR, venue VARCHAR, runners_up VARCHAR)",665 "instruction": "What is the Score of the Rangers' Runner-ups and Hibernian Winners in Hampden Park?"666 },667 {668 "response": "SELECT runners_up FROM table_name_75 WHERE venue = \"broadwood stadium\"",669 "context": "CREATE TABLE table_name_75 (runners_up VARCHAR, venue VARCHAR)",670 "instruction": "What Runners-up have a Venue in Broadwood Stadium?"671 },672 {673 "response": "SELECT actor_actress FROM table_18638067_1 WHERE film_title_used_in_nomination = \"Mrs. Miniver\"",674 "context": "CREATE TABLE table_18638067_1 (actor_actress VARCHAR, film_title_used_in_nomination VARCHAR)",675 "instruction": "In the film Mrs. Miniver, what is the actresses name?"676 },677 {678 "response": "SELECT year__ceremony_ FROM table_18638067_1 WHERE actor_actress = \"Teresa Wright\" AND category = \"Best Supporting Actress\"",679 "context": "CREATE TABLE table_18638067_1 (year__ceremony_ VARCHAR, actor_actress VARCHAR, category VARCHAR)",680 "instruction": "What year was Teresa Wright nominated best supporting actress?"681 },682 {683 "response": "SELECT actor_actress FROM table_18638067_1 WHERE film_title_used_in_nomination = \"Going My Way\" AND category = \"Best Supporting Actor\"",684 "context": "CREATE TABLE table_18638067_1 (actor_actress VARCHAR, film_title_used_in_nomination VARCHAR, category VARCHAR)",685 "instruction": "Who was nominated for best supporting actor in the movie Going My Way?"686 },687 {688 "response": "SELECT SUM(ave__no) FROM table_name_98 WHERE name = \"albula alps\" AND height__m_ > 3418",689 "context": "CREATE TABLE table_name_98 (ave__no INTEGER, name VARCHAR, height__m_ VARCHAR)",690 "instruction": "Which sum of AVE-No has a Name of albula alps, and a Height (m) larger than 3418?"691 },692 {693 "response": "SELECT MIN(height__m_) FROM table_name_97 WHERE name = \"plessur alps\" AND ave__no > 63",694 "context": "CREATE TABLE table_name_97 (height__m_ INTEGER, name VARCHAR, ave__no VARCHAR)",695 "instruction": "Which Height (m) has a Name of plessur alps, and a AVE-No larger than 63?"696 },697 {698 "response": "SELECT winning_driver FROM table_name_13 WHERE fastest_lap = \"michael schumacher\" AND constructor = \"ferrari\" AND pole_position = \"jenson button\"",699 "context": "CREATE TABLE table_name_13 (winning_driver VARCHAR, pole_position VARCHAR, fastest_lap VARCHAR, constructor VARCHAR)",700 "instruction": "Who was the winning driver when pole position was jenson button, the fastest lap was michael schumacher and the car was ferrari?"701 },702 {703 "response": "SELECT category FROM table_name_76 WHERE event_name = \"touchdown atlantic\"",704 "context": "CREATE TABLE table_name_76 (category VARCHAR, event_name VARCHAR)",705 "instruction": "What is the category of the touchdown atlantic?"706 },707 {708 "response": "SELECT leagues FROM table_18686317_1 WHERE comp__percentage = \"54.0\"",709 "context": "CREATE TABLE table_18686317_1 (leagues VARCHAR, comp__percentage VARCHAR)",710 "instruction": "In which league would you find the player with a comp percentage of 54.0?"711 },712 {713 "response": "SELECT total_team_penalties FROM table_18666752_3 WHERE cross_country_penalties = \"30.40\"",714 "context": "CREATE TABLE table_18666752_3 (total_team_penalties VARCHAR, cross_country_penalties VARCHAR)",715 "instruction": "How many total team penalties are there when cross country penalties is 30.40?"716 },717 {718 "response": "SELECT AVG(age), sex FROM Student GROUP BY sex",719 "context": "CREATE TABLE Student (sex VARCHAR, age INTEGER)",720 "instruction": "Show the average age for male and female students."721 },722 {723 "response": "SELECT MIN(laps) FROM table_name_65 WHERE grid < 4 AND driver = \"juan pablo montoya\"",724 "context": "CREATE TABLE table_name_65 (laps INTEGER, grid VARCHAR, driver VARCHAR)",725 "instruction": "What is the low lap total for the under 4 grid car driven by juan pablo montoya?"726 },727 {728 "response": "SELECT COUNT(*) FROM has_allergy AS T1 JOIN Student AS T2 ON T1.StuID = T2.StuID WHERE T2.sex = \"F\" AND T1.allergy = \"Milk\" OR T1.allergy = \"Eggs\"",729 "context": "CREATE TABLE Student (StuID VARCHAR, sex VARCHAR); CREATE TABLE has_allergy (StuID VARCHAR, allergy VARCHAR)",730 "instruction": "How many female students have milk or egg allergies?"731 },732 {733 "response": "SELECT batting_style FROM table_name_32 WHERE bowling_style = \"right arm medium\" AND player = \"stuart williams\"",734 "context": "CREATE TABLE table_name_32 (batting_style VARCHAR, bowling_style VARCHAR, player VARCHAR)",735 "instruction": "What batting style corresponds to a bowling style of right arm medium for Stuart Williams?"736 },737 {738 "response": "SELECT T2.allergytype, COUNT(*) FROM Has_allergy AS T1 JOIN Allergy_type AS T2 ON T1.allergy = T2.allergy GROUP BY T2.allergytype",739 "context": "CREATE TABLE Has_allergy (allergy VARCHAR); CREATE TABLE Allergy_type (allergytype VARCHAR, allergy VARCHAR)",740 "instruction": "Show all allergy type with number of students affected."741 },742 {743 "response": "SELECT lname, age FROM Student WHERE StuID IN (SELECT StuID FROM Has_allergy WHERE Allergy = \"Milk\" INTERSECT SELECT StuID FROM Has_allergy WHERE Allergy = \"Cat\")",744 "context": "CREATE TABLE Has_allergy (lname VARCHAR, age VARCHAR, StuID VARCHAR, Allergy VARCHAR); CREATE TABLE Student (lname VARCHAR, age VARCHAR, StuID VARCHAR, Allergy VARCHAR)",745 "instruction": "Find the last name and age of the student who has allergy to both milk and cat."746 },747 {748 "response": "SELECT T1.Allergy, T1.AllergyType FROM Allergy_type AS T1 JOIN Has_allergy AS T2 ON T1.Allergy = T2.Allergy JOIN Student AS T3 ON T3.StuID = T2.StuID WHERE T3.Fname = \"Lisa\" ORDER BY T1.Allergy",749 "context": "CREATE TABLE Has_allergy (Allergy VARCHAR, StuID VARCHAR); CREATE TABLE Student (StuID VARCHAR, Fname VARCHAR); CREATE TABLE Allergy_type (Allergy VARCHAR, AllergyType VARCHAR)",750 "instruction": "What are the allergies and their types that the student with first name Lisa has? And order the result by name of allergies."751 },752 {753 "response": "SELECT school_club_team FROM table_name_53 WHERE nationality = \"united states\" AND position = \"guard\"",754 "context": "CREATE TABLE table_name_53 (school_club_team VARCHAR, nationality VARCHAR, position VARCHAR)",755 "instruction": "Tell me the School/Club team of the player from the United States that play'de guard?"756 },757 {758 "response": "SELECT AVG(age) FROM Student WHERE StuID IN (SELECT T1.StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = \"food\" INTERSECT SELECT T1.StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = \"animal\")",759 "context": "CREATE TABLE Student (age INTEGER, StuID VARCHAR); CREATE TABLE Allergy_Type (Allergy VARCHAR, allergytype VARCHAR); CREATE TABLE Has_allergy (StuID VARCHAR, Allergy VARCHAR)",760 "instruction": "Find the average age of the students who have allergies with food and animal types."761 },762 {763 "response": "SELECT fname, lname FROM Student WHERE NOT StuID IN (SELECT T1.StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = \"food\")",764 "context": "CREATE TABLE Student (fname VARCHAR, lname VARCHAR, StuID VARCHAR); CREATE TABLE Allergy_Type (Allergy VARCHAR, allergytype VARCHAR); CREATE TABLE Has_allergy (StuID VARCHAR, Allergy VARCHAR)",765 "instruction": "List the first and last name of the students who do not have any food type allergy."766 },767 {768 "response": "SELECT COUNT(*) FROM Student WHERE sex = \"M\" AND StuID IN (SELECT StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = \"food\")",769 "context": "CREATE TABLE Has_allergy (Allergy VARCHAR); CREATE TABLE Allergy_Type (Allergy VARCHAR, allergytype VARCHAR); CREATE TABLE Student (sex VARCHAR, StuID VARCHAR)",770 "instruction": "Find the number of male (sex is 'M') students who have some food type allery."771 },772 {773 "response": "SELECT DISTINCT T1.fname, T1.city_code FROM Student AS T1 JOIN Has_Allergy AS T2 ON T1.stuid = T2.stuid WHERE T2.Allergy = \"Milk\" OR T2.Allergy = \"Cat\"",774 "context": "CREATE TABLE Has_Allergy (stuid VARCHAR, Allergy VARCHAR); CREATE TABLE Student (fname VARCHAR, city_code VARCHAR, stuid VARCHAR)",775 "instruction": "Find the different first names and cities of the students who have allergy to milk or cat."776 },777 {778 "response": "SELECT COUNT(*) FROM Student WHERE age > 18 AND NOT StuID IN (SELECT StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = \"food\" OR T2.allergytype = \"animal\")",779 "context": "CREATE TABLE Allergy_Type (Allergy VARCHAR, allergytype VARCHAR); CREATE TABLE Has_allergy (Allergy VARCHAR); CREATE TABLE Student (age VARCHAR, StuID VARCHAR)",780 "instruction": "Find the number of students who are older than 18 and do not have allergy to either food or animal."781 },782 {783 "response": "SELECT level FROM table_name_21 WHERE season > 2003 AND division = \"kakkonen (second division)\" AND position = \"12th\"",784 "context": "CREATE TABLE table_name_21 (level VARCHAR, position VARCHAR, season VARCHAR, division VARCHAR)",785 "instruction": "What level for seasons after 2003, a Division of kakkonen (second division), and a Position of 12th?"786 },787 {788 "response": "SELECT billing_country, COUNT(*) FROM invoices GROUP BY billing_country ORDER BY COUNT(*) DESC LIMIT 5",789 "context": "CREATE TABLE invoices (billing_country VARCHAR)",790 "instruction": "A list of the top 5 countries by number of invoices. List country name and number of invoices."791 },792 {793 "response": "SELECT directed_by FROM table_18712423_3 WHERE written_by = \"Matt Ford\"",794 "context": "CREATE TABLE table_18712423_3 (directed_by VARCHAR, written_by VARCHAR)",795 "instruction": "Who directed the episode written by Matt Ford?"796 },797 {798 "response": "SELECT SUM(pl_gp) FROM table_name_44 WHERE pick__number < 122 AND player = \"rob flockhart\" AND rd__number < 3",799 "context": "CREATE TABLE table_name_44 (pl_gp INTEGER, rd__number VARCHAR, pick__number VARCHAR, player VARCHAR)",800 "instruction": "What is the PI GP of Rob Flockhart, who has a pick # less than 122 and a round # less than 3?"801 },802 {803 "response": "SELECT T1.first_name, T1.last_name, COUNT(*) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id = T1.id GROUP BY T1.id ORDER BY COUNT(*) DESC LIMIT 10",804 "context": "CREATE TABLE customers (first_name VARCHAR, last_name VARCHAR, id VARCHAR); CREATE TABLE invoices (customer_id VARCHAR)",805 "instruction": "Find out the top 10 customers by total number of orders. List customers' first and last name and the number of total orders."806 },807 {808 "response": "SELECT T1.first_name, T1.last_name, SUM(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id = T1.id GROUP BY T1.id ORDER BY SUM(T2.total) DESC LIMIT 10",809 "context": "CREATE TABLE invoices (total INTEGER, customer_id VARCHAR); CREATE TABLE customers (first_name VARCHAR, last_name VARCHAR, id VARCHAR)",810 "instruction": "List the top 10 customers by total gross sales. List customers' first and last name and total gross sales."811 },812 {813 "response": "SELECT T1.name, COUNT(*) FROM genres AS T1 JOIN tracks AS T2 ON T2.genre_id = T1.id GROUP BY T1.id ORDER BY COUNT(*) DESC LIMIT 5",814 "context": "CREATE TABLE tracks (genre_id VARCHAR); CREATE TABLE genres (name VARCHAR, id VARCHAR)",815 "instruction": "List the top 5 genres by number of tracks. List genres name and total tracks."816 },817 {818 "response": "SELECT safari FROM table_1876262_10 WHERE internet_explorer = \"47.22%\"",819 "context": "CREATE TABLE table_1876262_10 (safari VARCHAR, internet_explorer VARCHAR)",820 "instruction": "If Internet Explorer is 47.22%, what is the Safari total?"821 },822 {823 "response": "SELECT COUNT(no_in_series) FROM table_1876825_2 WHERE original_air_date = \"March 19, 2000\"",824 "context": "CREATE TABLE table_1876825_2 (no_in_series VARCHAR, original_air_date VARCHAR)",825 "instruction": "Name the total number of series for march 19, 2000"826 },827 {828 "response": "SELECT result FROM table_name_47 WHERE score = \"1\u20130\" AND competition = \"2014 fifa world cup qualification\"",829 "context": "CREATE TABLE table_name_47 (result VARCHAR, score VARCHAR, competition VARCHAR)",830 "instruction": "What result has a Score of 1\u20130, and a Competition of 2014 fifa world cup qualification?"831 },832 {833 "response": "SELECT date FROM table_name_26 WHERE competition = \"2014 fifa world cup qualification\" AND score = \"1\u20130\"",834 "context": "CREATE TABLE table_name_26 (date VARCHAR, competition VARCHAR, score VARCHAR)",835 "instruction": "What date was the Competition of 2014 fifa world cup qualification, with a Score of 1\u20130?"836 },837 {838 "response": "SELECT production_code FROM table_1876825_3 WHERE no_in_season = 6",839 "context": "CREATE TABLE table_1876825_3 (production_code VARCHAR, no_in_season VARCHAR)",840 "instruction": "What is the production code for episode 6 in the season?"841 },842 {843 "response": "SELECT company FROM customers WHERE first_name = \"Eduardo\" AND last_name = \"Martins\"",844 "context": "CREATE TABLE customers (company VARCHAR, first_name VARCHAR, last_name VARCHAR)",845 "instruction": "Eduardo Martins is a customer at which company?"846 },847 {848 "response": "SELECT email, phone FROM customers WHERE first_name = \"Astrid\" AND last_name = \"Gruber\"",849 "context": "CREATE TABLE customers (email VARCHAR, phone VARCHAR, first_name VARCHAR, last_name VARCHAR)",850 "instruction": "What is Astrid Gruber's email and phone number?"851 },852 {853 "response": "SELECT constellation FROM table_name_24 WHERE object_type = \"spiral galaxy\" AND ngc_number < 3593 AND right_ascension___j2000__ = \"11h05m48.9s\"",854 "context": "CREATE TABLE table_name_24 (constellation VARCHAR, right_ascension___j2000__ VARCHAR, object_type VARCHAR, ngc_number VARCHAR)",855 "instruction": "what is the constellation when the object type is spiral galaxy, the ngc number is less than 3593 and the right ascension (j2000) is 11h05m48.9s?"856 },857 {858 "response": "SELECT COUNT(*) FROM employees AS T1 JOIN customers AS T2 ON T2.support_rep_id = T1.id WHERE T1.first_name = \"Steve\" AND T1.last_name = \"Johnson\"",859 "context": "CREATE TABLE employees (id VARCHAR, first_name VARCHAR, last_name VARCHAR); CREATE TABLE customers (support_rep_id VARCHAR)",860 "instruction": "How many customers does Steve Johnson support?"861 },862 {863 "response": "SELECT T2.first_name, T2.last_name FROM employees AS T1 JOIN employees AS T2 ON T1.id = T2.reports_to WHERE T1.first_name = \"Nancy\" AND T1.last_name = \"Edwards\"",864 "context": "CREATE TABLE employees (id VARCHAR, first_name VARCHAR, last_name VARCHAR); CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, reports_to VARCHAR)",865 "instruction": "find the full name of employees who report to Nancy Edwards?"866 },867 {868 "response": "SELECT T1.first_name, T1.last_name FROM employees AS T1 JOIN customers AS T2 ON T1.id = T2.support_rep_id GROUP BY T1.id ORDER BY COUNT(*) DESC LIMIT 1",869 "context": "CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, id VARCHAR); CREATE TABLE customers (support_rep_id VARCHAR)",870 "instruction": "Find the full name of employee who supported the most number of customers."871 },872 {873 "response": "SELECT COUNT(*) FROM employees WHERE country = \"Canada\"",874 "context": "CREATE TABLE employees (country VARCHAR)",875 "instruction": "How many employees are living in Canada?"876 },877 {878 "response": "SELECT first_name, last_name FROM employees ORDER BY birth_date DESC LIMIT 1",879 "context": "CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, birth_date VARCHAR)",880 "instruction": "Who is the youngest employee in the company? List employee's first and last name."881 },882 {883 "response": "SELECT date FROM table_name_82 WHERE label = \"sony bmg, epic\" AND catalog = \"5187482\"",884 "context": "CREATE TABLE table_name_82 (date VARCHAR, label VARCHAR, catalog VARCHAR)",885 "instruction": "What is the date of the item with a label of Sony BMG, Epic and a Catalog number 5187482?"886 },887 {888 "response": "SELECT T2.first_name, T2.last_name, COUNT(T1.reports_to) FROM employees AS T1 JOIN employees AS T2 ON T1.reports_to = T2.id GROUP BY T1.reports_to ORDER BY COUNT(T1.reports_to) DESC LIMIT 1",889 "context": "CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, id VARCHAR); CREATE TABLE employees (reports_to VARCHAR)",890 "instruction": "Which employee manage most number of peoples? List employee's first and last name, and number of people report to that employee."891 },892 {893 "response": "SELECT COUNT(*) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = \"Lucas\" AND T1.last_name = \"Mancini\"",894 "context": "CREATE TABLE invoices (customer_id VARCHAR); CREATE TABLE customers (id VARCHAR, first_name VARCHAR, last_name VARCHAR)",895 "instruction": "How many orders does Lucas Mancini has?"896 },897 {898 "response": "SELECT nationality FROM table_name_28 WHERE school_club_team = \"la salle\"",899 "context": "CREATE TABLE table_name_28 (nationality VARCHAR, school_club_team VARCHAR)",900 "instruction": "What nationality is the la salle team?"901 },902 {903 "response": "SELECT date_of_appointment FROM table_18795125_6 WHERE position_in_table = \"23rd\"",904 "context": "CREATE TABLE table_18795125_6 (date_of_appointment VARCHAR, position_in_table VARCHAR)",905 "instruction": "What was the date of appointment for the manager of the 23rd team?"906 },907 {908 "response": "SELECT country FROM table_18821196_1 WHERE tv_network_s_ = \"AXN India\"",909 "context": "CREATE TABLE table_18821196_1 (country VARCHAR, tv_network_s_ VARCHAR)",910 "instruction": "What is every country with a TV network of AXN India?"911 },912 {913 "response": "SELECT T1.title FROM albums AS T1 JOIN tracks AS T2 ON T1.id = T2.album_id GROUP BY T1.id HAVING COUNT(T1.id) > 10",914 "context": "CREATE TABLE tracks (album_id VARCHAR); CREATE TABLE albums (title VARCHAR, id VARCHAR)",915 "instruction": "List title of albums have the number of tracks greater than 10."916 },917 {918 "response": "SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id JOIN media_types AS T3 ON T3.id = T2.media_type_id WHERE T1.name = \"Rock\" AND T3.name = \"MPEG audio file\"",919 "context": "CREATE TABLE genres (id VARCHAR, name VARCHAR); CREATE TABLE tracks (name VARCHAR, genre_id VARCHAR, media_type_id VARCHAR); CREATE TABLE media_types (id VARCHAR, name VARCHAR)",920 "instruction": "List the name of tracks belongs to genre Rock and whose media type is MPEG audio file."921 },922 {923 "response": "SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id JOIN media_types AS T3 ON T3.id = T2.media_type_id WHERE T1.name = \"Rock\" OR T3.name = \"MPEG audio file\"",924 "context": "CREATE TABLE genres (id VARCHAR, name VARCHAR); CREATE TABLE tracks (name VARCHAR, genre_id VARCHAR, media_type_id VARCHAR); CREATE TABLE media_types (id VARCHAR, name VARCHAR)",925 "instruction": "List the name of tracks belongs to genre Rock or media type is MPEG audio file."926 },927 {928 "response": "SELECT prize_fund FROM table_18828487_1 WHERE venue = \"RWE-Sporthalle, M\u00fclheim\"",929 "context": "CREATE TABLE table_18828487_1 (prize_fund VARCHAR, venue VARCHAR)",930 "instruction": "How much was the prize money for rwe-sporthalle, m\u00fclheim ?"931 },932 {933 "response": "SELECT status FROM table_18821196_1 WHERE weekly_schedule = \"Monday to Thursday @ 11:00 pm\"",934 "context": "CREATE TABLE table_18821196_1 (status VARCHAR, weekly_schedule VARCHAR)",935 "instruction": "What is every status with a weekly schedule of Monday to Thursday @ 11:00 pm?"936 },937 {938 "response": "SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id = T2.track_id JOIN playlists AS T3 ON T3.id = T2.playlist_id WHERE T3.name = \"Movies\"",939 "context": "CREATE TABLE playlists (id VARCHAR, name VARCHAR); CREATE TABLE playlist_tracks (track_id VARCHAR, playlist_id VARCHAR); CREATE TABLE tracks (name VARCHAR, id VARCHAR)",940 "instruction": "List the name of all tracks in the playlists of Movies."941 },942 {943 "response": "SELECT T1.name FROM tracks AS T1 JOIN invoice_lines AS T2 ON T1.id = T2.track_id JOIN invoices AS T3 ON T3.id = T2.invoice_id JOIN customers AS T4 ON T4.id = T3.customer_id WHERE T4.first_name = \"Daan\" AND T4.last_name = \"Peeters\"",944 "context": "CREATE TABLE invoices (id VARCHAR, customer_id VARCHAR); CREATE TABLE invoice_lines (track_id VARCHAR, invoice_id VARCHAR); CREATE TABLE tracks (name VARCHAR, id VARCHAR); CREATE TABLE customers (id VARCHAR, first_name VARCHAR, last_name VARCHAR)",945 "instruction": "List all tracks bought by customer Daan Peeters."946 },947 {948 "response": "SELECT l2_cache FROM table_18823880_10 WHERE release_date = \"September 2009\" AND part_number_s_ = \"BY80607002529AF\"",949 "context": "CREATE TABLE table_18823880_10 (l2_cache VARCHAR, release_date VARCHAR, part_number_s_ VARCHAR)",950 "instruction": "When by80607002529af is the part number and september 2009 is the release date what is the l2 cache?"951 },952 {953 "response": "SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id = T2.track_id JOIN playlists AS T3 ON T2.playlist_id = T3.id WHERE T3.name = 'Movies' EXCEPT SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id = T2.track_id JOIN playlists AS T3 ON T2.playlist_id = T3.id WHERE T3.name = 'Music'",954 "context": "CREATE TABLE playlists (id VARCHAR, name VARCHAR); CREATE TABLE playlist_tracks (track_id VARCHAR, playlist_id VARCHAR); CREATE TABLE tracks (name VARCHAR, id VARCHAR)",955 "instruction": "Find the name of tracks which are in Movies playlist but not in music playlist."956 },957 {958 "response": "SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id = T2.track_id JOIN playlists AS T3 ON T2.playlist_id = T3.id WHERE T3.name = 'Movies' INTERSECT SELECT T1.name FROM tracks AS T1 JOIN playlist_tracks AS T2 ON T1.id = T2.track_id JOIN playlists AS T3 ON T2.playlist_id = T3.id WHERE T3.name = 'Music'",959 "context": "CREATE TABLE playlists (id VARCHAR, name VARCHAR); CREATE TABLE playlist_tracks (track_id VARCHAR, playlist_id VARCHAR); CREATE TABLE tracks (name VARCHAR, id VARCHAR)",960 "instruction": "Find the name of tracks which are in both Movies and music playlists."961 },962 {963 "response": "SELECT COUNT(*), T1.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id GROUP BY T1.name",964 "context": "CREATE TABLE tracks (genre_id VARCHAR); CREATE TABLE genres (name VARCHAR, id VARCHAR)",965 "instruction": "Find number of tracks in each genre?"966 },967 {968 "response": "SELECT T2.name FROM playlist_tracks AS T1 JOIN playlists AS T2 ON T2.id = T1.playlist_id GROUP BY T1.playlist_id HAVING COUNT(T1.track_id) > 100",969 "context": "CREATE TABLE playlist_tracks (playlist_id VARCHAR, track_id VARCHAR); CREATE TABLE playlists (name VARCHAR, id VARCHAR)",970 "instruction": "List the name of playlist which has number of tracks greater than 100."971 },972 {973 "response": "SELECT away_team AS score FROM table_name_2 WHERE home_team = \"essendon\"",974 "context": "CREATE TABLE table_name_2 (away_team VARCHAR, home_team VARCHAR)",975 "instruction": "what is the away team score when the home team is essendon?"976 },977 {978 "response": "SELECT MIN(cr_no) FROM table_1886270_1",979 "context": "CREATE TABLE table_1886270_1 (cr_no INTEGER)",980 "instruction": "What is the lowest cr number?"981 },982 {983 "response": "SELECT T2.Name, T3.Theme FROM journal_committee AS T1 JOIN editor AS T2 ON T1.Editor_ID = T2.Editor_ID JOIN journal AS T3 ON T1.Journal_ID = T3.Journal_ID",984 "context": "CREATE TABLE journal_committee (Editor_ID VARCHAR, Journal_ID VARCHAR); CREATE TABLE editor (Name VARCHAR, Editor_ID VARCHAR); CREATE TABLE journal (Theme VARCHAR, Journal_ID VARCHAR)",985 "instruction": "Show the names of editors and the theme of journals for which they serve on committees."986 },987 {988 "response": "SELECT T2.Name, T2.age, T3.Theme FROM journal_committee AS T1 JOIN editor AS T2 ON T1.Editor_ID = T2.Editor_ID JOIN journal AS T3 ON T1.Journal_ID = T3.Journal_ID ORDER BY T3.Theme",989 "context": "CREATE TABLE journal_committee (Editor_ID VARCHAR, Journal_ID VARCHAR); CREATE TABLE editor (Name VARCHAR, age VARCHAR, Editor_ID VARCHAR); CREATE TABLE journal (Theme VARCHAR, Journal_ID VARCHAR)",990 "instruction": "Show the names and ages of editors and the theme of journals for which they serve on committees, in ascending alphabetical order of theme."991 },992 {993 "response": "SELECT T2.Name FROM journal_committee AS T1 JOIN editor AS T2 ON T1.Editor_ID = T2.Editor_ID JOIN journal AS T3 ON T1.Journal_ID = T3.Journal_ID WHERE T3.Sales > 3000",994 "context": "CREATE TABLE journal_committee (Editor_ID VARCHAR, Journal_ID VARCHAR); CREATE TABLE editor (Name VARCHAR, Editor_ID VARCHAR); CREATE TABLE journal (Journal_ID VARCHAR, Sales INTEGER)",995 "instruction": "Show the names of editors that are on the committee of journals with sales bigger than 3000."996 },997 {998 "response": "SELECT T1.editor_id, T1.Name, COUNT(*) FROM editor AS T1 JOIN journal_committee AS T2 ON T1.Editor_ID = T2.Editor_ID GROUP BY T1.editor_id",999 "context": "CREATE TABLE editor (editor_id VARCHAR, Name VARCHAR, Editor_ID VARCHAR); CREATE TABLE journal_committee (Editor_ID VARCHAR)",1000 "instruction": "Show the id, name of each editor and the number of journal committees they are on."1001 },1002 {1003 "response": "SELECT player FROM table_18862490_2 WHERE score = 64 - 70 - 67 - 69 = 270",1004 "context": "CREATE TABLE table_18862490_2 (player VARCHAR, score VARCHAR)",1005 "instruction": "What player(s) had the score of 64-70-67-69=270?"1006 },1007 {1008 "response": "SELECT date, theme, sales FROM journal EXCEPT SELECT T1.date, T1.theme, T1.sales FROM journal AS T1 JOIN journal_committee AS T2 ON T1.journal_ID = T2.journal_ID",1009 "context": "CREATE TABLE journal_committee (journal_ID VARCHAR); CREATE TABLE journal (date VARCHAR, theme VARCHAR, sales VARCHAR); CREATE TABLE journal (date VARCHAR, theme VARCHAR, sales VARCHAR, journal_ID VARCHAR)",1010 "instruction": "List the date, theme and sales of the journal which did not have any of the listed editors serving on committee."1011 },1012 {1013 "response": "SELECT AVG(T1.sales) FROM journal AS T1 JOIN journal_committee AS T2 ON T1.journal_ID = T2.journal_ID WHERE T2.work_type = 'Photo'",1014 "context": "CREATE TABLE journal_committee (journal_ID VARCHAR, work_type VARCHAR); CREATE TABLE journal (sales INTEGER, journal_ID VARCHAR)",1015 "instruction": "What is the average sales of the journals that have an editor whose work type is 'Photo'?"1016 },1017 {1018 "response": "SELECT MAX(ga) FROM table_1888157_1 WHERE gf = 39",1019 "context": "CREATE TABLE table_1888157_1 (ga INTEGER, gf VARCHAR)",1020 "instruction": "What is the highest GA when GF is 39?"1021 },1022 {1023 "response": "SELECT T2.customer_first_name, T2.customer_last_name, T2.customer_phone FROM Accounts AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T1.account_name = \"162\"",1024 "context": "CREATE TABLE Customers (customer_first_name VARCHAR, customer_last_name VARCHAR, customer_phone VARCHAR, customer_id VARCHAR); CREATE TABLE Accounts (customer_id VARCHAR, account_name VARCHAR)",1025 "instruction": "What is the first name, last name, and phone of the customer with account name 162?"1026 },1027 {1028 "response": "SELECT total_footage_remaining_from_missing_episodes__mm AS :ss_ FROM table_1889619_5 WHERE story_no = \"018\" AND source = \"Private individual\"",1029 "context": "CREATE TABLE table_1889619_5 (total_footage_remaining_from_missing_episodes__mm VARCHAR, story_no VARCHAR, source VARCHAR)",1030 "instruction": "When a private individual is the source and 018 is the story number what is the total footage remaining from missing episodes (mm:ss)?"1031 },1032 {1033 "response": "SELECT T2.customer_first_name, T2.customer_last_name, T1.customer_id FROM Accounts AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id GROUP BY T1.customer_id ORDER BY COUNT(*) LIMIT 1",1034 "context": "CREATE TABLE Accounts (customer_id VARCHAR); CREATE TABLE Customers (customer_first_name VARCHAR, customer_last_name VARCHAR, customer_id VARCHAR)",1035 "instruction": "What is the customer first, last name and id with least number of accounts."1036 },1037 {1038 "response": "SELECT customer_first_name, customer_last_name FROM Customers EXCEPT SELECT T1.customer_first_name, T1.customer_last_name FROM Customers AS T1 JOIN Accounts AS T2 ON T1.customer_id = T2.customer_id",1039 "context": "CREATE TABLE Accounts (customer_id VARCHAR); CREATE TABLE Customers (customer_first_name VARCHAR, customer_last_name VARCHAR, customer_id VARCHAR); CREATE TABLE Customers (customer_first_name VARCHAR, customer_last_name VARCHAR)",1040 "instruction": "Show the first names and last names of customers without any account."1041 },1042 {1043 "response": "SELECT high_rebounds FROM table_18894744_6 WHERE record = \"19-6\"",1044 "context": "CREATE TABLE table_18894744_6 (high_rebounds VARCHAR, record VARCHAR)",1045 "instruction": "Who did the high rebounds in the game with a 19-6 record?"1046 },1047 {1048 "response": "SELECT T2.customer_first_name, T2.customer_last_name, T2.customer_phone FROM Customers_cards AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T1.card_number = \"4560596484842\"",1049 "context": "CREATE TABLE Customers (customer_first_name VARCHAR, customer_last_name VARCHAR, customer_phone VARCHAR, customer_id VARCHAR); CREATE TABLE Customers_cards (customer_id VARCHAR, card_number VARCHAR)",1050 "instruction": "What is the first name, last name, and phone of the customer with card 4560596484842."1051 },1052 {1053 "response": "SELECT COUNT(*) FROM Customers_cards AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T2.customer_first_name = \"Art\" AND T2.customer_last_name = \"Turcotte\"",1054 "context": "CREATE TABLE Customers_cards (customer_id VARCHAR); CREATE TABLE Customers (customer_id VARCHAR, customer_first_name VARCHAR, customer_last_name VARCHAR)",1055 "instruction": "How many cards does customer Art Turcotte have?"1056 },1057 {1058 "response": "SELECT best FROM table_18914438_1 WHERE maidens = 547 AND overs = \"2755.1\"",1059 "context": "CREATE TABLE table_18914438_1 (best VARCHAR, maidens VARCHAR, overs VARCHAR)",1060 "instruction": "What is the Best score if the Maidens is 547 and Overs is 2755.1?"1061 },1062 {1063 "response": "SELECT COUNT(*) FROM Customers_cards AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T2.customer_first_name = \"Blanche\" AND T2.customer_last_name = \"Huels\" AND T1.card_type_code = \"Credit\"",1064 "context": "CREATE TABLE Customers_cards (customer_id VARCHAR, card_type_code VARCHAR); CREATE TABLE Customers (customer_id VARCHAR, customer_first_name VARCHAR, customer_last_name VARCHAR)",1065 "instruction": "How many credit cards does customer Blanche Huels have?"1066 },1067 {1068 "response": "SELECT customer_id, COUNT(*) FROM Customers_cards GROUP BY customer_id ORDER BY COUNT(*) DESC LIMIT 1",1069 "context": "CREATE TABLE Customers_cards (customer_id VARCHAR)",1070 "instruction": "What is the customer id with most number of cards, and how many does he have?"1071 },1072 {1073 "response": "SELECT T1.customer_id, T2.customer_first_name, T2.customer_last_name FROM Customers_cards AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id GROUP BY T1.customer_id HAVING COUNT(*) >= 2",1074 "context": "CREATE TABLE Customers_cards (customer_id VARCHAR); CREATE TABLE Customers (customer_first_name VARCHAR, customer_last_name VARCHAR, customer_id VARCHAR)",1075 "instruction": "Show id, first and last names for all customers with at least two cards."1076 },1077 {1078 "response": "SELECT T1.customer_id, T2.customer_first_name, T2.customer_last_name FROM Customers_cards AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id GROUP BY T1.customer_id ORDER BY COUNT(*) LIMIT 1",1079 "context": "CREATE TABLE Customers_cards (customer_id VARCHAR); CREATE TABLE Customers (customer_first_name VARCHAR, customer_last_name VARCHAR, customer_id VARCHAR)",1080 "instruction": "What is the customer id, first and last name with least number of accounts."1081 },1082 {1083 "response": "SELECT series FROM table_name_32 WHERE high_points = \"prince (23)\"",1084 "context": "CREATE TABLE table_name_32 (series VARCHAR, high_points VARCHAR)",1085 "instruction": "What series had a high points of Prince (23)?"1086 },1087 {1088 "response": "SELECT card_type_code FROM Customers_cards GROUP BY card_type_code ORDER BY COUNT(*) DESC LIMIT 1",1089 "context": "CREATE TABLE Customers_cards (card_type_code VARCHAR)",1090 "instruction": "What is the card type code with most number of cards?"1091 },1092 {1093 "response": "SELECT customer_id, customer_first_name FROM Customers EXCEPT SELECT T1.customer_id, T2.customer_first_name FROM Customers_cards AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE card_type_code = \"Credit\"",1094 "context": "CREATE TABLE Customers_cards (customer_id VARCHAR); CREATE TABLE Customers (customer_first_name VARCHAR, customer_id VARCHAR); CREATE TABLE Customers (customer_id VARCHAR, customer_first_name VARCHAR, card_type_code VARCHAR)",1095 "instruction": "Show the customer ids and firstname without a credit card."1096 },1097 {1098 "response": "SELECT MAX(col__m_) FROM table_18946749_2 WHERE peak = \"Barurumea Ridge\"",1099 "context": "CREATE TABLE table_18946749_2 (col__m_ INTEGER, peak VARCHAR)",1100 "instruction": "What is the col (m) of the Barurumea Ridge peak? "1101 },1102 {1103 "response": "SELECT 2012 FROM table_name_19 WHERE 2009 = \"1r\"",1104 "context": "CREATE TABLE table_name_19 (Id VARCHAR)",1105 "instruction": "Name the 2012 for 2009 of 1r"1106 },1107 {1108 "response": "SELECT MAX(prominence__m_) FROM table_18946749_1 WHERE peak = \"Mount Gauttier\"",1109 "context": "CREATE TABLE table_18946749_1 (prominence__m_ INTEGER, peak VARCHAR)",1110 "instruction": "When mount gauttier is the peak what is the highest prominence in meters?"1111 },1112 {1113 "response": "SELECT SUM(average) FROM table_name_70 WHERE swimsuit < 9.62 AND country = \"colorado\"",1114 "context": "CREATE TABLE table_name_70 (average INTEGER, swimsuit VARCHAR, country VARCHAR)",1115 "instruction": "What is the total average for swimsuits smaller than 9.62 in Colorado?"1116 },1117 {1118 "response": "SELECT COUNT(total) FROM table_name_17 WHERE country = \"switzerland\" AND gold < 7 AND silver < 3",1119 "context": "CREATE TABLE table_name_17 (total VARCHAR, silver VARCHAR, country VARCHAR, gold VARCHAR)",1120 "instruction": "How many times does Switzerland have under 7 golds and less than 3 silvers?"1121 },1122 {1123 "response": "SELECT athlete FROM table_name_87 WHERE gold < 7 AND total = 14",1124 "context": "CREATE TABLE table_name_87 (athlete VARCHAR, gold VARCHAR, total VARCHAR)",1125 "instruction": "What athlete has less than 7 gold and 14 total medals?"1126 },1127 {1128 "response": "SELECT name, seating FROM track WHERE year_opened > 2000 ORDER BY seating",1129 "context": "CREATE TABLE track (name VARCHAR, seating VARCHAR, year_opened INTEGER)",1130 "instruction": "Show names and seatings, ordered by seating for all tracks opened after 2000."1131 },1132 {1133 "response": "SELECT AVG(crowd) FROM table_name_13 WHERE home_team = \"hawthorn\"",1134 "context": "CREATE TABLE table_name_13 (crowd INTEGER, home_team VARCHAR)",1135 "instruction": "What is the average crowd size for the home team hawthorn?"1136 },1137 {1138 "response": "SELECT COUNT(chinese__traditional_) FROM table_1893815_1 WHERE album_number = \"6th\"",1139 "context": "CREATE TABLE table_1893815_1 (chinese__traditional_ VARCHAR, album_number VARCHAR)",1140 "instruction": "Name the number of traditional chinese for album number 6th"1141 },1142 {1143 "response": "SELECT name, LOCATION, year_opened FROM track WHERE seating > (SELECT AVG(seating) FROM track)",1144 "context": "CREATE TABLE track (name VARCHAR, LOCATION VARCHAR, year_opened VARCHAR, seating INTEGER)",1145 "instruction": "Show the name, location, open year for all tracks with a seating higher than the average."1146 },1147 {1148 "response": "SELECT live_births_per_year FROM table_18950570_2 WHERE life_expectancy_females = \"73.3\"",1149 "context": "CREATE TABLE table_18950570_2 (live_births_per_year VARCHAR, life_expectancy_females VARCHAR)",1150 "instruction": "How many live births per year are there in the period where the life expectancy for females is 73.3?"1151 },1152 {1153 "response": "SELECT name FROM track EXCEPT SELECT T2.name FROM race AS T1 JOIN track AS T2 ON T1.track_id = T2.track_id WHERE T1.class = 'GT'",1154 "context": "CREATE TABLE race (track_id VARCHAR, class VARCHAR); CREATE TABLE track (name VARCHAR); CREATE TABLE track (name VARCHAR, track_id VARCHAR)",1155 "instruction": "What are the names for tracks without a race in class 'GT'."1156 },1157 {1158 "response": "SELECT T2.name, T2.location FROM race AS T1 JOIN track AS T2 ON T1.track_id = T2.track_id GROUP BY T1.track_id HAVING COUNT(*) = 1",1159 "context": "CREATE TABLE race (track_id VARCHAR); CREATE TABLE track (name VARCHAR, location VARCHAR, track_id VARCHAR)",1160 "instruction": "Show the name and location of track with 1 race."1161 },1162 {1163 "response": "SELECT name FROM member WHERE address = 'Harford' OR address = 'Waterbury'",1164 "context": "CREATE TABLE member (name VARCHAR, address VARCHAR)",1165 "instruction": "Give me the names of members whose address is in Harford or Waterbury."1166 },1167 {1168 "response": "SELECT Membership_card FROM member GROUP BY Membership_card HAVING COUNT(*) > 5",1169 "context": "CREATE TABLE member (Membership_card VARCHAR)",1170 "instruction": "Which membership card has more than 5 members?"1171 },1172 {1173 "response": "SELECT membership_card FROM member WHERE address = 'Hartford' INTERSECT SELECT membership_card FROM member WHERE address = 'Waterbury'",1174 "context": "CREATE TABLE member (membership_card VARCHAR, address VARCHAR)",1175 "instruction": "What is the membership card held by both members living in Hartford and ones living in Waterbury address?"1176 },1177 {1178 "response": "SELECT MIN(obesity_rank) FROM table_18958648_1 WHERE state_and_district_of_columbia = \"Utah\"",1179 "context": "CREATE TABLE table_18958648_1 (obesity_rank INTEGER, state_and_district_of_columbia VARCHAR)",1180 "instruction": "What is the least obesity rank for the state of Utah?"1181 },1182 {1183 "response": "SELECT MIN(draws) FROM table_name_98 WHERE wins < 15 AND against = 1228",1184 "context": "CREATE TABLE table_name_98 (draws INTEGER, wins VARCHAR, against VARCHAR)",1185 "instruction": "What's the lowest number of draws when the wins are less than 15, and against is 1228?"1186 },1187 {1188 "response": "SELECT director_s_ FROM table_18994724_1 WHERE film_title_used_in_nomination = \"Nuits d'Arabie\"",1189 "context": "CREATE TABLE table_18994724_1 (director_s_ VARCHAR, film_title_used_in_nomination VARCHAR)",1190 "instruction": "Who directed the film Nuits d'arabie?"1191 },1192 {1193 "response": "SELECT player FROM table_18974269_1 WHERE original_season = \"RW: Key West\" AND eliminated = \"Episode 8\"",1194 "context": "CREATE TABLE table_18974269_1 (player VARCHAR, original_season VARCHAR, eliminated VARCHAR)",1195 "instruction": "Who was the contestant eliminated on episode 8 of RW: Key West season?"1196 },1197 {1198 "response": "SELECT gender FROM table_18974269_1 WHERE original_season = \"RR: South Pacific\"",1199 "context": "CREATE TABLE table_18974269_1 (gender VARCHAR, original_season VARCHAR)",1200 "instruction": "What was the gender of the contestant on RR: South Pacific season?"