HrishiP/Text2SQL
04
1[2 {3 "question": "बाइक आईडी 636 के साथ यात्राओं की कुल और अधिकतम अवधि क्या है?",4 "context": "CREATE TABLE trip (duration INTEGER, bike_id VARCHAR)",5 "answer": "SELECT SUM(duration), MAX(duration) FROM trip WHERE bike_id = 636"6 },7 {8 "question": "वहां कितनी किताबें हैं?",9 "context": "CREATE TABLE book (Id VARCHAR)",10 "answer": "SELECT COUNT(*) FROM book"11 },12 {13 "question": "कितने एलर्जी में जानवर हैं?",14 "context": "CREATE TABLE Allergy_type (allergytype VARCHAR)",15 "answer": "SELECT COUNT(*) FROM Allergy_type WHERE allergytype = \"animal\""16 },17 {18 "question": "आरोही वर्णमाला क्रम में पहाड़ों के नाम क्या हैं?",19 "context": "CREATE TABLE mountain (Name VARCHAR)",20 "answer": "SELECT Name FROM mountain ORDER BY Name"21 },22 {23 "question": "उन वस्तुओं के शीर्षक का पता लगाएं जिनकी रेटिंग सभी वस्तुओं की औसत समीक्षा रेटिंग से अधिक है।",24 "context": "CREATE TABLE review (rating INTEGER); CREATE TABLE item (title VARCHAR, i_id VARCHAR); CREATE TABLE review (i_id VARCHAR, rating INTEGER)",25 "answer": "SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id = T2.i_id WHERE T2.rating > (SELECT AVG(rating) FROM review)"26 },27 {28 "question": "रिकॉर्ड पर अधिकतम और न्यूनतम निपटान राशि क्या हैं?",29 "context": "CREATE TABLE settlements (settlement_amount INTEGER)",30 "answer": "SELECT MAX(settlement_amount), MIN(settlement_amount) FROM settlements"31 },32 {33 "question": "4 से अधिक बेडरूम के साथ अपार्टमेंट के सुविधा कोड दिखाएं।",34 "context": "CREATE TABLE Apartment_Facilities (facility_code VARCHAR, apt_id VARCHAR); CREATE TABLE Apartments (apt_id VARCHAR, bedroom_count INTEGER)",35 "answer": "SELECT T1.facility_code FROM Apartment_Facilities AS T1 JOIN Apartments AS T2 ON T1.apt_id = T2.apt_id WHERE T2.bedroom_count > 4"36 },37 {38 "question": "उस उपयोगकर्ता का नाम खोजें जो सबसे अधिक समीक्षा देता है।",39 "context": "CREATE TABLE useracct (name VARCHAR, u_id VARCHAR); CREATE TABLE review (u_id VARCHAR)",40 "answer": "SELECT T1.name FROM useracct AS T1 JOIN review AS T2 ON T1.u_id = T2.u_id GROUP BY T2.u_id ORDER BY COUNT(*) DESC LIMIT 1"41 },42 {43 "question": "नंबर 99 के साथ उड़ान के लिए विमान का नाम क्या है",44 "context": "CREATE TABLE Flight (aid VARCHAR, flno VARCHAR); CREATE TABLE Aircraft (name VARCHAR, aid VARCHAR)",45 "answer": "SELECT T2.name FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.aid = T2.aid WHERE T1.flno = 99"46 },47 {48 "question": "पुरस्कार के साथ संगीत के अलग -अलग नामांकित व्यक्ति क्या हैं जो \"टोनी पुरस्कार\" नहीं है?",49 "context": "CREATE TABLE musical (Nominee VARCHAR, Award VARCHAR)",50 "answer": "SELECT DISTINCT Nominee FROM musical WHERE Award <> \"Tony Award\""51 },52 {53 "question": "संगीत के सबसे सामान्य परिणाम की सूची बनाएं।",54 "context": "CREATE TABLE musical (RESULT VARCHAR)",55 "answer": "SELECT RESULT FROM musical GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1"56 },57 {58 "question": "प्रत्येक एल्बम को सूचीबद्ध करें जिसका शीर्षक वर्णमाला क्रम में एक से शुरू होता है।",59 "context": "CREATE TABLE albums (title VARCHAR)",60 "answer": "SELECT title FROM albums WHERE title LIKE 'A%' ORDER BY title"61 },62 {63 "question": "सभी देशों की देश का नाम और पूंजी दिखाएं।",64 "context": "CREATE TABLE country (Country_name VARCHAR, Capital VARCHAR)",65 "answer": "SELECT Country_name, Capital FROM country"66 },67 {68 "question": "विभाग का नाम खोजें जिसमें प्रोफेसरों का औसत औसत वेतन है।",69 "context": "CREATE TABLE instructor (dept_name VARCHAR, salary INTEGER)",70 "answer": "SELECT dept_name FROM instructor GROUP BY dept_name ORDER BY AVG(salary) DESC LIMIT 1"71 },72 {73 "question": "मुझे उन सभी यात्राओं के लिए आईडी दें जो 60 से ऊपर औसत औसत तापमान के साथ एक ज़िप कोड क्षेत्र में हुईं।",74 "context": "CREATE TABLE trip (id VARCHAR, zip_code VARCHAR); CREATE TABLE weather (zip_code VARCHAR, mean_temperature_f INTEGER)",75 "answer": "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"76 },77 {78 "question": "सभी उत्पादों के औसत और न्यूनतम मूल्य (यूरो में) क्या हैं?",79 "context": "CREATE TABLE catalog_contents (price_in_euros INTEGER)",80 "answer": "SELECT AVG(price_in_euros), MIN(price_in_euros) FROM catalog_contents"81 },82 {83 "question": "कम से कम दो उड़ानों के साथ सभी विमानों के लिए नाम दिखाएं।",84 "context": "CREATE TABLE Aircraft (name VARCHAR, aid VARCHAR); CREATE TABLE Flight (aid VARCHAR)",85 "answer": "SELECT T2.name FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.aid = T2.aid GROUP BY T1.aid HAVING COUNT(*) >= 2"86 },87 {88 "question": "कलाकारों के लिए सभी अलग -अलग देश क्या हैं?",89 "context": "CREATE TABLE artist (country VARCHAR)",90 "answer": "SELECT DISTINCT country FROM artist"91 },92 {93 "question": "राज्य एनवाई में सभी ग्राहक जानकारी खोजें।",94 "context": "CREATE TABLE CUSTOMER (State VARCHAR)",95 "answer": "SELECT * FROM CUSTOMER WHERE State = \"NY\""96 },97 {98 "question": "उनके शीर्षक और क्रेडिट द्वारा आदेशित सभी पाठ्यक्रमों के नामों को सूचीबद्ध करें।",99 "context": "CREATE TABLE course (title VARCHAR, credits VARCHAR)",100 "answer": "SELECT title FROM course ORDER BY title, credits"101 },102 {103 "question": "सभी चर्च नामों को दिखाएं जिन्होंने कम से कम दो शादियों की मेजबानी की है।",104 "context": "CREATE TABLE wedding (church_id VARCHAR); CREATE TABLE church (name VARCHAR, church_id VARCHAR)",105 "answer": "SELECT T1.name FROM church AS T1 JOIN wedding AS T2 ON T1.church_id = T2.church_id GROUP BY T1.church_id HAVING COUNT(*) >= 2"106 },107 {108 "question": "टाइप कोड \"फ्लैट\" के साथ अपार्टमेंट के अपार्टमेंट नंबरों को लौटाएं।",109 "context": "CREATE TABLE Apartments (apt_number VARCHAR, apt_type_code VARCHAR)",110 "answer": "SELECT apt_number FROM Apartments WHERE apt_type_code = \"Flat\""111 },112 {113 "question": "हमारे पास कितने विमान हैं?",114 "context": "CREATE TABLE Aircraft (Id VARCHAR)",115 "answer": "SELECT COUNT(*) FROM Aircraft"116 },117 {118 "question": "ऊंचाई के आरोही क्रम में लोगों के जन्मदिन क्या हैं?",119 "context": "CREATE TABLE People (Birth_Date VARCHAR, Height VARCHAR)",120 "answer": "SELECT Birth_Date FROM People ORDER BY Height"121 },122 {123 "question": "सभी उत्पाद नाम और प्रत्येक उत्पाद नाम के लिए आदेशित कुल मात्रा दिखाएं।",124 "context": "CREATE TABLE Products (product_name VARCHAR, product_id VARCHAR); CREATE TABLE Order_items (product_quantity INTEGER, product_id VARCHAR)",125 "answer": "SELECT T2.product_name, SUM(T1.product_quantity) FROM Order_items AS T1 JOIN Products AS T2 ON T1.product_id = T2.product_id GROUP BY T2.product_name"126 },127 {128 "question": "उन राज्यों को सूचीबद्ध करें जहां 'ट्रेजरी' विभाग के सचिव और 'होमलैंड सिक्योरिटी' के सचिव दोनों का जन्म हुआ।",129 "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)",130 "answer": "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'"131 },132 {133 "question": "कितने दिनों से दोनों का मतलब 50 से ऊपर है और इसका मतलब है 8 से ऊपर की दृश्यता?",134 "context": "CREATE TABLE weather (mean_humidity VARCHAR, mean_visibility_miles VARCHAR)",135 "answer": "SELECT COUNT(*) FROM weather WHERE mean_humidity > 50 AND mean_visibility_miles > 8"136 },137 {138 "question": "संपादकों के नाम और पत्रिकाओं के विषय को दिखाएं जिनके लिए वे समितियों में सेवा करते हैं।",139 "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)",140 "answer": "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"141 },142 {143 "question": "कनाडा से सभी महिलाओं के लिए नाम दिखाएं जो वर्ष 2016 में शादी कर रहे हैं।",144 "context": "CREATE TABLE people (name VARCHAR, people_id VARCHAR, country VARCHAR, is_male VARCHAR); CREATE TABLE wedding (female_id VARCHAR, year VARCHAR)",145 "answer": "SELECT T2.name FROM wedding AS T1 JOIN people AS T2 ON T1.female_id = T2.people_id WHERE T1.year = 2016 AND T2.is_male = 'F' AND T2.country = 'Canada'"146 },147 {148 "question": "सीज़न, खिलाड़ी, और उस देश का नाम दिखाओ जो खिलाड़ी का है।",149 "context": "CREATE TABLE match_season (Season VARCHAR, Player VARCHAR, Country VARCHAR); CREATE TABLE country (Country_name VARCHAR, Country_id VARCHAR)",150 "answer": "SELECT T2.Season, T2.Player, T1.Country_name FROM country AS T1 JOIN match_season AS T2 ON T1.Country_id = T2.Country"151 },152 {153 "question": "कम से कम दो दौड़ के साथ रेस क्लास को सूचीबद्ध करें।",154 "context": "CREATE TABLE race (CLASS VARCHAR)",155 "answer": "SELECT CLASS FROM race GROUP BY CLASS HAVING COUNT(*) >= 2"156 },157 {158 "question": "कितने चुनाव हैं?",159 "context": "CREATE TABLE election (Id VARCHAR)",160 "answer": "SELECT COUNT(*) FROM election"161 },162 {163 "question": "भौतिकी विभाग द्वारा कितने अलग -अलग पाठ्यक्रम पेश किए गए हैं?",164 "context": "CREATE TABLE course (course_id VARCHAR, dept_name VARCHAR)",165 "answer": "SELECT COUNT(DISTINCT course_id) FROM course WHERE dept_name = 'Physics'"166 },167 {168 "question": "उन स्टेशनों के नाम क्या हैं जिनकी औसत बाइक की उपलब्धता 10 से ऊपर है और सैन जोस सिटी में स्थित नहीं हैं?",169 "context": "CREATE TABLE station (name VARCHAR, id VARCHAR); CREATE TABLE status (station_id VARCHAR); CREATE TABLE station (name VARCHAR, city VARCHAR, bikes_available INTEGER)",170 "answer": "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\""171 },172 {173 "question": "सबसे आम अपार्टमेंट प्रकार कोड दिखाएं।",174 "context": "CREATE TABLE Apartments (apt_type_code VARCHAR)",175 "answer": "SELECT apt_type_code FROM Apartments GROUP BY apt_type_code ORDER BY COUNT(*) DESC LIMIT 1"176 },177 {178 "question": "उन छात्रों का पहला नाम और प्रमुख खोजें जो सोया पर नहीं हैं।",179 "context": "CREATE TABLE Has_allergy (fname VARCHAR, major VARCHAR, StuID VARCHAR, Allergy VARCHAR); CREATE TABLE Student (fname VARCHAR, major VARCHAR, StuID VARCHAR, Allergy VARCHAR)",180 "answer": "SELECT fname, major FROM Student WHERE NOT StuID IN (SELECT StuID FROM Has_allergy WHERE Allergy = \"Soy\")"181 },182 {183 "question": "100000 और 200000 के बीच कितने कर्मचारियों का वेतन है?",184 "context": "CREATE TABLE Employee (salary INTEGER)",185 "answer": "SELECT COUNT(*) FROM Employee WHERE salary BETWEEN 100000 AND 200000"186 },187 {188 "question": "सभी ग्राहकों के लिए आईडी, पहले नाम, अंतिम नाम और फोन दिखाएं।",189 "context": "CREATE TABLE Customers (customer_id VARCHAR, customer_first_name VARCHAR, customer_last_name VARCHAR, customer_phone VARCHAR)",190 "answer": "SELECT customer_id, customer_first_name, customer_last_name, customer_phone FROM Customers"191 },192 {193 "question": "विभागों के अधिकतम और न्यूनतम बजट क्या हैं?",194 "context": "CREATE TABLE department (budget_in_billions INTEGER)",195 "answer": "SELECT MAX(budget_in_billions), MIN(budget_in_billions) FROM department"196 },197 {198 "question": "सबसे कम उम्र के संपादक का नाम क्या है?",199 "context": "CREATE TABLE editor (Name VARCHAR, Age VARCHAR)",200 "answer": "SELECT Name FROM editor ORDER BY Age LIMIT 1"201 },202 {203 "question": "किस मॉडल में कम से कम रैम है?मॉडल का नाम और रैम की मात्रा सूचीबद्ध करें।",204 "context": "CREATE TABLE chip_model (Model_name VARCHAR, RAM_MiB VARCHAR)",205 "answer": "SELECT Model_name, RAM_MiB FROM chip_model ORDER BY RAM_MiB LIMIT 1"206 },207 {208 "question": "कुल मिलाकर कितने दावा प्रसंस्करण चरण हैं?",209 "context": "CREATE TABLE claims_processing_stages (Id VARCHAR)",210 "answer": "SELECT COUNT(*) FROM claims_processing_stages"211 },212 {213 "question": "\"मैरी\" नामक उपयोगकर्ता के ईमेल खोजें।",214 "context": "CREATE TABLE user_profiles (email VARCHAR, name VARCHAR)",215 "answer": "SELECT email FROM user_profiles WHERE name = 'Mary'"216 },217 {218 "question": "सबसे बड़ी अधिकतम गस्ट गति के साथ शीर्ष 3 दिनों के लिए तारीख, मतलब तापमान और मतलब आर्द्रता क्या हैं?",219 "context": "CREATE TABLE weather (date VARCHAR, mean_temperature_f VARCHAR, mean_humidity VARCHAR, max_gust_speed_mph VARCHAR)",220 "answer": "SELECT date, mean_temperature_f, mean_humidity FROM weather ORDER BY max_gust_speed_mph DESC LIMIT 3"221 },222 {223 "question": "पता करें कि कितने अलग -अलग संबद्धता हैं।",224 "context": "CREATE TABLE university (affiliation VARCHAR)",225 "answer": "SELECT COUNT(DISTINCT affiliation) FROM university"226 },227 {228 "question": "खाता आईडी और नाम कम से कम 4 लेनदेन के साथ दिखाएं।",229 "context": "CREATE TABLE Financial_transactions (account_id VARCHAR); CREATE TABLE Accounts (account_name VARCHAR, account_id VARCHAR)",230 "answer": "SELECT T1.account_id, T2.account_name FROM Financial_transactions AS T1 JOIN Accounts AS T2 ON T1.account_id = T2.account_id GROUP BY T1.account_id HAVING COUNT(*) >= 4"231 },232 {233 "question": "प्रत्येक यात्रा के लिए, इसकी समाप्ति स्टेशन की स्थापना तिथि वापस करें।",234 "context": "CREATE TABLE station (installation_date VARCHAR, id VARCHAR); CREATE TABLE trip (id VARCHAR, end_station_id VARCHAR)",235 "answer": "SELECT T1.id, T2.installation_date FROM trip AS T1 JOIN station AS T2 ON T1.end_station_id = T2.id"236 },237 {238 "question": "प्रतिनिधियों के नाम क्या हैं जिनकी पार्टी \"रिपब्लिकन\" नहीं है?",239 "context": "CREATE TABLE Representative (Name VARCHAR, Party VARCHAR)",240 "answer": "SELECT Name FROM Representative WHERE Party <> \"Republican\""241 },242 {243 "question": "2 बेडरूम से अधिक के साथ अपार्टमेंट की बुकिंग शुरू और अंत की तारीखें क्या हैं?",244 "context": "CREATE TABLE Apartment_Bookings (booking_start_date VARCHAR, apt_id VARCHAR); CREATE TABLE Apartments (apt_id VARCHAR, bedroom_count INTEGER)",245 "answer": "SELECT T1.booking_start_date, T1.booking_start_date FROM Apartment_Bookings AS T1 JOIN Apartments AS T2 ON T1.apt_id = T2.apt_id WHERE T2.bedroom_count > 2"246 },247 {248 "question": "उन उपयोगकर्ताओं की संख्या का पता लगाएं जिन्होंने कोई समीक्षा नहीं लिखी।",249 "context": "CREATE TABLE review (u_id VARCHAR); CREATE TABLE useracct (u_id VARCHAR)",250 "answer": "SELECT COUNT(*) FROM useracct WHERE NOT u_id IN (SELECT u_id FROM review)"251 },252 {253 "question": "अक्षांश, देशांतर, स्टेशन का शहर क्या है जिसमें से सबसे छोटी यात्रा शुरू हुई?",254 "context": "CREATE TABLE trip (start_station_id VARCHAR, duration VARCHAR); CREATE TABLE station (lat VARCHAR, long VARCHAR, city VARCHAR, id VARCHAR)",255 "answer": "SELECT T1.lat, T1.long, T1.city FROM station AS T1 JOIN trip AS T2 ON T1.id = T2.start_station_id ORDER BY T2.duration LIMIT 1"256 },257 {258 "question": "खाता नाम, आईडी और प्रत्येक खाते के लिए लेनदेन की संख्या दिखाएं।",259 "context": "CREATE TABLE Financial_transactions (account_id VARCHAR); CREATE TABLE Accounts (account_name VARCHAR, account_id VARCHAR)",260 "answer": "SELECT T2.account_name, T1.account_id, COUNT(*) FROM Financial_transactions AS T1 JOIN Accounts AS T2 ON T1.account_id = T2.account_id GROUP BY T1.account_id"261 },262 {263 "question": "किस दुकान में सबसे अधिक समय है?इसकी आईडी और हैप्पी आवर्स की संख्या को सूचीबद्ध करें।",264 "context": "CREATE TABLE happy_hour (shop_id VARCHAR)",265 "answer": "SELECT shop_id, COUNT(*) FROM happy_hour GROUP BY shop_id ORDER BY COUNT(*) DESC LIMIT 1"266 },267 {268 "question": "कृपया मेजबान शहरों के साथ प्रतियोगिताओं के विषयों को 1000 से अधिक आबादी वाले हैं।",269 "context": "CREATE TABLE city (City_ID VARCHAR, Population INTEGER); CREATE TABLE farm_competition (Theme VARCHAR, Host_city_ID VARCHAR)",270 "answer": "SELECT T2.Theme FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID = T2.Host_city_ID WHERE T1.Population > 1000"271 },272 {273 "question": "उन प्रमुखों द्वारा प्रबंधित विभागों के लिए कर्मचारियों का नाम और संख्या दिखाएं जिनके अस्थायी अभिनय मूल्य 'हां' हैं?",274 "context": "CREATE TABLE management (department_id VARCHAR, temporary_acting VARCHAR); CREATE TABLE department (name VARCHAR, num_employees VARCHAR, department_id VARCHAR)",275 "answer": "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'"276 },277 {278 "question": "ऊंचाई के अवरोही क्रम में लोगों की ऊंचाई और वजन को सूचीबद्ध करें।",279 "context": "CREATE TABLE people (Height VARCHAR, Weight VARCHAR)",280 "answer": "SELECT Height, Weight FROM people ORDER BY Height DESC"281 },282 {283 "question": "2000 के बाद खोले गए सभी पटरियों के लिए बैठे नाम और बैठने की जगह दिखाएं।",284 "context": "CREATE TABLE track (name VARCHAR, seating VARCHAR, year_opened INTEGER)",285 "answer": "SELECT name, seating FROM track WHERE year_opened > 2000 ORDER BY seating"286 },287 {288 "question": "उस छात्र की आईडी क्या है जिसने हाल ही में पंजीकृत पाठ्यक्रम 301 को पंजीकृत किया है?",289 "context": "CREATE TABLE student_course_attendance (student_id VARCHAR, course_id VARCHAR, date_of_attendance VARCHAR)",290 "answer": "SELECT student_id FROM student_course_attendance WHERE course_id = 301 ORDER BY date_of_attendance DESC LIMIT 1"291 },292 {293 "question": "उम्र के अवरोही क्रम में अभिनेताओं के चरित्र क्या हैं?",294 "context": "CREATE TABLE actor (Character VARCHAR, age VARCHAR)",295 "answer": "SELECT Character FROM actor ORDER BY age DESC"296 },297 {298 "question": "एडुआर्डो मार्टिंस किस कंपनी में एक ग्राहक है?",299 "context": "CREATE TABLE customers (company VARCHAR, first_name VARCHAR, last_name VARCHAR)",300 "answer": "SELECT company FROM customers WHERE first_name = \"Eduardo\" AND last_name = \"Martins\""301 },302 {303 "question": "2009 में गिरने वाले पाठ्यक्रमों को खोजें लेकिन स्प्रिंग 2010 में नहीं।",304 "context": "CREATE TABLE SECTION (course_id VARCHAR, semester VARCHAR, YEAR VARCHAR)",305 "answer": "SELECT course_id FROM SECTION WHERE semester = 'Fall' AND YEAR = 2009 EXCEPT SELECT course_id FROM SECTION WHERE semester = 'Spring' AND YEAR = 2010"306 },307 {308 "question": "उस दिन का पता लगाएं जिसमें अधिकतम तापमान और न्यूनतम तापमान के बीच का अंतर सबसे छोटा था।अंतर की भी रिपोर्ट करें।",309 "context": "CREATE TABLE weather (date VARCHAR, max_temperature_f VARCHAR, min_temperature_f VARCHAR)",310 "answer": "SELECT date, max_temperature_f - min_temperature_f FROM weather ORDER BY max_temperature_f - min_temperature_f LIMIT 1"311 },312 {313 "question": "सभी चालान के लिए चालान दिनांक और आदेश आईडी और विवरण दिखाएं।",314 "context": "CREATE TABLE Invoices (invoice_date VARCHAR, order_id VARCHAR); CREATE TABLE Orders (order_details VARCHAR, order_id VARCHAR)",315 "answer": "SELECT T1.invoice_date, T1.order_id, T2.order_details FROM Invoices AS T1 JOIN Orders AS T2 ON T1.order_id = T2.order_id"316 },317 {318 "question": "उन नामों और स्थानों को सूचीबद्ध करें जो एंजाइम एक प्रभाव डाल सकते हैं।",319 "context": "CREATE TABLE enzyme (name VARCHAR, LOCATION VARCHAR)",320 "answer": "SELECT name, LOCATION FROM enzyme"321 },322 {323 "question": "उन स्टेशनों में औसत बाइक की उपलब्धता क्या है जो पालो ऑल्टो में स्थित नहीं हैं?",324 "context": "CREATE TABLE status (bikes_available INTEGER, station_id VARCHAR, id VARCHAR, city VARCHAR); CREATE TABLE station (bikes_available INTEGER, station_id VARCHAR, id VARCHAR, city VARCHAR)",325 "answer": "SELECT AVG(bikes_available) FROM status WHERE NOT station_id IN (SELECT id FROM station WHERE city = \"Palo Alto\")"326 },327 {328 "question": "सभी कलाकार का नाम, आयु और देश दिखाएं जो वे शामिल हुए थे।",329 "context": "CREATE TABLE artist (name VARCHAR, age VARCHAR, country VARCHAR, Year_Join VARCHAR)",330 "answer": "SELECT name, age, country FROM artist ORDER BY Year_Join"331 },332 {333 "question": "काम कर रहे सिर की अलग -अलग उम्र क्या हैं?",334 "context": "CREATE TABLE head (age VARCHAR, head_id VARCHAR); CREATE TABLE management (head_id VARCHAR, temporary_acting VARCHAR)",335 "answer": "SELECT DISTINCT T1.age FROM management AS T2 JOIN head AS T1 ON T1.head_id = T2.head_id WHERE T2.temporary_acting = 'Yes'"336 },337 {338 "question": "हार्डवेयर मॉडल नाम \"LG-P760\" के साथ फोन के चिप मॉडल और स्क्रीन मोड क्या हैं?",339 "context": "CREATE TABLE phone (chip_model VARCHAR, screen_mode VARCHAR, Hardware_Model_name VARCHAR)",340 "answer": "SELECT chip_model, screen_mode FROM phone WHERE Hardware_Model_name = \"LG-P760\""341 },342 {343 "question": "प्रदर्शनों की तारीखें और स्थान क्या हैं?",344 "context": "CREATE TABLE performance (Date VARCHAR, LOCATION VARCHAR)",345 "answer": "SELECT Date, LOCATION FROM performance"346 },347 {348 "question": "उन छात्रों का नाम खोजें जिन्होंने जीव विज्ञान विभाग से कोई कोर्स नहीं लिया।",349 "context": "CREATE TABLE student (name VARCHAR, id VARCHAR); CREATE TABLE course (course_id VARCHAR, dept_name VARCHAR); CREATE TABLE takes (id VARCHAR, course_id VARCHAR)",350 "answer": "SELECT name FROM student WHERE NOT id IN (SELECT T1.id FROM takes AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.dept_name = 'Biology')"351 },352 {353 "question": "24 या 25 की उम्र के संपादकों के नाम दिखाएं।",354 "context": "CREATE TABLE editor (Name VARCHAR, Age VARCHAR)",355 "answer": "SELECT Name FROM editor WHERE Age = 24 OR Age = 25"356 },357 {358 "question": "हमारे रिकॉर्ड में कितने महिला लोग 30 से अधिक उम्र के हैं?",359 "context": "CREATE TABLE people (is_male VARCHAR, age VARCHAR)",360 "answer": "SELECT COUNT(*) FROM people WHERE is_male = 'F' AND age > 30"361 },362 {363 "question": "2000 से अधिक दूरी के साथ सभी उड़ानों के लिए उड़ान संख्या दिखाएं।",364 "context": "CREATE TABLE Flight (flno VARCHAR, distance INTEGER)",365 "answer": "SELECT flno FROM Flight WHERE distance > 2000"366 },367 {368 "question": "औसत से अधिक वेतन वाले सभी कर्मचारियों के लिए नाम दिखाएं।",369 "context": "CREATE TABLE Employee (name VARCHAR, salary INTEGER)",370 "answer": "SELECT name FROM Employee WHERE salary > (SELECT AVG(salary) FROM Employee)"371 },372 {373 "question": "उपस्थिति के आरोही क्रम में प्रदर्शन के मेजबानों को सूचीबद्ध करें।",374 "context": "CREATE TABLE performance (HOST VARCHAR, Attendance VARCHAR)",375 "answer": "SELECT HOST FROM performance ORDER BY Attendance"376 },377 {378 "question": "प्रत्येक एल्बम के लिए एल्बम नाम, आईडी और ट्रैक की संख्या दिखाएं।",379 "context": "CREATE TABLE ALBUM (Title VARCHAR, AlbumId VARCHAR); CREATE TABLE TRACK (AlbumID VARCHAR, AlbumId VARCHAR)",380 "answer": "SELECT T1.Title, T2.AlbumID, COUNT(*) FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumId = T2.AlbumId GROUP BY T2.AlbumID"381 },382 {383 "question": "\"नोकिया कॉरपोरेशन\" या जिनके स्क्रीन मोड प्रकार \"ग्राफिक्स\" द्वारा निर्मित फोन के लिए हार्डवेयर मॉडल का नाम सूचीबद्ध करें।",384 "context": "CREATE TABLE phone (Hardware_Model_name VARCHAR, screen_mode VARCHAR); CREATE TABLE screen_mode (Graphics_mode VARCHAR, Type VARCHAR)",385 "answer": "SELECT DISTINCT T2.Hardware_Model_name FROM screen_mode AS T1 JOIN phone AS T2 ON T1.Graphics_mode = T2.screen_mode WHERE T1.Type = \"Graphics\" OR t2.Company_name = \"Nokia Corporation\""386 },387 {388 "question": "समीक्षाओं की संख्या का पता लगाएं।",389 "context": "CREATE TABLE review (Id VARCHAR)",390 "answer": "SELECT COUNT(*) FROM review"391 },392 {393 "question": "उस छात्र का पहला नाम और लिंग खोजें, जिसे दूध से एलर्जी है लेकिन बिल्ली नहीं।",394 "context": "CREATE TABLE Student (fname VARCHAR, sex VARCHAR, StuID VARCHAR, Allergy VARCHAR); CREATE TABLE Has_allergy (fname VARCHAR, sex VARCHAR, StuID VARCHAR, Allergy VARCHAR)",395 "answer": "SELECT fname, sex FROM Student WHERE StuID IN (SELECT StuID FROM Has_allergy WHERE Allergy = \"Milk\" EXCEPT SELECT StuID FROM Has_allergy WHERE Allergy = \"Cat\")"396 },397 {398 "question": "ग्राहक का पहला नाम और अंतिम नाम क्या है जिसमें ईमेल \"luisg@embraer.com.br\" है?",399 "context": "CREATE TABLE CUSTOMER (FirstName VARCHAR, LastName VARCHAR, Email VARCHAR)",400 "answer": "SELECT FirstName, LastName FROM CUSTOMER WHERE Email = \"luisg@embraer.com.br\""401 },402 {403 "question": "उन प्रशिक्षकों के नाम खोजें जिन्होंने किसी भी वसंत सेमेस्टर में प्रत्येक पाठ्यक्रम नहीं किया।",404 "context": "CREATE TABLE teaches (name VARCHAR, id VARCHAR, semester VARCHAR); CREATE TABLE instructor (name VARCHAR, id VARCHAR, semester VARCHAR)",405 "answer": "SELECT name FROM instructor WHERE NOT id IN (SELECT id FROM teaches WHERE semester = 'Spring')"406 },407 {408 "question": "कृपया संपादकों की सबसे आम उम्र दिखाएं।",409 "context": "CREATE TABLE editor (Age VARCHAR)",410 "answer": "SELECT Age FROM editor GROUP BY Age ORDER BY COUNT(*) DESC LIMIT 1"411 },412 {413 "question": "कृपया प्रत्येक देश से देशों और पर्वतारोहियों की संख्या दिखाएं।",414 "context": "CREATE TABLE climber (Country VARCHAR)",415 "answer": "SELECT Country, COUNT(*) FROM climber GROUP BY Country"416 },417 {418 "question": "कितने पाठ्यक्रम जिनके पास शर्त नहीं है?",419 "context": "CREATE TABLE prereq (course_id VARCHAR); CREATE TABLE course (course_id VARCHAR)",420 "answer": "SELECT COUNT(*) FROM course WHERE NOT course_id IN (SELECT course_id FROM prereq)"421 },422 {423 "question": "बहस के अलग -अलग स्थानों को दिखाएं",424 "context": "CREATE TABLE debate (Venue VARCHAR)",425 "answer": "SELECT DISTINCT Venue FROM debate"426 },427 {428 "question": "उन सभी लेनदेन के लिए आईडी दिखाएं जिनकी मात्रा औसत से अधिक है।",429 "context": "CREATE TABLE Financial_transactions (transaction_id VARCHAR, transaction_amount INTEGER)",430 "answer": "SELECT transaction_id FROM Financial_transactions WHERE transaction_amount > (SELECT AVG(transaction_amount) FROM Financial_transactions)"431 },432 {433 "question": "कौन सा शहर जो ग्राहक को पोस्टल कोड 70174 के साथ मदद करता है, वह किस शहर में रहता है?",434 "context": "CREATE TABLE EMPLOYEE (City VARCHAR, EmployeeId VARCHAR); CREATE TABLE CUSTOMER (SupportRepId VARCHAR, PostalCode VARCHAR)",435 "answer": "SELECT T2.City FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId = T2.EmployeeId WHERE T1.PostalCode = \"70174\""436 },437 {438 "question": "सबसे हाल ही में बनाए गए दस्तावेज़ में दावा की गई कुल राशि का पता लगाएं।",439 "context": "CREATE TABLE claim_headers (amount_claimed INTEGER, claim_header_id VARCHAR); CREATE TABLE claims_documents (claim_id VARCHAR, created_date VARCHAR); CREATE TABLE claims_documents (created_date VARCHAR)",440 "answer": "SELECT SUM(t1.amount_claimed) FROM claim_headers AS t1 JOIN claims_documents AS t2 ON t1.claim_header_id = t2.claim_id WHERE t2.created_date = (SELECT created_date FROM claims_documents ORDER BY created_date LIMIT 1)"441 },442 {443 "question": "पहले नाम 'मेघन' के साथ ग्राहक द्वारा सभी खातों के लिए आईडी, खाता नाम और अन्य खाता विवरण दिखाएं।",444 "context": "CREATE TABLE Accounts (account_id VARCHAR, date_account_opened VARCHAR, account_name VARCHAR, other_account_details VARCHAR, customer_id VARCHAR); CREATE TABLE Customers (customer_id VARCHAR, customer_first_name VARCHAR)",445 "answer": "SELECT T1.account_id, T1.date_account_opened, T1.account_name, T1.other_account_details FROM Accounts AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T2.customer_first_name = 'Meaghan'"446 },447 {448 "question": "इंग्लैंड में कितने लीग हैं?",449 "context": "CREATE TABLE League (country_id VARCHAR); CREATE TABLE Country (id VARCHAR, name VARCHAR)",450 "answer": "SELECT COUNT(*) FROM Country AS T1 JOIN League AS T2 ON T1.id = T2.country_id WHERE T1.name = \"England\""451 },452 {453 "question": "बस्तियों की कुल और औसत मात्रा का पता लगाएं।",454 "context": "CREATE TABLE settlements (settlement_amount INTEGER)",455 "answer": "SELECT SUM(settlement_amount), AVG(settlement_amount) FROM settlements"456 },457 {458 "question": "विभिन्न विभाग द्वारा प्रदान किए गए पाठ्यक्रमों के कुल क्रेडिट का पता लगाएं।",459 "context": "CREATE TABLE course (dept_name VARCHAR, credits INTEGER)",460 "answer": "SELECT SUM(credits), dept_name FROM course GROUP BY dept_name"461 },462 {463 "question": "स्थापित वर्ष के आदेश में सभी स्कूलों और उनके उपनामों को सूचीबद्ध करें।",464 "context": "CREATE TABLE university (school VARCHAR, nickname VARCHAR, founded VARCHAR)",465 "answer": "SELECT school, nickname FROM university ORDER BY founded"466 },467 {468 "question": "कितने एल्बम हैं?",469 "context": "CREATE TABLE ALBUM (Id VARCHAR)",470 "answer": "SELECT COUNT(*) FROM ALBUM"471 },472 {473 "question": "10 कम से कम महंगे चालान के ग्राहकों को पहले और अंतिम नाम सूचीबद्ध करें।",474 "context": "CREATE TABLE customers (first_name VARCHAR, last_name VARCHAR, id VARCHAR); CREATE TABLE invoices (customer_id VARCHAR)",475 "answer": "SELECT T1.first_name, T1.last_name FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id = T1.id ORDER BY total LIMIT 10"476 },477 {478 "question": "ग्राहक \"दयाना रोबेल\" से जुड़े सभी पॉलिसी प्रकार कोड खोजें",479 "context": "CREATE TABLE customers (customer_id VARCHAR, customer_details VARCHAR); CREATE TABLE policies (customer_id VARCHAR)",480 "answer": "SELECT policy_type_code FROM policies AS t1 JOIN customers AS t2 ON t1.customer_id = t2.customer_id WHERE t2.customer_details = \"Dayana Robel\""481 },482 {483 "question": "आरोही वर्णमाला क्रम में पुस्तकों के लेखकों को सूचीबद्ध करें।",484 "context": "CREATE TABLE book (Writer VARCHAR)",485 "answer": "SELECT Writer FROM book ORDER BY Writer"486 },487 {488 "question": "कंपनी में सबसे कम उम्र का कर्मचारी कौन है?कर्मचारी का पहला और अंतिम नाम सूचीबद्ध करें।",489 "context": "CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, birth_date VARCHAR)",490 "answer": "SELECT first_name, last_name FROM employees ORDER BY birth_date DESC LIMIT 1"491 },492 {493 "question": "शुरुआती वर्ष दिखाएं जिसमें कम से कम दो चर्च खुल गए।",494 "context": "CREATE TABLE church (open_date VARCHAR)",495 "answer": "SELECT open_date FROM church GROUP BY open_date HAVING COUNT(*) >= 2"496 },497 {498 "question": "उन सभी विभागों के नाम और औसत वेतन का पता लगाएं जिनका औसत वेतन 42000 से अधिक है।",499 "context": "CREATE TABLE instructor (dept_name VARCHAR, salary INTEGER)",500 "answer": "SELECT dept_name, AVG(salary) FROM instructor GROUP BY dept_name HAVING AVG(salary) > 42000"501 },502 {503 "question": "अधिकतम अंक के साथ पर्वतारोही द्वारा चढ़े हुए पहाड़ की ऊंचाई दिखाएं।",504 "context": "CREATE TABLE climber (Mountain_ID VARCHAR, Points VARCHAR); CREATE TABLE mountain (Height VARCHAR, Mountain_ID VARCHAR)",505 "answer": "SELECT T2.Height FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID = T2.Mountain_ID ORDER BY T1.Points DESC LIMIT 1"506 },507 {508 "question": "कुल मिलाकर कितने अपार्टमेंट बुकिंग हैं?",509 "context": "CREATE TABLE Apartment_Bookings (Id VARCHAR)",510 "answer": "SELECT COUNT(*) FROM Apartment_Bookings"511 },512 {513 "question": "वर्णमाला क्रम में पाठ्यक्रमों के नामों को सूचीबद्ध करें?",514 "context": "CREATE TABLE courses (course_name VARCHAR)",515 "answer": "SELECT course_name FROM courses ORDER BY course_name"516 },517 {518 "question": "कनाडा में कितने कर्मचारी रह रहे हैं?",519 "context": "CREATE TABLE employees (country VARCHAR)",520 "answer": "SELECT COUNT(*) FROM employees WHERE country = \"Canada\""521 },522 {523 "question": "सीज़न, खिलाड़ी और उस टीम का नाम दिखाएं जो खिलाड़ियों से संबंधित हैं।",524 "context": "CREATE TABLE team (Name VARCHAR, Team_id VARCHAR); CREATE TABLE match_season (Season VARCHAR, Player VARCHAR, Team VARCHAR)",525 "answer": "SELECT T1.Season, T1.Player, T2.Name FROM match_season AS T1 JOIN team AS T2 ON T1.Team = T2.Team_id"526 },527 {528 "question": "औसत से अधिक बैठने के साथ सभी पटरियों के लिए नाम, स्थान, खुला वर्ष दिखाएं।",529 "context": "CREATE TABLE track (name VARCHAR, LOCATION VARCHAR, year_opened VARCHAR, seating INTEGER)",530 "answer": "SELECT name, LOCATION, year_opened FROM track WHERE seating > (SELECT AVG(seating) FROM track)"531 },532 {533 "question": "पर्वतारोहियों के नाम और पहाड़ों की ऊंचाइयों को दिखाएं जो वे चढ़ते हैं।",534 "context": "CREATE TABLE mountain (Height VARCHAR, Mountain_ID VARCHAR); CREATE TABLE climber (Name VARCHAR, Mountain_ID VARCHAR)",535 "answer": "SELECT T1.Name, T2.Height FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID = T2.Mountain_ID"536 },537 {538 "question": "अधिकांश दौड़ के साथ रेस क्लास क्या है।",539 "context": "CREATE TABLE race (CLASS VARCHAR)",540 "answer": "SELECT CLASS FROM race GROUP BY CLASS ORDER BY COUNT(*) DESC LIMIT 1"541 },542 {543 "question": "किस हेड का नाम सब्सट्रिंग 'हा' है?आईडी और नाम सूचीबद्ध करें।",544 "context": "CREATE TABLE head (head_id VARCHAR, name VARCHAR)",545 "answer": "SELECT head_id, name FROM head WHERE name LIKE '%Ha%'"546 },547 {548 "question": "किस कोर्स में अधिकांश पंजीकृत छात्र हैं?",549 "context": "CREATE TABLE courses (course_name VARCHAR, course_id VARCHAR); CREATE TABLE student_course_registrations (course_Id VARCHAR)",550 "answer": "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"551 },552 {553 "question": "उन इमारतों का पता लगाएं जिनमें 50 से अधिक क्षमता वाले कमरे हैं।",554 "context": "CREATE TABLE classroom (building VARCHAR, capacity INTEGER)",555 "answer": "SELECT DISTINCT building FROM classroom WHERE capacity > 50"556 },557 {558 "question": "प्रत्येक संबद्धता प्रकार के लिए 20000 से अधिक नामांकन आकार वाले विश्वविद्यालयों की संख्या का पता लगाएं।",559 "context": "CREATE TABLE university (affiliation VARCHAR, enrollment INTEGER)",560 "answer": "SELECT COUNT(*), affiliation FROM university WHERE enrollment > 20000 GROUP BY affiliation"561 },562 {563 "question": "सभी छात्र आईडी दिखाएं जिन्हें कम से कम दो एलर्जी है।",564 "context": "CREATE TABLE Has_allergy (StuID VARCHAR)",565 "answer": "SELECT StuID FROM Has_allergy GROUP BY StuID HAVING COUNT(*) >= 2"566 },567 {568 "question": "सबसे कम ट्रस्ट स्कोर के साथ लक्ष्य उपयोगकर्ता का नाम खोजें।",569 "context": "CREATE TABLE trust (target_u_id VARCHAR); CREATE TABLE useracct (name VARCHAR, u_id VARCHAR)",570 "answer": "SELECT T1.name FROM useracct AS T1 JOIN trust AS T2 ON T1.u_id = T2.target_u_id ORDER BY trust LIMIT 1"571 },572 {573 "question": "उस कर्मचारी का वेतन और नाम क्या है जिसके पास 5000 से अधिक दूरी के साथ विमानों पर सबसे अधिक प्रमाण पत्र हैं?",574 "context": "CREATE TABLE Aircraft (aid VARCHAR, distance INTEGER); CREATE TABLE Employee (name VARCHAR, eid VARCHAR); CREATE TABLE Certificate (eid VARCHAR, aid VARCHAR)",575 "answer": "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"576 },577 {578 "question": "प्रतिनिधियों के लिए कितने अलग -अलग पार्टियां हैं?",579 "context": "CREATE TABLE representative (Party VARCHAR)",580 "answer": "SELECT COUNT(DISTINCT Party) FROM representative"581 },582 {583 "question": "उन छात्रों की औसत आयु का पता लगाएं जिन्हें भोजन और पशु प्रकारों के साथ एलर्जी है।",584 "context": "CREATE TABLE Student (age INTEGER, StuID VARCHAR); CREATE TABLE Allergy_Type (Allergy VARCHAR, allergytype VARCHAR); CREATE TABLE Has_allergy (StuID VARCHAR, Allergy VARCHAR)",585 "answer": "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\")"586 },587 {588 "question": "पाठ्यक्रम 301 पंजीकृत करने वाले छात्रों की आईडी क्या हैं?",589 "context": "CREATE TABLE student_course_attendance (student_id VARCHAR, course_id VARCHAR)",590 "answer": "SELECT student_id FROM student_course_attendance WHERE course_id = 301"591 },592 {593 "question": "सभी अपार्टमेंट के बाथरूम की न्यूनतम और अधिकतम संख्या क्या है?",594 "context": "CREATE TABLE Apartments (bathroom_count INTEGER)",595 "answer": "SELECT MIN(bathroom_count), MAX(bathroom_count) FROM Apartments"596 },597 {598 "question": "एलर्जी और उनके प्रकार क्या हैं जो पहले नाम लिसा के साथ छात्र हैं?और एलर्जी के नाम से परिणाम का आदेश दें।",599 "context": "CREATE TABLE Has_allergy (Allergy VARCHAR, StuID VARCHAR); CREATE TABLE Student (StuID VARCHAR, Fname VARCHAR); CREATE TABLE Allergy_type (Allergy VARCHAR, AllergyType VARCHAR)",600 "answer": "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"601 },602 {603 "question": "पर्वतारोही कितने अलग -अलग देश हैं?",604 "context": "CREATE TABLE climber (Country VARCHAR)",605 "answer": "SELECT COUNT(DISTINCT Country) FROM climber"606 },607 {608 "question": "किस सीज़न में और किस स्टेडियम में किसी भी खिलाड़ी को 'पैर की चोट' या 'घुटने की समस्या' की चोट लगी थी?",609 "context": "CREATE TABLE stadium (name VARCHAR, id VARCHAR); CREATE TABLE injury_accident (game_id VARCHAR, injury VARCHAR); CREATE TABLE game (season VARCHAR, stadium_id VARCHAR, id VARCHAR)",610 "answer": "SELECT T1.season, T2.name FROM game AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.id JOIN injury_accident AS T3 ON T1.id = T3.game_id WHERE T3.injury = 'Foot injury' OR T3.injury = 'Knee problem'"611 },612 {613 "question": "बास्केटबॉल प्रतियोगिता में सभी टीमों के नाम, अवरोही क्रम में सभी घरेलू स्कोर द्वारा आदेश दिया गया।",614 "context": "CREATE TABLE basketball_match (team_name VARCHAR, All_Home VARCHAR)",615 "answer": "SELECT team_name FROM basketball_match ORDER BY All_Home DESC"616 },617 {618 "question": "किस सलाहकार के पास अधिकांश छात्र हैं?",619 "context": "CREATE TABLE Student (advisor VARCHAR)",620 "answer": "SELECT advisor FROM Student GROUP BY advisor ORDER BY COUNT(*) DESC LIMIT 1"621 },622 {623 "question": "एल्बम के नाम और आईडी को उन एल्बमों के लिए दिखाएं जिनमें यूनिट प्राइस के साथ ट्रैक होते हैं।",624 "context": "CREATE TABLE ALBUM (Title VARCHAR, AlbumId VARCHAR); CREATE TABLE TRACK (AlbumID VARCHAR, AlbumId VARCHAR, UnitPrice INTEGER)",625 "answer": "SELECT T1.Title, T2.AlbumID FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumId = T2.AlbumId WHERE T2.UnitPrice > 1 GROUP BY T2.AlbumID"626 },627 {628 "question": "प्रत्येक संपादक का नाम, प्रत्येक संपादक का नाम और जर्नल समितियों की संख्या दिखाएं।",629 "context": "CREATE TABLE editor (editor_id VARCHAR, Name VARCHAR, Editor_ID VARCHAR); CREATE TABLE journal_committee (Editor_ID VARCHAR)",630 "answer": "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"631 },632 {633 "question": "सबसे लोकप्रिय नीति प्रकार के तहत सभी ग्राहक फोन नंबर क्या हैं?",634 "context": "CREATE TABLE available_policies (customer_phone VARCHAR, policy_type_code VARCHAR)",635 "answer": "SELECT customer_phone FROM available_policies WHERE policy_type_code = (SELECT policy_type_code FROM available_policies GROUP BY policy_type_code ORDER BY COUNT(*) DESC LIMIT 1)"636 },637 {638 "question": "उन खिलाड़ियों के प्रायोजकों के नाम दिखाएं जिनके निवास या तो \"ब्रैंडन\" या \"बर्टल\" हैं।",639 "context": "CREATE TABLE player (Sponsor_name VARCHAR, Residence VARCHAR)",640 "answer": "SELECT Sponsor_name FROM player WHERE Residence = \"Brandon\" OR Residence = \"Birtle\""641 },642 {643 "question": "आईडी 1004 के साथ छात्र का सलाहकार कौन है?",644 "context": "CREATE TABLE Student (Advisor VARCHAR, StuID VARCHAR)",645 "answer": "SELECT Advisor FROM Student WHERE StuID = 1004"646 },647 {648 "question": "उन देशों को सूचीबद्ध करें जिनके पास एक से अधिक पर्वत हैं।",649 "context": "CREATE TABLE mountain (Country VARCHAR)",650 "answer": "SELECT Country FROM mountain GROUP BY Country HAVING COUNT(*) > 1"651 },652 {653 "question": "चिप मॉडल का औसत रैम MIB आकार खोजें जो कभी भी किसी भी फोन द्वारा उपयोग नहीं किए जाते हैं।",654 "context": "CREATE TABLE chip_model (RAM_MiB INTEGER, model_name VARCHAR, chip_model VARCHAR); CREATE TABLE phone (RAM_MiB INTEGER, model_name VARCHAR, chip_model VARCHAR)",655 "answer": "SELECT AVG(RAM_MiB) FROM chip_model WHERE NOT model_name IN (SELECT chip_model FROM phone)"656 },657 {658 "question": "प्रशिक्षक की आईडी क्या है जो इतिहास विभाग के सभी छात्रों की सलाह देता है?",659 "context": "CREATE TABLE advisor (s_id VARCHAR); CREATE TABLE student (id VARCHAR, dept_name VARCHAR)",660 "answer": "SELECT i_id FROM advisor AS T1 JOIN student AS T2 ON T1.s_id = T2.id WHERE T2.dept_name = 'History'"661 },662 {663 "question": "उन सभी अलग -अलग स्टेशनों को सूचीबद्ध करें जिनसे 100 से नीचे की अवधि की यात्रा शुरू हुई।",664 "context": "CREATE TABLE trip (start_station_name VARCHAR, duration INTEGER)",665 "answer": "SELECT DISTINCT start_station_name FROM trip WHERE duration < 100"666 },667 {668 "question": "उत्पाद आईडी और प्रत्येक उत्पाद वाले अद्वितीय आदेशों की संख्या दिखाएं।",669 "context": "CREATE TABLE Order_items (product_id VARCHAR, order_id VARCHAR)",670 "answer": "SELECT product_id, COUNT(DISTINCT order_id) FROM Order_items GROUP BY product_id"671 },672 {673 "question": "ऐसे प्रकाशकों को दिखाएं जिनके पास एक से अधिक प्रकाशन हैं।",674 "context": "CREATE TABLE publication (Publisher VARCHAR)",675 "answer": "SELECT Publisher FROM publication GROUP BY Publisher HAVING COUNT(*) > 1"676 },677 {678 "question": "लेन -देन प्रकार क्या है जिसने लेनदेन में सबसे बड़ी कुल राशि को संसाधित किया है?",679 "context": "CREATE TABLE Financial_transactions (transaction_type VARCHAR, transaction_amount INTEGER)",680 "answer": "SELECT transaction_type FROM Financial_transactions GROUP BY transaction_type ORDER BY SUM(transaction_amount) DESC LIMIT 1"681 },682 {683 "question": "वे कौन से जन्म स्थान हैं जो कम से कम दो लोगों द्वारा साझा किए जाते हैं?",684 "context": "CREATE TABLE people (Birth_Place VARCHAR)",685 "answer": "SELECT Birth_Place FROM people GROUP BY Birth_Place HAVING COUNT(*) >= 2"686 },687 {688 "question": "खाता नाम 900 के साथ ग्राहक के लिए पहला नाम और अंतिम नाम दिखाएं।",689 "context": "CREATE TABLE Accounts (customer_id VARCHAR, account_name VARCHAR); CREATE TABLE Customers (customer_first_name VARCHAR, customer_last_name VARCHAR, customer_id VARCHAR)",690 "answer": "SELECT T2.customer_first_name, T2.customer_last_name FROM Accounts AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T1.account_name = \"900\""691 },692 {693 "question": "पर्वतारोहियों के लिए अधिकतम बिंदु क्या है जिसका देश यूनाइटेड किंगडम है?",694 "context": "CREATE TABLE climber (Points INTEGER, Country VARCHAR)",695 "answer": "SELECT MAX(Points) FROM climber WHERE Country = \"United Kingdom\""696 },697 {698 "question": "पहला नाम क्या है और अंतिम नाम कर्मचारी ग्राहक को पहले नाम लियोनी की मदद करता है?",699 "context": "CREATE TABLE CUSTOMER (SupportRepId VARCHAR, FirstName VARCHAR); CREATE TABLE EMPLOYEE (FirstName VARCHAR, LastName VARCHAR, EmployeeId VARCHAR)",700 "answer": "SELECT T2.FirstName, T2.LastName FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId = T2.EmployeeId WHERE T1.FirstName = \"Leonie\""701 },702 {703 "question": "स्टीव जॉनसन के कितने ग्राहक समर्थन करते हैं?",704 "context": "CREATE TABLE employees (id VARCHAR, first_name VARCHAR, last_name VARCHAR); CREATE TABLE customers (support_rep_id VARCHAR)",705 "answer": "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\""706 },707 {708 "question": "प्रत्येक शहर के लिए, अपने स्टेशनों के बीच उच्चतम अक्षांश लौटाएं।",709 "context": "CREATE TABLE station (city VARCHAR, lat INTEGER)",710 "answer": "SELECT city, MAX(lat) FROM station GROUP BY city"711 },712 {713 "question": "कितने कलाकार 46 वर्ष से ऊपर हैं और 1990 के बाद शामिल हुए हैं?",714 "context": "CREATE TABLE artist (age VARCHAR, year_join VARCHAR)",715 "answer": "SELECT COUNT(*) FROM artist WHERE age > 46 AND year_join > 1990"716 },717 {718 "question": "एरोस्मिथ के एल्बमों को सूचीबद्ध करें।",719 "context": "CREATE TABLE artists (id VARCHAR, name VARCHAR); CREATE TABLE albums (title VARCHAR, artist_id VARCHAR)",720 "answer": "SELECT T1.title FROM albums AS T1 JOIN artists AS T2 ON T1.artist_id = T2.id WHERE T2.name = \"Aerosmith\""721 },722 {723 "question": "ऑर्डर आईडी और प्रत्येक ऑर्डर में आइटम की संख्या दिखाएं।",724 "context": "CREATE TABLE Order_items (order_id VARCHAR)",725 "answer": "SELECT order_id, COUNT(*) FROM Order_items GROUP BY order_id"726 },727 {728 "question": "बुकिंग स्थिति कोड और बुकिंग की संबंधित संख्या दिखाएं।",729 "context": "CREATE TABLE Apartment_Bookings (booking_status_code VARCHAR)",730 "answer": "SELECT booking_status_code, COUNT(*) FROM Apartment_Bookings GROUP BY booking_status_code"731 },732 {733 "question": "उन प्रशिक्षकों का नाम खोजें जिन्होंने पहले सी प्रोग्रामिंग कोर्स पढ़ाया था।",734 "context": "CREATE TABLE teaches (id VARCHAR, course_id VARCHAR); CREATE TABLE course (course_id VARCHAR, title VARCHAR); CREATE TABLE instructor (name VARCHAR, id VARCHAR)",735 "answer": "SELECT T1.name FROM instructor AS T1 JOIN teaches AS T2 ON T1.id = T2.id JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.title = 'C Programming'"736 },737 {738 "question": "उन कमरों की कमरे की संख्या का पता लगाएं जो 50 से 100 छात्रों और उनकी इमारतों में बैठ सकते हैं।",739 "context": "CREATE TABLE classroom (building VARCHAR, room_number VARCHAR, capacity INTEGER)",740 "answer": "SELECT building, room_number FROM classroom WHERE capacity BETWEEN 50 AND 100"741 },742 {743 "question": "उन छात्रों के अलग -अलग पहले नाम और शहरों का पता लगाएं जिन्हें दूध या बिल्ली से एलर्जी है।",744 "context": "CREATE TABLE Has_Allergy (stuid VARCHAR, Allergy VARCHAR); CREATE TABLE Student (fname VARCHAR, city_code VARCHAR, stuid VARCHAR)",745 "answer": "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\""746 },747 {748 "question": "बिना किसी खाते के सभी ग्राहकों की संख्या दिखाएं।",749 "context": "CREATE TABLE Customers (customer_id VARCHAR); CREATE TABLE Accounts (customer_id VARCHAR)",750 "answer": "SELECT COUNT(*) FROM Customers WHERE NOT customer_id IN (SELECT customer_id FROM Accounts)"751 },752 {753 "question": "लुकास मैनसिनी द्वारा खर्च की गई कुल राशि क्या है?",754 "context": "CREATE TABLE invoices (total INTEGER, customer_id VARCHAR); CREATE TABLE customers (id VARCHAR, first_name VARCHAR, last_name VARCHAR)",755 "answer": "SELECT SUM(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = \"Lucas\" AND T1.last_name = \"Mancini\""756 },757 {758 "question": "कितनी महिला छात्रों को दूध या अंडे की एलर्जी होती है?",759 "context": "CREATE TABLE Student (StuID VARCHAR, sex VARCHAR); CREATE TABLE has_allergy (StuID VARCHAR, allergy VARCHAR)",760 "answer": "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\""761 },762 {763 "question": "एक खाते के साथ सभी ग्राहकों के लिए पहले और अंतिम नाम दिखाएं।",764 "context": "CREATE TABLE Accounts (customer_id VARCHAR); CREATE TABLE Customers (customer_first_name VARCHAR, customer_last_name VARCHAR, customer_id VARCHAR)",765 "answer": "SELECT DISTINCT T1.customer_first_name, T1.customer_last_name FROM Customers AS T1 JOIN Accounts AS T2 ON T1.customer_id = T2.customer_id"766 },767 {768 "question": "रिकॉर्ड में कितने उत्पाद हैं?",769 "context": "CREATE TABLE catalog_contents (Id VARCHAR)",770 "answer": "SELECT COUNT(*) FROM catalog_contents"771 },772 {773 "question": "सदस्यों के नाम और प्रदर्शन की तारीखों को दिखाएं जो उन्होंने प्रदर्शन की उपस्थिति के अवरोही क्रम में भाग लिया।",774 "context": "CREATE TABLE performance (Date VARCHAR, Performance_ID VARCHAR, Attendance VARCHAR); CREATE TABLE member (Name VARCHAR, Member_ID VARCHAR); CREATE TABLE member_attendance (Member_ID VARCHAR, Performance_ID VARCHAR)",775 "answer": "SELECT T2.Name, T3.Date FROM member_attendance AS T1 JOIN member AS T2 ON T1.Member_ID = T2.Member_ID JOIN performance AS T3 ON T1.Performance_ID = T3.Performance_ID ORDER BY T3.Attendance DESC"776 },777 {778 "question": "उन सभी प्रशिक्षकों के नाम खोजें जिनके नाम में सबस्ट्रिंग \"डार\" शामिल हैं।",779 "context": "CREATE TABLE instructor (name VARCHAR)",780 "answer": "SELECT name FROM instructor WHERE name LIKE '%dar%'"781 },782 {783 "question": "हमारे पास कितने खाते हैं?",784 "context": "CREATE TABLE Accounts (Id VARCHAR)",785 "answer": "SELECT COUNT(*) FROM Accounts"786 },787 {788 "question": "5 और 10 के बीच स्तर के साथ कैटलॉग संरचना का नाम और स्तर खोजें।",789 "context": "CREATE TABLE Catalog_Structure (catalog_level_name VARCHAR, catalog_level_number INTEGER)",790 "answer": "SELECT catalog_level_name, catalog_level_number FROM Catalog_Structure WHERE catalog_level_number BETWEEN 5 AND 10"791 },792 {793 "question": "सभी खेतों में गायों की अधिकतम और न्यूनतम संख्या क्या हैं।",794 "context": "CREATE TABLE farm (Cows INTEGER)",795 "answer": "SELECT MAX(Cows), MIN(Cows) FROM farm"796 },797 {798 "question": "लॉस एंजिल्स से उड़ानों के लिए औसत दूरी और औसत मूल्य क्या है।",799 "context": "CREATE TABLE Flight (distance INTEGER, price INTEGER, origin VARCHAR)",800 "answer": "SELECT AVG(distance), AVG(price) FROM Flight WHERE origin = \"Los Angeles\""801 },802 {803 "question": "प्रशिक्षकों का नाम खोजें जो गणित विभाग के छात्रों के सलाहकार हैं, और छात्रों के कुल क्रेडिट द्वारा परिणामों को क्रमबद्ध करते हैं।",804 "context": "CREATE TABLE student (id VARCHAR, dept_name VARCHAR, tot_cred VARCHAR); CREATE TABLE advisor (i_id VARCHAR, s_id VARCHAR); CREATE TABLE instructor (name VARCHAR, id VARCHAR)",805 "answer": "SELECT T2.name FROM advisor AS T1 JOIN instructor AS T2 ON T1.i_id = T2.id JOIN student AS T3 ON T1.s_id = T3.id WHERE T3.dept_name = 'Math' ORDER BY T3.tot_cred"806 },807 {808 "question": "उन लोगों के नाम दिखाएं जो 200 से बड़े दर्शकों की संख्या के साथ बहस के सकारात्मक पक्ष पर हैं।",809 "context": "CREATE TABLE people (Name VARCHAR, People_ID VARCHAR); CREATE TABLE debate (Debate_ID VARCHAR, Num_of_Audience INTEGER); CREATE TABLE debate_people (Debate_ID VARCHAR, Affirmative VARCHAR)",810 "answer": "SELECT T3.Name FROM debate_people AS T1 JOIN debate AS T2 ON T1.Debate_ID = T2.Debate_ID JOIN people AS T3 ON T1.Affirmative = T3.People_ID WHERE T2.Num_of_Audience > 200"811 },812 {813 "question": "सभी छात्र आईडी दिखाएं जो 20 से अधिक उम्र के हैं।",814 "context": "CREATE TABLE Student (StuID VARCHAR, age INTEGER)",815 "answer": "SELECT StuID FROM Student WHERE age > 20"816 },817 {818 "question": "औसत से अधिक टिकट की कीमत के साथ प्रदर्शनी के लिए थीम और कलाकार का नाम क्या है?",819 "context": "CREATE TABLE exhibition (ticket_price INTEGER); CREATE TABLE exhibition (theme VARCHAR, artist_id VARCHAR, ticket_price INTEGER); CREATE TABLE artist (name VARCHAR, artist_id VARCHAR)",820 "answer": "SELECT T1.theme, T2.name FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id = T2.artist_id WHERE T1.ticket_price > (SELECT AVG(ticket_price) FROM exhibition)"821 },822 {823 "question": "सभी कर्मचारियों का औसत और अधिकतम वेतन क्या है।",824 "context": "CREATE TABLE Employee (salary INTEGER)",825 "answer": "SELECT AVG(salary), MAX(salary) FROM Employee"826 },827 {828 "question": "उच्चतम कुल स्कोर के साथ बॉडी बिल्डर के स्वच्छ और झटका स्कोर क्या हैं?",829 "context": "CREATE TABLE body_builder (Clean_Jerk VARCHAR, Total VARCHAR)",830 "answer": "SELECT Clean_Jerk FROM body_builder ORDER BY Total DESC LIMIT 1"831 },832 {833 "question": "बिना किसी प्रदर्शनी के कलाकारों के लिए नाम दिखाएं।",834 "context": "CREATE TABLE artist (name VARCHAR, artist_id VARCHAR); CREATE TABLE exhibition (name VARCHAR, artist_id VARCHAR)",835 "answer": "SELECT name FROM artist WHERE NOT artist_id IN (SELECT artist_id FROM exhibition)"836 },837 {838 "question": "कितने उपयोगकर्ता हैं?",839 "context": "CREATE TABLE useracct (Id VARCHAR)",840 "answer": "SELECT COUNT(*) FROM useracct"841 },842 {843 "question": "उन सभी लोगों के लिए नाम और देश दिखाएं जिनकी उम्र औसत से छोटा है।",844 "context": "CREATE TABLE people (name VARCHAR, country VARCHAR, age INTEGER)",845 "answer": "SELECT name, country FROM people WHERE age < (SELECT AVG(age) FROM people)"846 },847 {848 "question": "रॉक पटरियों की औसत इकाई मूल्य क्या है?",849 "context": "CREATE TABLE GENRE (GenreId VARCHAR, Name VARCHAR); CREATE TABLE TRACK (UnitPrice INTEGER, GenreId VARCHAR)",850 "answer": "SELECT AVG(T2.UnitPrice) FROM GENRE AS T1 JOIN TRACK AS T2 ON T1.GenreId = T2.GenreId WHERE T1.Name = \"Rock\""851 },852 {853 "question": "उन पुस्तकों के शीर्षक सूचीबद्ध करें जो प्रकाशित नहीं हैं।",854 "context": "CREATE TABLE book (Title VARCHAR, Book_ID VARCHAR); CREATE TABLE publication (Title VARCHAR, Book_ID VARCHAR)",855 "answer": "SELECT Title FROM book WHERE NOT Book_ID IN (SELECT Book_ID FROM publication)"856 },857 {858 "question": "लेन -देन के प्रकार और लेनदेन की कुल राशि दिखाएं।",859 "context": "CREATE TABLE Financial_transactions (transaction_type VARCHAR, transaction_amount INTEGER)",860 "answer": "SELECT transaction_type, SUM(transaction_amount) FROM Financial_transactions GROUP BY transaction_type"861 },862 {863 "question": "Astrid Gruber का ईमेल और फोन नंबर क्या है?",864 "context": "CREATE TABLE customers (email VARCHAR, phone VARCHAR, first_name VARCHAR, last_name VARCHAR)",865 "answer": "SELECT email, phone FROM customers WHERE first_name = \"Astrid\" AND last_name = \"Gruber\""866 },867 {868 "question": "उस देश को दिखाएं जहां 30 से अधिक वर्ष और 25 वर्ष से कम उम्र के लोग हैं।",869 "context": "CREATE TABLE people (country VARCHAR, age INTEGER)",870 "answer": "SELECT country FROM people WHERE age < 25 INTERSECT SELECT country FROM people WHERE age > 30"871 },872 {873 "question": "उन ग्राहकों की आईडी खोजें जिनके नाम में \"डायना\" है।",874 "context": "CREATE TABLE customers (customer_id VARCHAR, customer_name VARCHAR)",875 "answer": "SELECT customer_id FROM customers WHERE customer_name LIKE \"%Diana%\""876 },877 {878 "question": "वर्ष 2004 में प्रदर्शनी के लिए विषय, तिथि और उपस्थिति क्या है?",879 "context": "CREATE TABLE exhibition_record (date VARCHAR, attendance VARCHAR, exhibition_id VARCHAR); CREATE TABLE exhibition (theme VARCHAR, exhibition_id VARCHAR, year VARCHAR)",880 "answer": "SELECT T2.theme, T1.date, T1.attendance FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id = T2.exhibition_id WHERE T2.year = 2004"881 },882 {883 "question": "उन अपार्टमेंट की औसत कमरे की गिनती दिखाएं जिनमें बुकिंग स्टेटस कोड \"अनंतिम\" है।",884 "context": "CREATE TABLE Apartment_Bookings (apt_id VARCHAR, booking_status_code VARCHAR); CREATE TABLE Apartments (apt_id VARCHAR)",885 "answer": "SELECT AVG(room_count) FROM Apartment_Bookings AS T1 JOIN Apartments AS T2 ON T1.apt_id = T2.apt_id WHERE T1.booking_status_code = \"Provisional\""886 },887 {888 "question": "180 सेमी और 190 सेमी के बीच ऊंचाई के साथ बाएं पैर वाले खिलाड़ियों के लिए सभी आईडी सूचीबद्ध करें।",889 "context": "CREATE TABLE Player_Attributes (player_api_id VARCHAR, preferred_foot VARCHAR, height VARCHAR); CREATE TABLE Player (player_api_id VARCHAR, preferred_foot VARCHAR, height VARCHAR)",890 "answer": "SELECT player_api_id FROM Player WHERE height >= 180 AND height <= 190 INTERSECT SELECT player_api_id FROM Player_Attributes WHERE preferred_foot = \"left\""891 },892 {893 "question": "प्रत्येक बॉडी बिल्डर के बारे में सभी जानकारी दिखाएं।",894 "context": "CREATE TABLE body_builder (Id VARCHAR)",895 "answer": "SELECT * FROM body_builder"896 },897 {898 "question": "प्रतिनिधि के विभिन्न पक्ष क्या हैं?प्रत्येक पार्टी में पार्टी का नाम और प्रतिनिधियों की संख्या दिखाएं।",899 "context": "CREATE TABLE representative (Party VARCHAR)",900 "answer": "SELECT Party, COUNT(*) FROM representative GROUP BY Party"901 },902 {903 "question": "औसत और कुल लेनदेन राशि क्या है?",904 "context": "CREATE TABLE Financial_transactions (transaction_amount INTEGER)",905 "answer": "SELECT AVG(transaction_amount), SUM(transaction_amount) FROM Financial_transactions"906 },907 {908 "question": "कॉलेज यूसीएलए या ड्यूक के खिलाड़ियों की अलग स्थिति दिखाएं।",909 "context": "CREATE TABLE match_season (POSITION VARCHAR, College VARCHAR)",910 "answer": "SELECT DISTINCT POSITION FROM match_season WHERE College = \"UCLA\" OR College = \"Duke\""911 },912 {913 "question": "उन उम्मीदवारों का सेल मोबाइल नंबर खोजें जिनका मूल्यांकन कोड \"विफल\" है?",914 "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)",915 "answer": "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\""916 },917 {918 "question": "उन ग्राहकों के नाम का पता लगाएं जिनकी कोई नीतियां जुड़ी हुई हैं।",919 "context": "CREATE TABLE customers (customer_details VARCHAR, customer_id VARCHAR); CREATE TABLE customers (customer_details VARCHAR); CREATE TABLE policies (customer_id VARCHAR)",920 "answer": "SELECT customer_details FROM customers EXCEPT SELECT t2.customer_details FROM policies AS t1 JOIN customers AS t2 ON t1.customer_id = t2.customer_id"921 },922 {923 "question": "अगस्त से शुरू होने वाली सबसे अधिक यात्राएं किस स्टार्ट स्टेशन की थी?मुझे स्टेशन का नाम और आईडी दें।",924 "context": "CREATE TABLE trip (start_station_name VARCHAR, start_station_id VARCHAR, start_date VARCHAR)",925 "answer": "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"926 },927 {928 "question": "प्रत्येक पते में रहने वाले सदस्यों की संख्या का पता लगाएं।",929 "context": "CREATE TABLE member (address VARCHAR)",930 "answer": "SELECT COUNT(*), address FROM member GROUP BY address"931 },932 {933 "question": "समग्र रेटिंग के मामले में शीर्ष 3 खिलाड़ी कौन हैं?",934 "context": "CREATE TABLE Player (player_name VARCHAR, player_api_id VARCHAR); CREATE TABLE Player_Attributes (player_api_id VARCHAR)",935 "answer": "SELECT DISTINCT T1.player_name FROM Player AS T1 JOIN Player_Attributes AS T2 ON T1.player_api_id = T2.player_api_id ORDER BY overall_rating DESC LIMIT 3"936 },937 {938 "question": "उन छात्रों के नाम खोजें जिन्होंने वर्ष 2003 के पतन सेमेस्टर में कोई कोर्स लिया है।",939 "context": "CREATE TABLE student (name VARCHAR, id VARCHAR, semester VARCHAR, YEAR VARCHAR); CREATE TABLE takes (name VARCHAR, id VARCHAR, semester VARCHAR, YEAR VARCHAR)",940 "answer": "SELECT name FROM student WHERE id IN (SELECT id FROM takes WHERE semester = 'Fall' AND YEAR = 2003)"941 },942 {943 "question": "वर्णमाला में सूची सभी अलग -अलग प्रशिक्षकों के नाम।",944 "context": "CREATE TABLE instructor (name VARCHAR)",945 "answer": "SELECT DISTINCT name FROM instructor ORDER BY name"946 },947 {948 "question": "कृपया उस नामांकित व्यक्ति को दिखाएं जिसे सबसे बड़ी संख्या में नामांकित किया गया है।",949 "context": "CREATE TABLE musical (Nominee VARCHAR)",950 "answer": "SELECT Nominee FROM musical GROUP BY Nominee ORDER BY COUNT(*) DESC LIMIT 1"951 },952 {953 "question": "उन सदस्यों के नाम सूचीबद्ध करें जो किसी भी प्रदर्शन में शामिल नहीं हुए।",954 "context": "CREATE TABLE member (Name VARCHAR, Member_ID VARCHAR); CREATE TABLE member_attendance (Name VARCHAR, Member_ID VARCHAR)",955 "answer": "SELECT Name FROM member WHERE NOT Member_ID IN (SELECT Member_ID FROM member_attendance)"956 },957 {958 "question": "देश युगांडा में पहाड़ों पर चढ़ने के लिए पर्वतारोहियों द्वारा उपयोग किए जाने वाले समय को दिखाएं।",959 "context": "CREATE TABLE mountain (Mountain_ID VARCHAR, Country VARCHAR); CREATE TABLE climber (Time VARCHAR, Mountain_ID VARCHAR)",960 "answer": "SELECT T1.Time FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID = T2.Mountain_ID WHERE T2.Country = \"Uganda\""961 },962 {963 "question": "सभी पटरियों के लिए नाम और स्थान दिखाएं।",964 "context": "CREATE TABLE track (name VARCHAR, LOCATION VARCHAR)",965 "answer": "SELECT name, LOCATION FROM track"966 },967 {968 "question": "अगली प्रविष्टि आईडी के साथ सभी उत्पादों को 8 से अधिक नाम दें।",969 "context": "CREATE TABLE catalog_contents (catalog_entry_name VARCHAR, next_entry_id INTEGER)",970 "answer": "SELECT catalog_entry_name FROM catalog_contents WHERE next_entry_id > 8"971 },972 {973 "question": "सभी अपार्टमेंट के बेडरूम की औसत संख्या क्या है?",974 "context": "CREATE TABLE Apartments (bedroom_count INTEGER)",975 "answer": "SELECT AVG(bedroom_count) FROM Apartments"976 },977 {978 "question": "प्रदर्शन के लिए उपस्थित लोगों की औसत संख्या क्या है?",979 "context": "CREATE TABLE performance (Attendance INTEGER)",980 "answer": "SELECT AVG(Attendance) FROM performance"981 },982 {983 "question": "'रेगे' और 'रॉक' शैली ट्रैक दोनों वाले एल्बमों के लिए एल्बम शीर्षक क्या हैं?",984 "context": "CREATE TABLE Genre (GenreID VARCHAR, Name VARCHAR); CREATE TABLE Track (AlbumId VARCHAR, GenreID VARCHAR); CREATE TABLE Album (Title VARCHAR, AlbumId VARCHAR)",985 "answer": "SELECT T1.Title FROM Album AS T1 JOIN Track AS T2 ON T1.AlbumId = T2.AlbumId JOIN Genre AS T3 ON T2.GenreID = T3.GenreID WHERE T3.Name = 'Reggae' INTERSECT SELECT T1.Title FROM Album AS T1 JOIN Track AS T2 ON T1.AlbumId = T2.AlbumId JOIN Genre AS T3 ON T2.GenreID = T3.GenreID WHERE T3.Name = 'Rock'"986 },987 {988 "question": "उन लेखकों को सूचीबद्ध करें जिन्होंने एक से अधिक पुस्तक लिखी हैं।",989 "context": "CREATE TABLE book (Writer VARCHAR)",990 "answer": "SELECT Writer FROM book GROUP BY Writer HAVING COUNT(*) > 1"991 },992 {993 "question": "प्रकाशन मूल्य के अवरोही क्रम में पुस्तकों के शीर्षक दिखाएं।",994 "context": "CREATE TABLE publication (Book_ID VARCHAR, Price VARCHAR); CREATE TABLE book (Title VARCHAR, Book_ID VARCHAR)",995 "answer": "SELECT T1.Title FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID ORDER BY T2.Price DESC"996 },997 {998 "question": "उन ग्राहकों के नाम का पता लगाएं जिन्होंने सेवा \"क्लोज ए पॉलिसी\" और सेवा \"नई नीति एप्लिकेशन\" दोनों का उपयोग किया है।",999 "context": "CREATE TABLE first_notification_of_loss (customer_id VARCHAR, service_id VARCHAR); CREATE TABLE customers (customer_name VARCHAR, customer_id VARCHAR); CREATE TABLE services (service_id VARCHAR, service_name VARCHAR)",1000 "answer": "SELECT t1.customer_name FROM customers AS t1 JOIN first_notification_of_loss AS t2 ON t1.customer_id = t2.customer_id JOIN services AS t3 ON t2.service_id = t3.service_id WHERE t3.service_name = \"Close a policy\" INTERSECT SELECT t1.customer_name FROM customers AS t1 JOIN first_notification_of_loss AS t2 ON t1.customer_id = t2.customer_id JOIN services AS t3 ON t2.service_id = t3.service_id WHERE t3.service_name = \"New policy application\""1001 },1002 {1003 "question": "सभी पटरियों की औसत इकाई मूल्य क्या है?",1004 "context": "CREATE TABLE TRACK (UnitPrice INTEGER)",1005 "answer": "SELECT AVG(UnitPrice) FROM TRACK"1006 },1007 {1008 "question": "ऑर्डर आईडी और प्रत्येक ऑर्डर में उत्पादों की संख्या दिखाएं।",1009 "context": "CREATE TABLE Order_items (order_id VARCHAR, product_id VARCHAR)",1010 "answer": "SELECT order_id, COUNT(DISTINCT product_id) FROM Order_items GROUP BY order_id"1011 },1012 {1013 "question": "सभी लेनदेन प्रकार दिखाएं।",1014 "context": "CREATE TABLE Financial_Transactions (transaction_type VARCHAR)",1015 "answer": "SELECT DISTINCT transaction_type FROM Financial_Transactions"1016 },1017 {1018 "question": "पर्वतारोहियों के नाम और पहाड़ों के नाम पर वे चढ़ते हैं।",1019 "context": "CREATE TABLE mountain (Name VARCHAR, Mountain_ID VARCHAR); CREATE TABLE climber (Name VARCHAR, Mountain_ID VARCHAR)",1020 "answer": "SELECT T1.Name, T2.Name FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID = T2.Mountain_ID"1021 },1022 {1023 "question": "अधिकांश खातों के साथ ग्राहक आईडी और खातों की संख्या दिखाएं।",1024 "context": "CREATE TABLE Accounts (customer_id VARCHAR)",1025 "answer": "SELECT customer_id, COUNT(*) FROM Accounts GROUP BY customer_id ORDER BY COUNT(*) DESC LIMIT 1"1026 },1027 {1028 "question": "उन उपयोगकर्ताओं की आईडी खोजें जो मैरी और सुसान द्वारा पीछा किया जाता है।",1029 "context": "CREATE TABLE follows (f1 VARCHAR, f2 VARCHAR); CREATE TABLE user_profiles (uid VARCHAR, name VARCHAR)",1030 "answer": "SELECT T2.f1 FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid = T2.f2 WHERE T1.name = \"Mary\" INTERSECT SELECT T2.f1 FROM user_profiles AS T1 JOIN follows AS T2 ON T1.uid = T2.f2 WHERE T1.name = \"Susan\""1031 },1032 {1033 "question": "ऐसे लेखकों को दिखाएं जिन्होंने 4000000 से अधिक मूल्य के साथ एक पुस्तक प्रकाशित की है।",1034 "context": "CREATE TABLE publication (Book_ID VARCHAR, Price INTEGER); CREATE TABLE book (Writer VARCHAR, Book_ID VARCHAR)",1035 "answer": "SELECT T1.Writer FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID WHERE T2.Price > 4000000"1036 },1037 {1038 "question": "पहले नाम अनियाह और अंतिम नाम Feest के साथ ग्राहक के लिए फोन और ईमेल क्या है?",1039 "context": "CREATE TABLE Customers (customer_phone VARCHAR, customer_email VARCHAR, customer_first_name VARCHAR, customer_last_name VARCHAR)",1040 "answer": "SELECT customer_phone, customer_email FROM Customers WHERE customer_first_name = \"Aniyah\" AND customer_last_name = \"Feest\""1041 },1042 {1043 "question": "नवीनतम गैर पब्लिक स्कूल के स्थापित वर्ष का पता लगाएं।",1044 "context": "CREATE TABLE university (founded VARCHAR, affiliation VARCHAR)",1045 "answer": "SELECT founded FROM university WHERE affiliation <> 'Public' ORDER BY founded DESC LIMIT 1"1046 },1047 {1048 "question": "लैम्बरटन इमारत में कितने कमरे हैं?",1049 "context": "CREATE TABLE classroom (building VARCHAR)",1050 "answer": "SELECT COUNT(*) FROM classroom WHERE building = 'Lamberton'"1051 },1052 {1053 "question": "सभी चर्च के नाम दिखाएं, सिवाय उन लोगों के जो वर्ष 2015 में शादी हुई थी।",1054 "context": "CREATE TABLE church (name VARCHAR); CREATE TABLE wedding (church_id VARCHAR, year VARCHAR); CREATE TABLE church (name VARCHAR, church_id VARCHAR)",1055 "answer": "SELECT name FROM church EXCEPT SELECT T1.name FROM church AS T1 JOIN wedding AS T2 ON T1.church_id = T2.church_id WHERE T2.year = 2015"1056 },1057 {1058 "question": "मुझे तारीखें दें जब अधिकतम तापमान 85 से अधिक था।",1059 "context": "CREATE TABLE weather (date VARCHAR, max_temperature_f INTEGER)",1060 "answer": "SELECT date FROM weather WHERE max_temperature_f > 85"1061 },1062 {1063 "question": "लैटिन या पॉप शैली से संबंधित पटरियों के मिलीसेकंड में औसत अवधि क्या है?",1064 "context": "CREATE TABLE TRACK (GenreId VARCHAR); CREATE TABLE GENRE (GenreId VARCHAR, Name VARCHAR)",1065 "answer": "SELECT AVG(Milliseconds) FROM GENRE AS T1 JOIN TRACK AS T2 ON T1.GenreId = T2.GenreId WHERE T1.Name = \"Latin\" OR T1.Name = \"Pop\""1066 },1067 {1068 "question": "4 से अधिक ग्राहकों द्वारा उपयोग की जाने वाली नीति प्रकार का पता लगाएं।",1069 "context": "CREATE TABLE available_policies (policy_type_code VARCHAR)",1070 "answer": "SELECT policy_type_code FROM available_policies GROUP BY policy_type_code HAVING COUNT(*) > 4"1071 },1072 {1073 "question": "कम से कम 5 कार्ड के साथ कार्ड प्रकार कोड दिखाएं।",1074 "context": "CREATE TABLE Customers_cards (card_type_code VARCHAR)",1075 "answer": "SELECT card_type_code FROM Customers_cards GROUP BY card_type_code HAVING COUNT(*) >= 5"1076 },1077 {1078 "question": "कार्ड प्रकार कोड और लेनदेन की संख्या दिखाएं।",1079 "context": "CREATE TABLE Financial_transactions (card_id VARCHAR); CREATE TABLE Customers_cards (card_type_code VARCHAR, card_id VARCHAR)",1080 "answer": "SELECT T2.card_type_code, COUNT(*) FROM Financial_transactions AS T1 JOIN Customers_cards AS T2 ON T1.card_id = T2.card_id GROUP BY T2.card_type_code"1081 },1082 {1083 "question": "उच्चतम औसत ट्रस्ट स्कोर के साथ स्रोत उपयोगकर्ता का नाम खोजें।",1084 "context": "CREATE TABLE useracct (name VARCHAR, u_id VARCHAR); CREATE TABLE trust (source_u_id VARCHAR)",1085 "answer": "SELECT T1.name FROM useracct AS T1 JOIN trust AS T2 ON T1.u_id = T2.source_u_id GROUP BY T2.source_u_id ORDER BY AVG(trust) DESC LIMIT 1"1086 },1087 {1088 "question": "किस मूल में अधिकांश उड़ानें हैं?",1089 "context": "CREATE TABLE Flight (origin VARCHAR)",1090 "answer": "SELECT origin FROM Flight GROUP BY origin ORDER BY COUNT(*) DESC LIMIT 1"1091 },1092 {1093 "question": "पटरियों का नाम सूची शैली रॉक या शैली जैज़ से संबंधित है।",1094 "context": "CREATE TABLE genres (id VARCHAR, name VARCHAR); CREATE TABLE tracks (name VARCHAR, genre_id VARCHAR)",1095 "answer": "SELECT T2.name FROM genres AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id WHERE T1.name = \"Rock\" OR T1.name = \"Jazz\""1096 },1097 {1098 "question": "सभी स्कूलों में अधिकतम नामांकन क्या है?",1099 "context": "CREATE TABLE university (Enrollment INTEGER)",1100 "answer": "SELECT MAX(Enrollment) FROM university"1101 },1102 {1103 "question": "कलाकार \"एसी/डीसी\" के सभी एल्बमों का शीर्षक खोजें।",1104 "context": "CREATE TABLE ARTIST (ArtistId VARCHAR, Name VARCHAR); CREATE TABLE ALBUM (ArtistId VARCHAR)",1105 "answer": "SELECT Title FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId = T2.ArtistId WHERE T2.Name = \"AC/DC\""1106 },1107 {1108 "question": "सभी देश और लीग नामों को सूचीबद्ध करें।",1109 "context": "CREATE TABLE League (name VARCHAR, country_id VARCHAR); CREATE TABLE Country (name VARCHAR, id VARCHAR)",1110 "answer": "SELECT T1.name, T2.name FROM Country AS T1 JOIN League AS T2 ON T1.id = T2.country_id"1111 },1112 {1113 "question": "उन पुस्तकों के शीर्षक क्या हैं जिनके लेखक \"एलेन ली\" नहीं हैं?",1114 "context": "CREATE TABLE book (Title VARCHAR, Writer VARCHAR)",1115 "answer": "SELECT Title FROM book WHERE Writer <> \"Elaine Lee\""1116 },1117 {1118 "question": "उन विशिष्ट वर्गों की क्या हैं जो दौड़ में हो सकती हैं?",1119 "context": "CREATE TABLE race (CLASS VARCHAR)",1120 "answer": "SELECT DISTINCT CLASS FROM race"1121 },1122 {1123 "question": "उन संपादकों के नाम दिखाएं जो 3000 से बड़ी बिक्री वाली पत्रिकाओं की समिति में हैं।",1124 "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)",1125 "answer": "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"1126 },1127 {1128 "question": "शार्क के रूप में ट्रैक कब तक तेजी से होता है?",1129 "context": "CREATE TABLE tracks (milliseconds VARCHAR, name VARCHAR)",1130 "answer": "SELECT milliseconds FROM tracks WHERE name = \"Fast As a Shark\""1131 },1132 {1133 "question": "उन सभी मेहमानों के पहले नाम और अंतिम नाम दिखाएं जिनके पास स्टेटस कोड \"कन्फर्म\" के साथ अपार्टमेंट बुकिंग है।",1134 "context": "CREATE TABLE Apartment_Bookings (guest_id VARCHAR, booking_status_code VARCHAR); CREATE TABLE Guests (guest_first_name VARCHAR, guest_last_name VARCHAR, guest_id VARCHAR)",1135 "answer": "SELECT T2.guest_first_name, T2.guest_last_name FROM Apartment_Bookings AS T1 JOIN Guests AS T2 ON T1.guest_id = T2.guest_id WHERE T1.booking_status_code = \"Confirmed\""1136 },1137 {1138 "question": "सभी अपार्टमेंट बुकिंग की गेस्ट फर्स्ट नाम, स्टार्ट डेट्स और एंड डेट्स दिखाएं।",1139 "context": "CREATE TABLE Apartment_Bookings (booking_start_date VARCHAR, guest_id VARCHAR); CREATE TABLE Guests (guest_first_name VARCHAR, guest_id VARCHAR)",1140 "answer": "SELECT T2.guest_first_name, T1.booking_start_date, T1.booking_start_date FROM Apartment_Bookings AS T1 JOIN Guests AS T2 ON T1.guest_id = T2.guest_id"1141 },1142 {1143 "question": "पॉलिसी \"लाइफ इंश्योरेंस\" के तहत ग्राहक फोन नंबर क्या हैं?",1144 "context": "CREATE TABLE available_policies (customer_phone VARCHAR, policy_type_code VARCHAR)",1145 "answer": "SELECT customer_phone FROM available_policies WHERE policy_type_code = \"Life Insurance\""1146 },1147 {1148 "question": "उन स्टेशनों की आईडी क्या हैं जिनमें 37.4 से ऊपर अक्षांश है और 7 से नीचे बाइक की उपलब्धता कभी नहीं थी?",1149 "context": "CREATE TABLE status (id VARCHAR, station_id VARCHAR, lat INTEGER, bikes_available INTEGER); CREATE TABLE station (id VARCHAR, station_id VARCHAR, lat INTEGER, bikes_available INTEGER)",1150 "answer": "SELECT id FROM station WHERE lat > 37.4 EXCEPT SELECT station_id FROM status GROUP BY station_id HAVING MIN(bikes_available) < 7"1151 },1152 {1153 "question": "किसी ऐसे देश के खिलाड़ियों के अलग -अलग पद क्या हैं जिनकी राजधानी डबलिन है?",1154 "context": "CREATE TABLE country (Country_id VARCHAR, Capital VARCHAR); CREATE TABLE match_season (Position VARCHAR, Country VARCHAR)",1155 "answer": "SELECT DISTINCT T2.Position FROM country AS T1 JOIN match_season AS T2 ON T1.Country_id = T2.Country WHERE T1.Capital = \"Dublin\""1156 },1157 {1158 "question": "कितने अलग -अलग सलाहकार सूचीबद्ध हैं?",1159 "context": "CREATE TABLE Student (advisor VARCHAR)",1160 "answer": "SELECT COUNT(DISTINCT advisor) FROM Student"1161 },1162 {1163 "question": "1830 और 1840 के बीच खोले गए चर्चों के लिए आयोजक और नाम दिखाएं।",1164 "context": "CREATE TABLE church (organized_by VARCHAR, name VARCHAR, open_date INTEGER)",1165 "answer": "SELECT organized_by, name FROM church WHERE open_date BETWEEN 1830 AND 1840"1166 },1167 {1168 "question": "हमारे पास कितने डेबिट कार्ड हैं?",1169 "context": "CREATE TABLE Customers_cards (card_type_code VARCHAR)",1170 "answer": "SELECT COUNT(*) FROM Customers_cards WHERE card_type_code = \"Debit\""1171 },1172 {1173 "question": "वर्ष 2014 के बाद सभी शादियों में पुरुष और महिला नामों की जोड़ी दिखाएं",1174 "context": "CREATE TABLE wedding (male_id VARCHAR, female_id VARCHAR, year INTEGER); CREATE TABLE people (name VARCHAR, people_id VARCHAR)",1175 "answer": "SELECT T2.name, T3.name FROM wedding AS T1 JOIN people AS T2 ON T1.male_id = T2.people_id JOIN people AS T3 ON T1.female_id = T3.people_id WHERE T1.year > 2014"1176 },1177 {1178 "question": "उस कर्मचारी का वेतन और नाम क्या है जिसके पास सबसे अधिक विमान प्रमाण पत्र हैं?",1179 "context": "CREATE TABLE Certificate (eid VARCHAR); CREATE TABLE Employee (name VARCHAR, salary VARCHAR, eid VARCHAR)",1180 "answer": "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"1181 },1182 {1183 "question": "प्रशिक्षक का नाम क्या है जो सांख्यिकी विभाग में है और सबसे कम वेतन अर्जित करता है?",1184 "context": "CREATE TABLE instructor (name VARCHAR, dept_name VARCHAR, salary VARCHAR)",1185 "answer": "SELECT name FROM instructor WHERE dept_name = 'Statistics' ORDER BY salary LIMIT 1"1186 },1187 {1188 "question": "मुझे ज़िप कोड दें जहां औसत औसत आर्द्रता 70 से नीचे है और कम से कम 100 यात्राएं हुईं।",1189 "context": "CREATE TABLE weather (zip_code VARCHAR, mean_humidity INTEGER); CREATE TABLE trip (zip_code VARCHAR, mean_humidity INTEGER)",1190 "answer": "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"1191 },1192 {1193 "question": "चुनावों के न्यूनतम और अधिकतम वोट प्रतिशत क्या हैं?",1194 "context": "CREATE TABLE election (Vote_Percent INTEGER)",1195 "answer": "SELECT MIN(Vote_Percent), MAX(Vote_Percent) FROM election"1196 },1197 {1198 "question": "उच्चतम औसत रेटिंग के साथ आइटम का नाम और आईडी खोजें।",1199 "context": "CREATE TABLE item (title VARCHAR, i_id VARCHAR); CREATE TABLE review (i_id VARCHAR, rating INTEGER)",1200 "answer": "SELECT T1.title, T1.i_id FROM item AS T1 JOIN review AS T2 ON T1.i_id = T2.i_id GROUP BY T2.i_id ORDER BY AVG(T2.rating) DESC LIMIT 1"