johneze/chichewa-text2sql
Chichewa Text-to-SQL The first structured Text-to-SQL benchmark for Chichewa, a low-resource Bantu language spoken by over 12 million people in Malawi and neighboring regions. The dataset contains 400 manually curated natural language–SQL pairs in both Chichewa (Nyanja) and English, grounded in a unified relational SQLite database covering five real-world domains from Malawi. Dataset Summary This benchmark was constructed to investigate the adaptation of Large… See the full description on the dataset page: https://huggingface.co/datasets/johneze/chichewa-text2sql.
276
1[
2 {
3 "id": 1,
4 "question_en": "Which district produced the most Maize",
5 "question_ny": "Ndi boma liti komwe anakolola chimanga chambiri?",
6 "sql_statement": "SELECT district, MAX(yield) AS max_yield FROM production WHERE crop = 'Maize';",
7 "sql_result": "[('Lilongwe', 444440.0)]",
8 "difficulty_level": "easy",
9 "table": "production"
10 },
11 {
12 "id": 2,
13 "question_en": "Where was the most rice harvested?",
14 "question_ny": "Ndi boma liti komwe anakolola mpunga wambiri?",
15 "sql_statement": "SELECT district, MAX(yield) AS max_yield FROM production WHERE crop = 'Rice';",
16 "sql_result": "[('Karonga', 46385.0)]",
17 "difficulty_level": "easy",
18 "table": "production"
19 },
20 {
21 "id": 3,
22 "question_en": "Which are the top 5 maize producing districts?",
23 "question_ny": "Ndi maboma ati asanu omwe amakolola chimanga chambiri?",
24 "sql_statement": "SELECT district FROM production WHERE crop = 'Maize' ORDER BY yield DESC LIMIT 5;",
25 "sql_result": "[('Lilongwe',), ('Kasungu',), ('Dowa',), ('Mzimba',), ('Mchinji',)]",
26 "difficulty_level": "medium",
27 "table": "production"
28 },
29 {
30 "id": 4,
31 "question_en": "Which crops did well in Rumphi in terms of yield? Give me the top 5",
32 "question_ny": "Ndi mbeu ziti zisanu zomwe anakolola mochuluka mu boma la Rumphi? Pelekani zisanu zoyambilila",
33 "sql_statement": "SELECT crop FROM production WHERE district = 'Rumphi' ORDER BY yield DESC LIMIT 5;",
34 "sql_result": "[('Cassava',), ('Maize',), ('Sweet potatoes',), ('Bananas',), ('Mangoes',)]",
35 "difficulty_level": "medium",
36 "table": "production"
37 },
38 {
39 "id": 5,
40 "question_en": "Which are the top 5 districts that harvested the most tobacco?",
41 "question_ny": "Ndi ma boma ati asanu omwe anakolola fodya kwambiri?",
42 "sql_statement": "SELECT district FROM production WHERE crop = 'Tobacco' ORDER BY yield DESC LIMIT 5;",
43 "sql_result": "[('Lilongwe',), ('Dowa',), ('Nkhotakota',), ('Mchinji',), ('Rumphi',)]",
44 "difficulty_level": "medium",
45 "table": "production"
46 },
47 {
48 "id": 6,
49 "question_en": "Which are the top five districts by soya production?",
50 "question_ny": "Ndi ma boma ati asanu omwe anakolola soya kwambiri?",
51 "sql_statement": "SELECT district FROM production WHERE crop = 'Soy beans' ORDER BY yield DESC LIMIT 5;",
52 "sql_result": "[('Lilongwe',), ('Mchinji',), ('Ntchisi',), ('Kasungu',), ('Mzimba',)]",
53 "difficulty_level": "medium",
54 "table": "production"
55 },
56 {
57 "id": 7,
58 "question_en": "Which district produced more bananas: Lilongwe or Kasungu?",
59 "question_ny": "Ndi boma liti lomwe linakolola nthochi zambiri: Lilongwe kapena Kasungu?",
60 "sql_statement": "SELECT district, SUM(yield) AS Sum_yield FROM production\nWHERE crop = 'Bananas'\n AND district IN ('Lilongwe', 'Kasungu');",
61 "sql_result": "[('Kasungu', 225545.0)]",
62 "difficulty_level": "hard",
63 "table": "production"
64 },
65 {
66 "id": 8,
67 "question_en": "Which district produced the most Macadamia in the 2023-2024 season?",
68 "question_ny": "Ndi boma liti lomwe linakolola makadamia ambiri mu nyengo ya 2023-2024?",
69 "sql_statement": "SELECT district, SUM(yield) AS Sum_yield FROM production WHERE crop = 'Macademia' AND season = '2023-2024';",
70 "sql_result": "[('Balaka', 6916.0)]",
71 "difficulty_level": "easy",
72 "table": "production"
73 },
74 {
75 "id": 9,
76 "question_en": "What was the yield of apples in dowa?",
77 "question_ny": "Ndi ma apulosi ochuluka bwanji omwe anakololedwa ku Dowa mu nyengo yathayi?",
78 "sql_statement": "SELECT Yield FROM production WHERE District = 'Dowa' AND Crop = 'Apples';",
79 "sql_result": "[(0.0,)]",
80 "difficulty_level": "easy",
81 "table": "production"
82 },
83 {
84 "id": 10,
85 "question_en": "What was the total yield of Velvet beans in the 2023-2024 season?",
86 "question_ny": "Ndi nyemba za kalongonda zochuluka bwanji zomwe zinakololedwa mu nyengo ya 2023-2024?",
87 "sql_statement": "SELECT SUM(Yield) as Total_Yield FROM production WHERE Crop = 'Velvet beans' AND Season = '2023-2024';",
88 "sql_result": "[(18054.0,)]",
89 "difficulty_level": "easy",
90 "table": "production"
91 },
92 {
93 "id": 11,
94 "question_en": "What was the yield of wheat in Nkhotakota?",
95 "question_ny": "Ndi tiligu ochuluka bwanj adakololedwa ku Nkhotakota?",
96 "sql_statement": "SELECT Yield FROM production WHERE District = 'Nkhotakota' AND Crop = 'Wheat';",
97 "sql_result": "[(0.0,)]",
98 "difficulty_level": "easy",
99 "table": "production"
100 },
101 {
102 "id": 12,
103 "question_en": "What was the yield of maize in Ntcheu?",
104 "question_ny": "Ndi chimanga chochuluka bwanj chidakololedwa ku Ntcheu?",
105 "sql_statement": "SELECT Yield FROM production WHERE District = 'Ntcheu' AND Crop = 'Maize';",
106 "sql_result": "[(81248.0,)]",
107 "difficulty_level": "easy",
108 "table": "production"
109 },
110 {
111 "id": 13,
112 "question_en": "Which crop had the highest yield in Ntchisi during 2023-2024?",
113 "question_ny": "Ndi mbewu yanji idali ndi zokolola zochuluka ku Ntchisi mu 2023-2024?",
114 "sql_statement": "SELECT crop, MAX(yield) AS max_yield FROM production WHERE district = 'Ntchisi' AND season = '2023-2024';",
115 "sql_result": "[('Maize', 185021.0)]",
116 "difficulty_level": "easy",
117 "table": "production"
118 },
119 {
120 "id": 14,
121 "question_en": "Which district produced the most Sweet potatoes in the 2023-2024 season?",
122 "question_ny": "Ndi boma liti lidakolola mbatata zochuluka mu nyengo ya 2023-2024?",
123 "sql_statement": "SELECT district, SUM(yield) AS Sum_yield FROM production WHERE crop = 'Sweet potatoes' AND season = '2023-2024';",
124 "sql_result": "[('Balaka', 6659584.02)]",
125 "difficulty_level": "easy",
126 "table": "production"
127 },
128 {
129 "id": 15,
130 "question_en": "Which district produced the most Okra in the 2023-2024 season?",
131 "question_ny": "Ndi boma liti lidakolola thelele lochuluka mu nyengo ya 2023-2024?",
132 "sql_statement": "SELECT District, MAX(Yield) AS Max_Yield FROM production WHERE Crop = 'Okra' AND Season = '2023-2024';",
133 "sql_result": "[('Mulanje', 757.0)]",
134 "difficulty_level": "easy",
135 "table": "production"
136 },
137 {
138 "id": 16,
139 "question_en": "Which district produced the most Peaches in the 2023-2024 season?",
140 "question_ny": "Ndi boma liti lidakolola pichesi ochuluka mu nyengo ya 2023-2024?",
141 "sql_statement": "SELECT District, MAX(Yield) AS Max_Yield FROM production WHERE Crop = 'Peaches' AND Season = '2023-2024';",
142 "sql_result": "[('Thyolo', 4179.0)]",
143 "difficulty_level": "easy",
144 "table": "production"
145 },
146 {
147 "id": 17,
148 "question_en": "Which crop had the highest yield in Nsanje during 2023-2024?",
149 "question_ny": "Ndi mbewu yanji idali ndi zokolola zochuluka ku Nsanje mu 2023-2024?",
150 "sql_statement": "SELECT Crop, MAX(Yield) AS Max_Yield FROM production WHERE District = 'Nsanje' AND Season = '2023-2024';",
151 "sql_result": "[('Sweet potatoes', 145733.0)]",
152 "difficulty_level": "easy",
153 "table": "production"
154 },
155 {
156 "id": 18,
157 "question_en": "What was the yield of guava in chitipa?",
158 "question_ny": "Ndi gwafa ochuluka bwanji adakololedwa ku Chitipa?",
159 "sql_statement": "SELECT Yield FROM production WHERE District = 'Chitipa' AND Crop = 'Guava';",
160 "sql_result": "[(1337.0,)]",
161 "difficulty_level": "easy",
162 "table": "production"
163 },
164 {
165 "id": 19,
166 "question_en": "Which district produced the most Avocado pear?",
167 "question_ny": "Ndi chigawo chiti chidakolola mapeyala ochuluka kwambili?",
168 "sql_statement": "SELECT District, MAX(Yield) AS Max_Yield FROM production WHERE Crop = 'Avocado pear';",
169 "sql_result": "[('Thyolo', 26971.0)]",
170 "difficulty_level": "easy",
171 "table": "production"
172 },
173 {
174 "id": 20,
175 "question_en": "Which crop had the highest yield in Thyolo during 2023-2024?",
176 "question_ny": "Ndi mbewu iti idali ndi zokolola zochuluka ku Thyolo mu 2023-2024?",
177 "sql_statement": "SELECT Crop, MAX(Yield) AS Max_Yield FROM production WHERE District = 'Thyolo' AND Season = '2023-2024';",
178 "sql_result": "[('Sweet potatoes', 454039.0)]",
179 "difficulty_level": "easy",
180 "table": "production"
181 },
182 {
183 "id": 21,
184 "question_en": "Which crop had the highest yield in Dedza during 2023-2024?",
185 "question_ny": "Ndi mbewu iti idali ndi zokolola zochuluka ku Dedza mu 2023-2024?",
186 "sql_statement": "SELECT Crop, MAX(Yield) AS Max_Yield FROM production WHERE District = 'Dedza' AND Season = '2023-2024';",
187 "sql_result": "[('Sweet potatoes', 418387.0)]",
188 "difficulty_level": "easy",
189 "table": "production"
190 },
191 {
192 "id": 22,
193 "question_en": "Which crop had the highest yield in Nkhata Bay during 2023-2024?",
194 "question_ny": "Ndi mbewu iti idali ndi zokolola zochuluka ku Nkhata mu 2023-2024?",
195 "sql_statement": "SELECT Crop, MAX(Yield) AS Max_Yield FROM production WHERE District = 'Nkhata Bay' AND Season = '2023-2024';",
196 "sql_result": "[('Cassava', 805166.0)]",
197 "difficulty_level": "easy",
198 "table": "production"
199 },
200 {
201 "id": 23,
202 "question_en": "What was the yield of ground beans in ntchisi?",
203 "question_ny": "Ndi mzama zochuluka bwanj zidakololedwa ku Ntchisi nyengo ya 2023-2024?",
204 "sql_statement": "SELECT Yield FROM production WHERE District = 'Ntchisi' AND Crop = 'Ground beans' AND Season = '2023-2024';",
205 "sql_result": "[(224.2,)]",
206 "difficulty_level": "easy",
207 "table": "production"
208 },
209 {
210 "id": 24,
211 "question_en": "What was the total yield of Paprika in the 2023-2024 season?",
212 "question_ny": "Kodi zokolola zonse pamodzi za Paprika zidali zochuluka bwanji mu nyengo ya 2023-2024?",
213 "sql_statement": "SELECT SUM(Yield) as Total_Yield FROM production WHERE Crop = 'Paprika' AND Season = '2023-2024';",
214 "sql_result": "[(1047.86,)]",
215 "difficulty_level": "easy",
216 "table": "production"
217 },
218 {
219 "id": 25,
220 "question_en": "Which crop had the highest yield in Dowa during 2023-2024?",
221 "question_ny": "Ndi mbewu iti idali ndi zokolola zambili ku Dowa mu 2023-2024?",
222 "sql_statement": "SELECT Crop, MAX(Yield) AS Max_Yield FROM production WHERE District = 'Dowa' AND Season = '2023-2024';",
223 "sql_result": "[('Sweet potatoes', 657130.0)]",
224 "difficulty_level": "easy",
225 "table": "production"
226 },
227 {
228 "id": 26,
229 "question_en": "What was the total yield of Cassava in the 2023-2024 season?",
230 "question_ny": "Kodi zokolola zonse pamodzi za chinangwa zidali zochuluka bwanji mu nyengo ya 2023-2024?",
231 "sql_statement": "SELECT SUM(Yield) as Total_Yield FROM production WHERE Crop = 'Cassava' AND Season = '2023-2024';",
232 "sql_result": "[(5404033.29,)]",
233 "difficulty_level": "easy",
234 "table": "production"
235 },
236 {
237 "id": 27,
238 "question_en": "What was total cabbage yield in the country?",
239 "question_ny": "Kodi zokolola zonse za kabichi m'dziko muno zinali zochuluka bwanji?",
240 "sql_statement": "SELECT SUM(Yield) as Total_Yield FROM production WHERE Crop = 'Cabbage';",
241 "sql_result": "[(214782.29,)]",
242 "difficulty_level": "easy",
243 "table": "production"
244 },
245 {
246 "id": 28,
247 "question_en": "Give me district with highest chillies yield?",
248 "question_ny": "Ndiuzeni boma lomwe linakolola tsabola wambiri",
249 "sql_statement": "SELECT District, MAX(Yield) AS Max_Yield FROM production\nWHERE Crop = 'Chillies';",
250 "sql_result": "[('Mulanje', 710.0)]",
251 "difficulty_level": "easy",
252 "table": "production"
253 },
254 {
255 "id": 29,
256 "question_en": "Which district had the highest cotton yield?",
257 "question_ny": "Ndi boma liti lomwe linakolola thonje lambiri?",
258 "sql_statement": "SELECT district, MAX(yield) AS max_yield FROM production WHERE crop = 'Cotton';",
259 "sql_result": "[('Nsanje', 4751.0)]",
260 "difficulty_level": "easy",
261 "table": "production"
262 },
263 {
264 "id": 30,
265 "question_en": "What was the yield of cassava in mangochi?",
266 "question_ny": "Ndi chinangwa chochuluka bwanji chidakololedwa ku Mangochi mu nyengo ya 2023-2024?",
267 "sql_statement": "SELECT yield FROM production WHERE district = 'Mangochi' AND crop = 'Cassava' AND season = '2023-2024';",
268 "sql_result": "[(0.0,)]",
269 "difficulty_level": "easy",
270 "table": "production"
271 },
272 {
273 "id": 31,
274 "question_en": "Which crop recorded the highest yield in Kasungu in the 2023-2024 season?",
275 "question_ny": "Ndi mbewu iti yomwe inakololedwa mochuluka ku Kasungu mu nyengo ya 2023-2024?",
276 "sql_statement": "SELECT crop, MAX(yield) AS max_yield FROM production WHERE district = 'Kasungu' AND season = '2023-2024';",
277 "sql_result": "[('Cassava', 597293.0)]",
278 "difficulty_level": "easy",
279 "table": "production"
280 },
281 {
282 "id": 32,
283 "question_en": "What was the total rice production in the country during the 2023-2024 season?",
284 "question_ny": "Kodi mpunga onse pamodzi udakololedwa ochulukwa bwanji mdziko muno mu nyengo ya 2023-2024?",
285 "sql_statement": "SELECT SUM(yield) FROM production WHERE crop = 'Rice' AND season = '2023-2024';",
286 "sql_result": "[(138314.762,)]",
287 "difficulty_level": "easy",
288 "table": "production"
289 },
290 {
291 "id": 33,
292 "question_en": "Which district had the lowest maize yield in the 2023-2024 season?",
293 "question_ny": "Ndi boma liti limene lonakolola chimanga chochepa mu nyengo ya 2023-2024?",
294 "sql_statement": "SELECT district, MAX(yield) AS max_yield FROM production WHERE crop = 'Maize' AND season = '2023-2024';",
295 "sql_result": "[('Lilongwe', 444440.0)]",
296 "difficulty_level": "easy",
297 "table": "production"
298 },
299 {
300 "id": 34,
301 "question_en": "What was the cassava yield in Salima",
302 "question_ny": "Ku Salima anakolola chinangwa chochuluka bwanji?",
303 "sql_statement": "SELECT yield FROM production WHERE district = 'Salima' AND crop = 'Cassava';",
304 "sql_result": "[(44252.0,)]",
305 "difficulty_level": "easy",
306 "table": "production"
307 },
308 {
309 "id": 35,
310 "question_en": "Which crop had the highest yield in Mzimba?",
311 "question_ny": "Ndi mbewu iti yomwe inali ndi zokolola zambiri ku Mzimba?",
312 "sql_statement": "SELECT crop, MAX(yield) AS max_yield FROM production WHERE district = 'Mzimba';",
313 "sql_result": "[('Cassava', 428043.29)]",
314 "difficulty_level": "easy",
315 "table": "production"
316 },
317 {
318 "id": 36,
319 "question_en": "What was the yield of groundnuts in dedza?",
320 "question_ny": "Ndi mtedza wochuluka bwanji womwe unalimidwa ku Dedza mu nyengo ya 2023-2024?",
321 "sql_statement": "SELECT yield FROM production WHERE district = 'Dedza' AND crop = 'Groundnuts' AND season = '2023-2024';",
322 "sql_result": "[(30857.0,)]",
323 "difficulty_level": "easy",
324 "table": "production"
325 },
326 {
327 "id": 37,
328 "question_en": "Which district produced the most coffee",
329 "question_ny": "Ndi boma liti limene linakolola khofi wambiri?",
330 "sql_statement": "SELECT district, MAX(yield) AS max_yield FROM production WHERE crop = 'Coffee';",
331 "sql_result": "[('Chitipa', 7923.0)]",
332 "difficulty_level": "easy",
333 "table": "production"
334 },
335 {
336 "id": 38,
337 "question_en": "List the top three crops by yield in Karonga for the 2023-2024 season.",
338 "question_ny": "Tchulani mbewu zitatu zomwe zinali ndi zokolola zochuluka ku Karonga mu nyengo ya 2023-2024.",
339 "sql_statement": "SELECT crop FROM production WHERE district = 'Karonga' AND season = '2023-2024' ORDER BY yield DESC LIMIT 3;",
340 "sql_result": "[('Cassava',), ('Sweet potatoes',), ('Maize',)]",
341 "difficulty_level": "medium",
342 "table": "production"
343 },
344 {
345 "id": 39,
346 "question_en": "What was the total tobacco production across all districts in the 2023-2024 season?",
347 "question_ny": "Kodi zokolola zonse pamodzi za fodya m'maboma onse zinali zochuluka bwanji mu nyengo ya 2023-2024?",
348 "sql_statement": "SELECT SUM(yield) FROM production WHERE crop = 'Tobacco' AND season = '2023-2024';",
349 "sql_result": "[(89616.8275,)]",
350 "difficulty_level": "easy",
351 "table": "production"
352 },
353 {
354 "id": 40,
355 "question_en": "Which district had higher soybean yield between Kasungu and Lilongwe in the 2023-2024 season?",
356 "question_ny": "Pakati pa Kasungu ndi Lilongwe, ndi boma liti lomwe linakolola soya wochuluka mu nyengo ya 2023-2024?",
357 "sql_statement": "SELECT district, MAX(yield) AS max_yield FROM production WHERE crop = 'Soy beans' AND season = '2023-2024' AND district IN ('Kasungu','Lilongwe');",
358 "sql_result": "[('Lilongwe', 29087.0)]",
359 "difficulty_level": "hard",
360 "table": "production"
361 },
362 {
363 "id": 41,
364 "question_en": "Which crop had the lowest yield in Mangochi?",
365 "question_ny": "Ndi mbewu iti yomwe anakolola zochepa kwambiri ku Mangochi?",
366 "sql_statement": "SELECT crop, MAX(yield) AS max_yield FROM production WHERE district = 'Mangochi';",
367 "sql_result": "[('Mangoes', 150330.0)]",
368 "difficulty_level": "easy",
369 "table": "production"
370 },
371 {
372 "id": 42,
373 "question_en": "What was the average yield of rice across all districts in the 2023-2024 season?",
374 "question_ny": "Kodi ndi mulingo wapakatikati otani omwe mpunga unakololedwa ma boma onse mu nthawi ya 2023-2024",
375 "sql_statement": "SELECT AVG(yield) FROM production WHERE crop = 'Rice' AND season = '2023-2024';",
376 "sql_result": "[(4939.81,)]",
377 "difficulty_level": "easy",
378 "table": "production"
379 },
380 {
381 "id": 43,
382 "question_en": "Which districts had maize yields above the national average in the 2023-2024 season?",
383 "question_ny": "Ndi ma boma ati anakhalapo ndi chimanga choposa mlingo wadziko lonse pa nthawi ya 2023-2024?",
384 "sql_statement": "SELECT district FROM production WHERE crop = 'Maize' AND season = '2023-2024' AND yield > (SELECT AVG(yield) FROM production WHERE crop = 'Maize' AND season = '2023-2024');",
385 "sql_result": "[('Dedza',), ('Dowa',), ('Kasungu',), ('Lilongwe',), ('Mchinji',), ('Mzimba',), ('Ntchisi',), ('Zomba',)]",
386 "difficulty_level": "hard",
387 "table": "production"
388 },
389 {
390 "id": 44,
391 "question_en": "Which crop had the highest total production nationwide in the 2023-2024 season?",
392 "question_ny": "Ndi mbewu iti yomwe inali ndi zokolola zochuluka mu nthawi ya 2023-2024?",
393 "sql_statement": "SELECT crop, SUM(yield) AS Sum_yield FROM production WHERE season = '2023-2024';",
394 "sql_result": "[('Maize', 22780067.78)]",
395 "difficulty_level": "easy",
396 "table": "production"
397 },
398 {
399 "id": 45,
400 "question_en": "Which district had the second lowest maize yield in the 2023-2024 season?",
401 "question_ny": "Ndi boma liti lomwe lili la chiwili limene linali ndi zokolola za chimanga zochepa mu nyengo ya 2023-2024?",
402 "sql_statement": "SELECT district FROM production WHERE crop = 'Maize' AND season = '2023-2024' ORDER BY yield ASC LIMIT 1 OFFSET 1;",
403 "sql_result": "[('Mwanza',)]",
404 "difficulty_level": "medium",
405 "table": "production"
406 },
407 {
408 "id": 46,
409 "question_en": "Which crops were produced in all districts during the 2023-2024 season?",
410 "question_ny": "Ndi mbewu ziti zomwe zidakololedwa m'maboma onse mu nyengo ya 2023-2024?",
411 "sql_statement": "SELECT crop FROM production WHERE season = '2023-2024'GROUP BY crop HAVING COUNT(DISTINCT district) = (SELECT COUNT(DISTINCT district) FROM production WHERE season ='2023-2024');",
412 "sql_result": "[('Apples',), ('Avocado pear',), ('Bananas',), ('Beans',), ('Cabbage',), ('Cassava',), ('Chick peas',), ('Chillies',), ('Coffee',), ('Cotton',), ('Cow peas',), ('Cucumber',), ('Dolichus beans',), ('Egg plants',), ('Field peas',), ('Flue cured',), ('Grams',), ('Grape fruits',), ('Ground beans',), ('Groundnuts',), ('Guava',), ('Lemons',), ('Macademia',), ('Maize',), ('Mangoes',), ('Millet',), ('Okra',), ('Onions',), ('Oranges',), ('Paprika',), ('Pawpaws',), ('Peaches',), ('Pigeon peas',), ('Pineapples',), ('Potatoes',), ('Rice',), ('Sesame',), ('Sorghum',), ('Soy beans',), ('Sunflower',), ('Sweet potatoes',), ('Tangerines',), ('Tobacco',), ('Tomatoes',), ('Velvet beans',), ('Wheat',)]",
413 "difficulty_level": "hard",
414 "table": "production"
415 },
416 {
417 "id": 47,
418 "question_en": "How much Maize in total was harvested in the country?",
419 "question_ny": "Ndi chimanga chochuluka motani chomwe chidakololedwa mu dziko muno?",
420 "sql_statement": "SELECT SUM(Yield) as Total_Yield FROM production WHERE Crop = 'Maize';",
421 "sql_result": "[(3111592.95,)]",
422 "difficulty_level": "easy",
423 "table": "production"
424 },
425 {
426 "id": 48,
427 "question_en": "How much Cotton in total was harvested in the country?",
428 "question_ny": "Ndi thonje lochuluka bwanji lomwe lidakololedwa mdziko muno?",
429 "sql_statement": "SELECT SUM(Yield) as Total_Yield FROM production WHERE Crop = 'Cotton';",
430 "sql_result": "[(8920.0,)]",
431 "difficulty_level": "easy",
432 "table": "production"
433 },
434 {
435 "id": 49,
436 "question_en": "Which district had the highest total tomatoes yield across all seasons?",
437 "question_ny": "Ndi boma liti lomwe linakolola tomato wochuluka munyengo zonse?",
438 "sql_statement": "SELECT district, SUM(yield) AS Sum_yield FROM production WHERE crop = 'Tomatoes';",
439 "sql_result": "[('Balaka', 565840.67)]",
440 "difficulty_level": "easy",
441 "table": "production"
442 },
443 {
444 "id": 50,
445 "question_en": "What was the total soybean production in the 2023-2024 season?",
446 "question_ny": "Kodi soya anakololedwa wochuluka bwanji mu nyengo ya 2023-2024?",
447 "sql_statement": "SELECT SUM(yield) FROM production WHERE crop = 'Soy beans' AND season = '2023-2024';",
448 "sql_result": "[(179075.525,)]",
449 "difficulty_level": "easy",
450 "table": "production"
451 },
452 {
453 "id": 51,
454 "question_en": "Which district produced the least cassava in the 2023-2024 season?",
455 "question_ny": "Ndi boma liti lomwe linakolola chinangwa chochepa kwambiri mu nyengo ya 2023-2024?",
456 "sql_statement": "SELECT district, MAX(yield) AS max_yield FROM production WHERE crop = 'Cassava' AND season = '2023-2024';",
457 "sql_result": "[('Nkhotakota', 886353.0)]",
458 "difficulty_level": "easy",
459 "table": "production"
460 },
461 {
462 "id": 52,
463 "question_en": "What was the yield of rice in salima?",
464 "question_ny": "Kodi ndi mpunga wochuluka bwanji unakololedwa ku Salima mu nyengo ya 2023-2024?",
465 "sql_statement": "SELECT yield FROM production WHERE district = 'Salima' AND crop = 'Rice' AND season = '2023-2024';",
466 "sql_result": "[(9322.0,)]",
467 "difficulty_level": "easy",
468 "table": "production"
469 },
470 {
471 "id": 53,
472 "question_en": "Which crop had the lowest non-zero yield in Dedza in the 2023-2024 season?",
473 "question_ny": "Ndi mbewu iti yomwe inali ndi zokolola zochepetsetsa ku Dedza mu nyengo ya 2023-2024?",
474 "sql_statement": "SELECT crop, MAX(yield) AS max_yield FROM production WHERE district = 'Dedza' AND season = '2023-2024' AND yield > 0;",
475 "sql_result": "[('Sweet potatoes', 418387.0)]",
476 "difficulty_level": "easy",
477 "table": "production"
478 },
479 {
480 "id": 54,
481 "question_en": "What is the average maize yield per district in the 2023-2024 season?",
482 "question_ny": "Kodi ndi mlingo wapakatikati wanji wa chimanga womwe unakololedwa boma lililonse mu nyengo ya 2023-2024?",
483 "sql_statement": "SELECT AVG(yield) FROM production WHERE crop = 'Maize' AND season = '2023-2024';",
484 "sql_result": "[(111128.31975000001,)]",
485 "difficulty_level": "easy",
486 "table": "production"
487 },
488 {
489 "id": 55,
490 "question_en": "Which district produced more groundnuts in 2023-2024: Mchinji or Kasungu?",
491 "question_ny": "Ndi boma liti lomwe linalima mtedza wochuluka mu 2023-2024: Mchinji kapena Kasungu, ?",
492 "sql_statement": "SELECT district, MAX(yield) AS max_yield FROM production WHERE crop = 'Groundnuts' AND season = '2023-2024' AND district IN ('Mchinji','Kasungu');",
493 "sql_result": "[('Mchinji', 51465.0)]",
494 "difficulty_level": "hard",
495 "table": "production"
496 },
497 {
498 "id": 56,
499 "question_en": "Which districts produced tobacco in the 2023-2024 season?",
500 "question_ny": "Ndi maboma ati omwe analima fodya mu nyengo ya 2023-2024?",
501 "sql_statement": "SELECT DISTINCT district FROM production WHERE crop = 'Tobacco' AND season = '2023-2024';",
502 "sql_result": "[('Balaka',), ('Blantyre',), ('Chikwawa',), ('Chiradzulu',), ('Chitipa',), ('Dedza',), ('Dowa',), ('Karonga',), ('Kasungu',), ('Likoma',), ('Lilongwe',), ('Machinga',), ('Mangochi',), ('Mchinji',), ('Mulanje',), ('Mzimba',), ('Neno',), ('Nkhata Bay',), ('Nkhotakota',), ('Nsanje',), ('Ntcheu',), ('Ntchisi',), ('Phalombe',), ('Rumphi',), ('Salima',), ('Thyolo',), ('Zomba',), ('Mwanza',)]",
503 "difficulty_level": "easy",
504 "table": "production"
505 },
506 {
507 "id": 57,
508 "question_en": "What was the total production of sweet potatoes in the country in 2023-2024?",
509 "question_ny": "Kodi ndi mbatata yochuluka bwanji yonse pamodzi idakololedwa m'dziko muno mu 2023-2024?",
510 "sql_statement": "SELECT SUM(yield) FROM production WHERE crop = 'Sweet potatoes' AND season = '2023-2024';",
511 "sql_result": "[(6659584.02,)]",
512 "difficulty_level": "easy",
513 "table": "production"
514 },
515 {
516 "id": 58,
517 "question_en": "Which district had the highest number of different crops produced in the 2023-2024 season?",
518 "question_ny": "Ndi boma liti lomwe linalima mitundu yambili ya mbewu mu nyengo ya 2023-2024?",
519 "sql_statement": "SELECT district, COUNT(DISTINCT crop) FROM production WHERE season = '2023-2024' GROUP BY district ORDER BY COUNT(DISTINCT crop) DESC LIMIT 1;",
520 "sql_result": "[('Zomba', 46)]",
521 "difficulty_level": "medium",
522 "table": "production"
523 },
524 {
525 "id": 59,
526 "question_en": "Which crop had the highest total production nationwide in the 2023-2024 season?",
527 "question_ny": "Ndi mbewu iti yomwe inali ndi zokolola zochuluka m'dziko muno mu nyengo ya 2023-2024?",
528 "sql_statement": "SELECT crop, SUM(yield) AS Sum_yield FROM production WHERE season = '2023-2024';",
529 "sql_result": "[('Maize', 22780067.78)]",
530 "difficulty_level": "easy",
531 "table": "production"
532 },
533 {
534 "id": 60,
535 "question_en": "How many districts produced maize in the 2023-2024 season?",
536 "question_ny": "Kodi ndi maboma angati omwe analima chimanga mu nyengo ya 2023-2024?",
537 "sql_statement": "SELECT COUNT(DISTINCT district) FROM production WHERE crop = 'Maize' AND season = '2023-2024' AND yield > 0;",
538 "sql_result": "[(28,)]",
539 "difficulty_level": "medium",
540 "table": "production"
541 },
542 {
543 "id": 61,
544 "question_en": "What is the average rice yield across all districts in the 2023-2024 season?",
545 "question_ny": "Kodi ndi mlingo wapakatikati uti wa zokolola za mpunga m'maboma onse mu nyengo ya 2023-2024?",
546 "sql_statement": "SELECT AVG(yield) FROM production WHERE crop = 'Rice' AND season = '2023-2024';",
547 "sql_result": "[(4939.8129285714285,)]",
548 "difficulty_level": "easy",
549 "table": "production"
550 },
551 {
552 "id": 62,
553 "question_en": "What was the total millet production in the country in 2023-2024?",
554 "question_ny": "Kodi ndi mapira ochuluka bwanji onse pamodzi omwe anakololedwa m'dziko muno mu nyengo ya 2023-2024?",
555 "sql_statement": "SELECT SUM(yield) FROM production WHERE crop = 'Millet' AND season = '2023-2024';",
556 "sql_result": "[(37928.501000000004,)]",
557 "difficulty_level": "easy",
558 "table": "production"
559 },
560 {
561 "id": 63,
562 "question_en": "Which crops were produced in Ntcheu during the 2023-2024 season?",
563 "question_ny": "Ndi mbewu ziti zomwe zinalimidwa ku Ntcheu mu nyengo ya 2023-2024?",
564 "sql_statement": "SELECT DISTINCT crop FROM production WHERE district = 'Ntcheu'AND season ='2023-2024' AND yield > 0;",
565 "sql_result": "[('Maize',), ('Beans',), ('Cow peas',), ('Soy beans',), ('Ground beans',), ('Rice',), ('Pigeon peas',), ('Field peas',), ('Wheat',), ('Millet',), ('Sorghum',), ('Groundnuts',), ('Cassava',), ('Sweet potatoes',), ('Tobacco',), ('Cotton',)]",
566 "difficulty_level": "easy",
567 "table": "production"
568 },
569 {
570 "id": 64,
571 "question_en": "Which crop had the lowest total production nationwide in the 2023-2024 season?",
572 "question_ny": "Ndi mbewu iti yomwe inali ndi zokolola zochepa kwambiri m'dziko muno mu nyengo ya 2023-2024?",
573 "sql_statement": "SELECT crop, SUM(yield) AS Sum_yield FROM production WHERE season = '2023-2024' AND yield > 0;",
574 "sql_result": "[('Maize', 22780067.78)]",
575 "difficulty_level": "easy",
576 "table": "production"
577 },
578 {
579 "id": 65,
580 "question_en": "How many different crops were produced nationally in the 2023-2024 season?",
581 "question_ny": "Kodi ndi mitundu iti ya mbewu inalimidwa mdziko muno mu nyengo ya 2023-2024?",
582 "sql_statement": "SELECT COUNT(DISTINCT crop) FROM production WHERE season = '2023-2024';",
583 "sql_result": "[(46,)]",
584 "difficulty_level": "medium",
585 "table": "production"
586 },
587 {
588 "id": 66,
589 "question_en": "Which crops had an average yield above 500 in the 2023-2024 season?",
590 "question_ny": "Ndi mbewu ziti zomwe zinali ndi zokolola zapakatikati zoposa 500 mu nyengo ya 2023-2024?",
591 "sql_statement": "SELECT crop FROM production WHERE season = '2023-2024' GROUP BY crop HAVING AVG(yield) > 500;",
592 "sql_result": "[('Apples',), ('Avocado pear',), ('Bananas',), ('Beans',), ('Cabbage',), ('Cassava',), ('Coffee',), ('Cow peas',), ('Cucumber',), ('Egg plants',), ('Flue cured',), ('Groundnuts',), ('Guava',), ('Lemons',), ('Maize',), ('Mangoes',), ('Millet',), ('Onions',), ('Oranges',), ('Pawpaws',), ('Pigeon peas',), ('Pineapples',), ('Potatoes',), ('Rice',), ('Sesame',), ('Sorghum',), ('Soy beans',), ('Sunflower',), ('Sweet potatoes',), ('Tangerines',), ('Tobacco',), ('Tomatoes',), ('Velvet beans',)]",
593 "difficulty_level": "hard",
594 "table": "production"
595 },
596 {
597 "id": 67,
598 "question_en": "Which districts produced both maize and rice in the 2023-2024 season?",
599 "question_ny": "Ndi maboma ati omwe analima chimanga ndi mpunga mu nyengo ya 2023-2024?",
600 "sql_statement": "SELECT district FROM production WHERE season = '2023-2024'GROUP BY district HAVING SUM(CASE WHEN crop ='Maize'THEN 1 ELSE 0 END) > 0 AND SUM(CASE WHEN crop ='Rice' THEN 1 ELSE 0 END) > 0;",
601 "sql_result": "[('Balaka',), ('Blantyre',), ('Chikwawa',), ('Chiradzulu',), ('Chitipa',), ('Dedza',), ('Dowa',), ('Karonga',), ('Kasungu',), ('Likoma',), ('Lilongwe',), ('Machinga',), ('Mangochi',), ('Mchinji',), ('Mulanje',), ('Mwanza',), ('Mzimba',), ('Neno',), ('Nkhata Bay',), ('Nkhotakota',), ('Nsanje',), ('Ntcheu',), ('Ntchisi',), ('Phalombe',), ('Rumphi',), ('Salima',), ('Thyolo',), ('Zomba',)]",
602 "difficulty_level": "hard",
603 "table": "production"
604 },
605 {
606 "id": 68,
607 "question_en": "Which crop showed the largest variation in yield across districts in the 2023-2024 season?",
608 "question_ny": "Ndi mbewu iti yomwe inaonetsa kusiyana kwakukulu pa zokolola m'maboma onse mu zaka za 2023-2024?",
609 "sql_statement": "SELECT crop, (MAX(yield) - MIN(yield)) FROM production WHERE season = '2023-2024' GROUP BY crop ORDER BY (MAX(yield) - MIN(yield)) DESC LIMIT 1;",
610 "sql_result": "[('Sweet potatoes', 953323.0)]",
611 "difficulty_level": "medium",
612 "table": "production"
613 },
614 {
615 "id": 69,
616 "question_en": "Which district produced the most pigeon peas in the 2023-2024 season?",
617 "question_ny": "Ndi boma liti lomwe linakolola nandolo wochuluka mu nyengo ya 2023-2024?",
618 "sql_statement": "SELECT district, MAX(yield) AS max_yield FROM production WHERE crop = 'Pigeon peas' AND season = '2023-2024';",
619 "sql_result": "[('Mulanje', 81569.0)]",
620 "difficulty_level": "easy",
621 "table": "production"
622 },
623 {
624 "id": 70,
625 "question_en": "How many crops had a total national yield above 1000 in the 2023-2024 season?",
626 "question_ny": "Kodi ndi mbewu zingati zomwe zinali ndi zokolola zochuluka zoposa 1000 mdziko muno mu nyengo ya 2023-2024?",
627 "sql_statement": "SELECT COUNT(*) FROM (SELECT crop FROM production WHERE season = '2023-2024' GROUP BY crop HAVING SUM(yield) > 1000);",
628 "sql_result": "[(43,)]",
629 "difficulty_level": "hard",
630 "table": "production"
631 },
632 {
633 "id": 71,
634 "question_en": "Which districts produced groundnuts in every recorded season?",
635 "question_ny": "Ndi maboma ati omwe analima mtedza m'nyengo zonse zolembedwa?",
636 "sql_statement": "SELECT district FROM production WHERE crop = 'Groundnuts' GROUP BY district HAVING COUNT(DISTINCT season) = (SELECT COUNT(DISTINCT season) FROM production WHERE crop = 'Groundnuts');",
637 "sql_result": "[('Balaka',), ('Blantyre',), ('Chikwawa',), ('Chiradzulu',), ('Chitipa',), ('Dedza',), ('Dowa',), ('Karonga',), ('Kasungu',), ('Likoma',), ('Lilongwe',), ('Machinga',), ('Mangochi',), ('Mchinji',), ('Mulanje',), ('Mwanza',), ('Mzimba',), ('Neno',), ('Nkhata Bay',), ('Nkhotakota',), ('Nsanje',), ('Ntcheu',), ('Ntchisi',), ('Phalombe',), ('Rumphi',), ('Salima',), ('Thyolo',), ('Zomba',)]",
638 "difficulty_level": "hard",
639 "table": "production"
640 },
641 {
642 "id": 72,
643 "question_en": "What is the difference between the highest and lowest rice yields in the 2023-2024 season?",
644 "question_ny": "Kodi zokolola za mpunga zochulukitsitsa ndi zochepetsetsa zasiyana mochuluka bwanji mu nyengo ya 2023-2024?",
645 "sql_statement": "SELECT MAX(yield) - MIN(yield) FROM production WHERE crop = 'Rice' AND season = '2023-2024';",
646 "sql_result": "[(46385.0,)]",
647 "difficulty_level": "medium",
648 "table": "production"
649 },
650 {
651 "id": 73,
652 "question_en": "Which crop was produced in the greatest number of districts during the 2023-2024 season?",
653 "question_ny": "Ndi mbewu iti yomwe idalimidwa m'maboma ambiri mu nyengo ya 2023-2024?",
654 "sql_statement": "SELECT crop, COUNT(DISTINCT district) FROM production WHERE season = '2023-2024' GROUP BY crop ORDER BY COUNT(DISTINCT district) DESC LIMIT 1;",
655 "sql_result": "[('Wheat', 28)]",
656 "difficulty_level": "medium",
657 "table": "production"
658 },
659 {
660 "id": 74,
661 "question_en": "How many districts recorded zero production for sesame in the 2023-2024 season?",
662 "question_ny": "Kodi ndi maboma angati omwe sadakolole konse chitowe mu nyengo ya 2023-2024?",
663 "sql_statement": "SELECT COUNT(*) FROM production WHERE crop = 'Sesame' AND season = '2023-2024' AND yield = 3;",
664 "sql_result": "[(1,)]",
665 "difficulty_level": "easy",
666 "table": "production"
667 },
668 {
669 "id": 75,
670 "question_en": "Which district had the most balanced crop yields in the 2023-2024 season?",
671 "question_ny": "Ndi boma liti lomwe linali ndi zokolola zochukula mofanana mu nyengo ya 2023-2024?",
672 "sql_statement": "SELECT district, (MAX(yield) - MIN(yield)) FROM production WHERE season = '2023-2024' GROUP BY district ORDER BY (MAX(yield) - MIN(yield)) ASC LIMIT 1;",
673 "sql_result": "[('Likoma', 2242.0)]",
674 "difficulty_level": "medium",
675 "table": "production"
676 },
677 {
678 "id": 76,
679 "question_en": "What was the average yield of all crops combined in the 2023-2024 season?",
680 "question_ny": "Kodi ndi mlingo wapakatikati wotani wa zokolola za mbewu zonse pamodzi mu nyengo ya 2023-2024?",
681 "sql_statement": "SELECT AVG(yield) FROM production WHERE season = '2023-2024';",
682 "sql_result": "[(17686.38802950311,)]",
683 "difficulty_level": "easy",
684 "table": "production"
685 },
686 {
687 "id": 77,
688 "question_en": "Which district produced the most sunflower in the 2023-2024 season?",
689 "question_ny": "Ndi boma liti lomwe linakolola mpendadzuwa wochuluka kwambiri mu nyengo ya 2023-2024?",
690 "sql_statement": "SELECT district, MAX(yield) AS max_yield FROM production WHERE crop = 'Sunflower' AND season = '2023-2024';",
691 "sql_result": "[('Phalombe', 4944.0)]",
692 "difficulty_level": "easy",
693 "table": "production"
694 },
695 {
696 "id": 78,
697 "question_en": "What are the top 3 crops by yield in Zomba during the 2023-2024 season?",
698 "question_ny": "Ndi mbewu ziti zitatu zomwe zinakololedwa mochuluka m'boma la Zomba mu nyengo ya 2023-2024?",
699 "sql_statement": "SELECT crop FROM production WHERE district = 'Zomba' AND season = '2023-2024' ORDER BY yield DESC LIMIT 3;",
700 "sql_result": "[('Maize',), ('Mangoes',), ('Pigeon peas',)]",
701 "difficulty_level": "medium",
702 "table": "production"
703 },
704 {
705 "id": 79,
706 "question_en": "What was the total Grape fruits yield in 2023-2024?",
707 "question_ny": "Kodi ndi zipatso za mpesa zochuluka bwanji zonse pamodzi zinakololedwa mu nyengo ya 2023-2024?",
708 "sql_statement": "SELECT SUM(yield) FROM production WHERE crop = 'Grape fruits' AND season = '2023-2024';",
709 "sql_result": "[(239.0,)]",
710 "difficulty_level": "easy",
711 "table": "production"
712 },
713 {
714 "id": 80,
715 "question_en": "What is the average Chick peas yield?",
716 "question_ny": "Ndi mlingo wakatikati womwe anakolola tchana?",
717 "sql_statement": "SELECT AVG(yield) FROM production WHERE crop = 'Chick peas';",
718 "sql_result": "[(55.357142857142854,)]",
719 "difficulty_level": "easy",
720 "table": "production"
721 },
722 {
723 "id": 81,
724 "question_en": "How many districts are in the Central region?",
725 "question_ny": "Kodi chigawo chapakati chili ndi maboma angati?",
726 "sql_statement": "SELECT COUNT(DISTINCT district_name) FROM population WHERE region_name = 'Central';",
727 "sql_result": "[(9,)]",
728 "difficulty_level": "medium",
729 "table": "population"
730 },
731 {
732 "id": 82,
733 "question_en": "How many males are in Machinga?",
734 "question_ny": "Amuna ndi angati mu boma la Machinga?",
735 "sql_statement": "SELECT SUM(population_male) FROM population WHERE district_name = 'Machinga';",
736 "sql_result": "[(350742.0,)]",
737 "difficulty_level": "easy",
738 "table": "population"
739 },
740 {
741 "id": 83,
742 "question_en": "How many districts are in the Southern region?",
743 "question_ny": "Chigawo chakumwera chili ndi maboma angati?",
744 "sql_statement": "SELECT COUNT(DISTINCT district_name) FROM population WHERE region_name = 'Southern';",
745 "sql_result": "[(13,)]",
746 "difficulty_level": "medium",
747 "table": "population"
748 },
749 {
750 "id": 84,
751 "question_en": "List all the distinct Traditional Authorities (TAs) in Phalombe",
752 "question_ny": "Lembani m'ndandanda wa mafumu akuluakulu osiyanasiyana omwe ali ku Phalombe",
753 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Phalombe';",
754 "sql_result": "[('TA Mkhumba',), ('TA Jenala',), ('TA Chiwalo',), ('TA Nazombe',), ('TA Nkhulambe',), ('Phalombe Boma',), ('TA Kaduya',), ('Lake Chilwa',)]",
755 "difficulty_level": "easy",
756 "table": "population"
757 },
758 {
759 "id": 85,
760 "question_en": "How many females in Chikwawa?",
761 "question_ny": "Kodi boma la Chikwawa liri ndi akazi angati?",
762 "sql_statement": "SELECT SUM(population_female) FROM population WHERE district_name = 'Chikwawa';",
763 "sql_result": "[(287794.0,)]",
764 "difficulty_level": "easy",
765 "table": "population"
766 },
767 {
768 "id": 86,
769 "question_en": "Which districts are in Central region?",
770 "question_ny": "Ndi maboma ati omwe ali m'chigawo chapakati?",
771 "sql_statement": "SELECT DISTINCT district_name FROM population WHERE region_name = 'Central';",
772 "sql_result": "[('Ntchisi',), ('Lilongwe',), ('Salima',), ('Dedza',), ('Kasungu',), ('Mchinji',), ('Nkhotakota',), ('Dowa',), ('Ntcheu',)]",
773 "difficulty_level": "easy",
774 "table": "population"
775 },
776 {
777 "id": 87,
778 "question_en": "What is the total population in Central region",
779 "question_ny": "Kodi chiwerengero cha anthu m'chigawo cha pakati ndichochuluka bwanji?",
780 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE region_name = 'Central';",
781 "sql_result": "[(21215760,)]",
782 "difficulty_level": "easy",
783 "table": "population"
784 },
785 {
786 "id": 88,
787 "question_en": "How many males are in Nkhotakota?",
788 "question_ny": "Ku Nkhotakota kuli amuna angati?",
789 "sql_statement": "SELECT SUM(population_male) FROM population WHERE district_name = 'Nkhotakota';",
790 "sql_result": "[(192615.0,)]",
791 "difficulty_level": "easy",
792 "table": "population"
793 },
794 {
795 "id": 89,
796 "question_en": "Which districts are in Southern region?",
797 "question_ny": "Ndi maboma ati amene ali ku chigawo chakumwela?",
798 "sql_statement": "SELECT DISTINCT district_name FROM population WHERE region_name = 'Southern';",
799 "sql_result": "[('Blantyre',), ('Mangochi',), ('Zomba',), ('Thyolo',), ('Machinga',), ('Mulanje',), ('Chikwawa',), ('Mwanza',), ('Neno',), ('Nsanje',), ('Balaka',), ('Chiradzulu',), ('Phalombe',)]",
800 "difficulty_level": "easy",
801 "table": "population"
802 },
803 {
804 "id": 90,
805 "question_en": "List all the distinct Traditional Authorities (TAs) in Dowa",
806 "question_ny": "Lembani m'ndandanda wa mafumu akuluakulu osiyanasiyana omwe ali ku Dowa",
807 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Dowa';",
808 "sql_result": "[('Dowa Boma',), ('TA Msakambewa',), ('TA Mponela',), ('Mponela Urban',), ('TA Mkukula',), ('TA Dzoole',), ('TA Chiwere',), ('TA Chakhaza',), ('TA Kayembe',)]",
809 "difficulty_level": "easy",
810 "table": "population"
811 },
812 {
813 "id": 91,
814 "question_en": "List all the distinct Traditional Authorities (TAs) in Mzimba",
815 "question_ny": "Lembani m'ndandanda wa mafumu akuluakulu osiyanasiyana omwe ali ku Mzimba",
816 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Mzimba';",
817 "sql_result": "[('TA Mabulabo',), ('STA Levi Jere',), ('TA Mzukuzuku',), ('TA Mzikubola',), ('TA Mtwalo',), ('TA Mpherembe',), (\"TA M'Mbelwa\",), ('TA Khosolo Gwaza Jere',), ('TA Kampingo Sibande',), ('TA Jaravikuba Munthali',), ('TA Chindi',), ('Mzimba Boma',), ('Vwaza Marsh Reserve',)]",
818 "difficulty_level": "easy",
819 "table": "population"
820 },
821 {
822 "id": 92,
823 "question_en": "How many males are in Blantyre City?",
824 "question_ny": "Mu mzinda wa Blantyre muli amuna ochuluka bwanji?",
825 "sql_statement": "SELECT SUM(population_male) FROM population WHERE district_name = 'Blantyre';",
826 "sql_result": "[(619636.0,)]",
827 "difficulty_level": "easy",
828 "table": "population"
829 },
830 {
831 "id": 93,
832 "question_en": "How many males are in Ntcheu?",
833 "question_ny": "Amuna ndi ochuluka bwanji ku Ntcheu?",
834 "sql_statement": "SELECT SUM(population_male) FROM population WHERE district_name = 'Ntcheu';",
835 "sql_result": "[(319415.0,)]",
836 "difficulty_level": "easy",
837 "table": "population"
838 },
839 {
840 "id": 94,
841 "question_en": "Give the total population in Northern region.",
842 "question_ny": "Ntchulani kuchuluka kwa anthu okhala m'chigawo chaku mpoto",
843 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE region_name = 'Northern';",
844 "sql_result": "[(6695406,)]",
845 "difficulty_level": "easy",
846 "table": "population"
847 },
848 {
849 "id": 95,
850 "question_en": "How many households are in Chiradzulu?",
851 "question_ny": "Ndi mabanja angati omwe ali boma la Chiradzulu?",
852 "sql_statement": "SELECT SUM(number_households) FROM population WHERE district_name = 'Chiradzulu';",
853 "sql_result": "[(90548.0,)]",
854 "difficulty_level": "easy",
855 "table": "population"
856 },
857 {
858 "id": 96,
859 "question_en": "What is the total number of households in Blantyre?",
860 "question_ny": "Ndi mabanja ochuluka bwanji omwe ali mu Blantyre?",
861 "sql_statement": "SELECT SUM(number_households) FROM population WHERE district_name = 'Blantyre';",
862 "sql_result": "[(301630.0,)]",
863 "difficulty_level": "easy",
864 "table": "population"
865 },
866 {
867 "id": 97,
868 "question_en": "List all the distinct Traditional Authorities (TAs) in Chiradzulu",
869 "question_ny": "Lembani m'ndandanda wa mafumu akuluakulu osiyanasiyana omwe ali ku Chiradzulu",
870 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Chiradzulu';",
871 "sql_result": "[('TA Chitera',), ('TA Kadewere',), ('TA Mpama',), ('TA Nchema',), ('STA Sandareki',), ('Chiradzulu Boma',), ('STA Mpunga',), ('STA Onga',), ('TA Likoswe',), ('TA Nkalo',)]",
872 "difficulty_level": "easy",
873 "table": "population"
874 },
875 {
876 "id": 98,
877 "question_en": "Find the population of Traditional Authority (TA) Area 36.",
878 "question_ny": "Pezani chiwerengero cha anthu mudela la mfumu yaikulu 36",
879 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE ta_name = 'Area 36';",
880 "sql_result": "[(289005,)]",
881 "difficulty_level": "easy",
882 "table": "population"
883 },
884 {
885 "id": 99,
886 "question_en": "List all the distinct Traditional Authorities (TAs) in Mangochi",
887 "question_ny": "Lembani m'ndandanda wa mafumu akuluakulu osiyanasiyana omwe ali boma la Mangochi",
888 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Mangochi';",
889 "sql_result": "[('STA Ntonda',), ('TA Chimwala',), ('TA Mponda',), ('Lake Malombe',), ('TA Katuli',), ('TA Makanjila',), ('TA Mbwana Nyambi',), ('TA Namabvi',), ('Mangochi Town',), ('Monkey Bay Urban',), ('STA Chiunda',), ('STA Lulanga',), ('TA Chilipa',), ('TA Chowe',), ('TA Jalasi',), ('TA Nankumba',), ('Lake Malawi National Park',)]",
890 "difficulty_level": "easy",
891 "table": "population"
892 },
893 {
894 "id": 100,
895 "question_en": "What is the total population in Mangochi?",
896 "question_ny": "Chiwerengero cha anthu ku Mangochi ndi chochuluka bwanji?",
897 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE district_name = 'Mangochi';",
898 "sql_result": "[(3348328,)]",
899 "difficulty_level": "easy",
900 "table": "population"
901 },
902 {
903 "id": 101,
904 "question_en": "How many households in Balaka District?",
905 "question_ny": "Ndi mabanja angati omwe ali boma la Balaka?",
906 "sql_statement": "SELECT SUM(number_households) FROM population WHERE district_name = 'Balaka';",
907 "sql_result": "[(101574.0,)]",
908 "difficulty_level": "easy",
909 "table": "population"
910 },
911 {
912 "id": 102,
913 "question_en": "How many households in Chikwawa?",
914 "question_ny": "Ndi mabanja angati omwe ali ku Chikwawa?",
915 "sql_statement": "SELECT SUM(number_households) FROM population WHERE district_name = 'Chikwawa';",
916 "sql_result": "[(127196.0,)]",
917 "difficulty_level": "easy",
918 "table": "population"
919 },
920 {
921 "id": 103,
922 "question_en": "Find the population of Traditional Authority (TA) Area 13?",
923 "question_ny": "Pezani chiwerengero cha anthu mudela la mfumu yaikulu 13",
924 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE ta_name = 'Area 13';",
925 "sql_result": "[(3,)]",
926 "difficulty_level": "easy",
927 "table": "population"
928 },
929 {
930 "id": 104,
931 "question_en": "Which Traditional Authority (TA) in Chiradzulu has the largest total population?",
932 "question_ny": "Kodi ndi mfumu yaikulu iti yomwe ili ndi chiwerengero cha anthu chokwera boma la Chiradzulu?",
933 "sql_statement": "SELECT ta_name, SUM(CAST(total_population AS INTEGER)) as total_pop FROM population WHERE district_name = 'Chiradzulu' GROUP BY ta_name ORDER BY total_pop DESC LIMIT 1;",
934 "sql_result": "[('TA Likoswe', 199343)]",
935 "difficulty_level": "medium",
936 "table": "population"
937 },
938 {
939 "id": 105,
940 "question_en": "Find the total count of districts in Northern region",
941 "question_ny": "Welengani ma boma onse omwe ali chigawo chaku mpoto",
942 "sql_statement": "SELECT COUNT(DISTINCT district_name) FROM population WHERE region_name = 'Northern';",
943 "sql_result": "[(7,)]",
944 "difficulty_level": "medium",
945 "table": "population"
946 },
947 {
948 "id": 106,
949 "question_en": "How many females are in Balaka?",
950 "question_ny": "Ndi akazi angati ali ku Balaka?",
951 "sql_statement": "SELECT SUM(population_female) FROM population WHERE district_name = 'Balaka';",
952 "sql_result": "[(229105.0,)]",
953 "difficulty_level": "easy",
954 "table": "population"
955 },
956 {
957 "id": 107,
958 "question_en": "What is the total population in Dowa?",
959 "question_ny": "Chiwerengero cha anthu m'boma la Dowa ndo chochuluka bwanji?",
960 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE district_name = 'Dowa';",
961 "sql_result": "[(2189187,)]",
962 "difficulty_level": "easy",
963 "table": "population"
964 },
965 {
966 "id": 108,
967 "question_en": "How many females are in Chitipa?",
968 "question_ny": "Ndi akazi angati ali ku Chitipa?",
969 "sql_statement": "SELECT SUM(population_female) FROM population WHERE district_name = 'Chitipa';",
970 "sql_result": "[(120535.0,)]",
971 "difficulty_level": "easy",
972 "table": "population"
973 },
974 {
975 "id": 109,
976 "question_en": "Find the population of Traditional Authority (TA) Area 25.",
977 "question_ny": "Pezani chiwerengero cha anthu okhala m'dela la mfumu yaikulu 25",
978 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE ta_name = 'Area 25';",
979 "sql_result": "[(289170,)]",
980 "difficulty_level": "easy",
981 "table": "population"
982 },
983 {
984 "id": 110,
985 "question_en": "What is the total population in Chitipa?",
986 "question_ny": "Chiwerengero cha anthu ku Chitipa ndi chochuluka bwanji?",
987 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE district_name = 'Chitipa';",
988 "sql_result": "[(663660,)]",
989 "difficulty_level": "easy",
990 "table": "population"
991 },
992 {
993 "id": 111,
994 "question_en": "List all the distinct Traditional Authorities (TAs) in Chitipa",
995 "question_ny": "Lembani m'ndandanda wa mafumu akuluakulu osiyanasiyana omwe ali ku Chitipa",
996 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Chitipa';",
997 "sql_result": "[('TA Mwenemisuku',), ('TA Nthalire',), ('STA Nthengatenga',), ('TA Mwenewenya',), ('STA Lwangwa',), ('STA Wavikaza',), ('Chitipa Boma',), ('TA Kameme',), ('Nyika Ntational Park-Chitipa',), ('STA Bulambya Songwe',), ('TA Mwabulambya',)]",
998 "difficulty_level": "easy",
999 "table": "population"
1000 },
1001 {
1002 "id": 112,
1003 "question_en": "How many females are in Thyolo?",
1004 "question_ny": "Ndi akazi angati ali ku Thyolo?",
1005 "sql_statement": "SELECT SUM(population_female) FROM population WHERE district_name = 'Thyolo';",
1006 "sql_result": "[(380697.0,)]",
1007 "difficulty_level": "easy",
1008 "table": "population"
1009 },
1010 {
1011 "id": 113,
1012 "question_en": "Which Traditional Authority (TA) in Blantyre has the largest total population?",
1013 "question_ny": "Kodi ndi mfumu yaikulu iti yomwe ili ndi chiwerengero cha anthu chochuluka kwambli ku Blantyre?",
1014 "sql_statement": "SELECT ta_name, SUM(CAST(total_population AS INTEGER)) as total_pop FROM population WHERE district_name = 'Blantyre' GROUP BY ta_name ORDER BY total_pop DESC LIMIT 1;",
1015 "sql_result": "[('TA Kapeni', 270899)]",
1016 "difficulty_level": "medium",
1017 "table": "population"
1018 },
1019 {
1020 "id": 114,
1021 "question_en": "List all the distinct Traditional Authorities (TAs) in Blantyre city",
1022 "question_ny": "Lembani m'ndandanda wamafumu akuluakulu osiyanasiyana mu mzinda wa Blantyre",
1023 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Blantyre';",
1024 "sql_result": "[('TA Kapeni',), ('TA Lundu',), ('TA Chigaru',), ('TA Makata',), ('TA Machinjiri',), ('Chilomoni Ward',), ('Michiru Ward',), ('Nyambadwe Ward',), ('Mbayani Ward',), ('South Lunzu Ward',), ('Mapanga Ward',), ('Green Corner Ward',), ('Misesa Ward',), ('Ndirande Gamulani Ward',), ('Ndirande Makata Ward',), ('Soche West Ward',), ('Limbe Central Ward',), ('Nkolokoti Ward',), ('Mzedi Ward',), ('Namiyango Ward',), ('Ndirande Matope Ward',), ('Soche East Ward',), ('Bangwe Ward',), ('Bangwe Mthandizi Ward',), ('Blantyre City Centre Ward',), ('Blantyre South Ward',), ('Chigumula Ward',), ('Namalimwe Ward',), ('TA Kunthembwe',), ('TA Kuntaja',), ('TA Somba',)]",
1025 "difficulty_level": "easy",
1026 "table": "population"
1027 },
1028 {
1029 "id": 115,
1030 "question_en": "List all the distinct Traditional Authorities (TAs) in Balaka",
1031 "question_ny": "Lembani m'ndandanda wamafumu akuluakulu osiyanasiyana ku Balaka",
1032 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Balaka';",
1033 "sql_result": "[('TA Nkaya',), ('STA Phalula',), ('STA Toleza',), ('TA Amidu',), ('TA Chanthunya',), ('TA Kalembo',), ('Balaka Town',), ('TA Msamala',), ('TA Sawali',), ('STA Kachenga',), ('STA Matola',), ('Liwonde Town',)]",
1034 "difficulty_level": "easy",
1035 "table": "population"
1036 },
1037 {
1038 "id": 116,
1039 "question_en": "What is the population of Traditional Authority (TA) Area 31?",
1040 "question_ny": "Kodi chiwerengero cha anthu m'dera la mfumu yayikulu 36 ndi chochuluka bwanji?",
1041 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE ta_name = 'Area 31';",
1042 "sql_result": "[(0,)]",
1043 "difficulty_level": "easy",
1044 "table": "population"
1045 },
1046 {
1047 "id": 117,
1048 "question_en": "How many females are in Karonga?",
1049 "question_ny": "Ndi akazi angati ali ku Karonga?",
1050 "sql_statement": "SELECT SUM(population_female) FROM population WHERE district_name = 'Karonga';",
1051 "sql_result": "[(188831.0,)]",
1052 "difficulty_level": "easy",
1053 "table": "population"
1054 },
1055 {
1056 "id": 118,
1057 "question_en": "List all the distinct Traditional Authorities (TAs) in Likoma",
1058 "question_ny": "Lembani m'ndandanda wamafumu akuluakulu osiyanasiyana ku Likoma",
1059 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Likoma';",
1060 "sql_result": "[('TA Mkumpha',), ('Likoma Boma',)]",
1061 "difficulty_level": "easy",
1062 "table": "population"
1063 },
1064 {
1065 "id": 119,
1066 "question_en": "Which Traditional Authority (TA) in Chikwawa has the largest number of households?",
1067 "question_ny": "Ndi mfumu yaikulu iti ku Chikwawa yomwe ili ndi mabanja ochuluka kwambiri?",
1068 "sql_statement": "SELECT ta_name, SUM(number_households) as total_hh FROM population WHERE district_name = 'Chikwawa' GROUP BY ta_name ORDER BY total_hh DESC LIMIT 1;",
1069 "sql_result": "[('TA Ngabu', 33888.0)]",
1070 "difficulty_level": "medium",
1071 "table": "population"
1072 },
1073 {
1074 "id": 120,
1075 "question_en": "Find the total population in Southern region",
1076 "question_ny": "Pezani kuchuluka kwa anthu onse okhala m'chigawo chakumwela",
1077 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE region_name = 'Southern';",
1078 "sql_result": "[(21757131,)]",
1079 "difficulty_level": "easy",
1080 "table": "population"
1081 },
1082 {
1083 "id": 121,
1084 "question_en": "How many males are in Mchinji?",
1085 "question_ny": "Ku Mchinji kuli amuna angati?",
1086 "sql_statement": "SELECT SUM(population_male) FROM population WHERE district_name = 'Mchinji';",
1087 "sql_result": "[(296786.0,)]",
1088 "difficulty_level": "easy",
1089 "table": "population"
1090 },
1091 {
1092 "id": 122,
1093 "question_en": "Which Traditional Authority (TA) in Blantyre has the largest number of households?",
1094 "question_ny": "Ndi mfumu yayikulu iti yomwe ili ndi mabanja ambiri ku Blantyre?",
1095 "sql_statement": "SELECT ta_name, SUM(CAST(number_households AS INTEGER)) as total_hh FROM population WHERE district_name = 'Blantyre' GROUP BY ta_name ORDER BY total_hh DESC LIMIT 1;",
1096 "sql_result": "[('TA Kapeni', 25440)]",
1097 "difficulty_level": "medium",
1098 "table": "population"
1099 },
1100 {
1101 "id": 123,
1102 "question_en": "How many males in Chikwawa district?",
1103 "question_ny": "Ndi amuna angati omwe ali ku Chikwawa?",
1104 "sql_statement": "SELECT SUM(population_male) FROM population WHERE district_name = 'Chikwawa';",
1105 "sql_result": "[(276890.0,)]",
1106 "difficulty_level": "easy",
1107 "table": "population"
1108 },
1109 {
1110 "id": 124,
1111 "question_en": "Which Traditional Authority (TA) in Chiradzulu has the largest number of households?",
1112 "question_ny": "Ndi mfumu yayikulu iti ku Chiradzulu yomwe ili ndi mabanja ambiri?",
1113 "sql_statement": "SELECT ta_name, SUM(CAST(number_households AS INTEGER)) as total_hh FROM population WHERE district_name = 'Chiradzulu' GROUP BY ta_name ORDER BY total_hh DESC LIMIT 1;",
1114 "sql_result": "[('TA Likoswe', 17392)]",
1115 "difficulty_level": "medium",
1116 "table": "population"
1117 },
1118 {
1119 "id": 125,
1120 "question_en": "Which districts are in Northern region?",
1121 "question_ny": "Ndi maboma ati omwe ali mchigawo chakumpoto?",
1122 "sql_statement": "SELECT DISTINCT district_name FROM population WHERE region_name = 'Northern';",
1123 "sql_result": "[('Mzimba',), ('Likoma',), ('Chitipa',), ('Karonga',), ('Nkhata Bay',), ('Rumphi',), ('Mzuzu',)]",
1124 "difficulty_level": "easy",
1125 "table": "population"
1126 },
1127 {
1128 "id": 126,
1129 "question_en": "List all the distinct Traditional Authorities (TAs) in Karonga",
1130 "question_ny": "Pelekani ndandanda wa mafumu akuluakulu osiyanasiyana ku Karonga",
1131 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Karonga';",
1132 "sql_result": "[('TA Wasambo',), (\"TA Mwirang'ombe\",), ('TA Mwakaboko',), ('TA Kyungu',), ('TA Kilupula',), ('Karonga Town',), ('Nyika National Park-Karonga',)]",
1133 "difficulty_level": "easy",
1134 "table": "population"
1135 },
1136 {
1137 "id": 127,
1138 "question_en": "Find the population of Traditional Authority (TA) Area 12?",
1139 "question_ny": "Pezani chiwerengero cha anthu mdera la mfumu yayikulu 12?",
1140 "sql_statement": "SELECT SUM(CAST(total_population AS INTEGER)) FROM population WHERE ta_name = 'Area 12';",
1141 "sql_result": "[(2540,)]",
1142 "difficulty_level": "easy",
1143 "table": "population"
1144 },
1145 {
1146 "id": 128,
1147 "question_en": "How many males in Chiradzulu?",
1148 "question_ny": "Ku Chiradzulu kuli amuna angati ?",
1149 "sql_statement": "SELECT SUM(population_male) FROM population WHERE district_name = 'Chiradzulu';",
1150 "sql_result": "[(169679.0,)]",
1151 "difficulty_level": "easy",
1152 "table": "population"
1153 },
1154 {
1155 "id": 129,
1156 "question_en": "How many distinct Traditional Authorities (TAs) are there in Phalombe?",
1157 "question_ny": "Ku Phalombe kuli mafumu akuluakulu osiyanasiyana angati?",
1158 "sql_statement": "SELECT COUNT(DISTINCT ta_name) FROM population WHERE district_name = 'Phalombe';",
1159 "sql_result": "[(8,)]",
1160 "difficulty_level": "medium",
1161 "table": "population"
1162 },
1163 {
1164 "id": 130,
1165 "question_en": "Which Traditional Authority (TA) in Chikwawa has the largest male population?",
1166 "question_ny": "Ndi mfumu yayikulu iti ku Chikwawa yomwe ili ndi chiwerengero cha anthu chochuluka?",
1167 "sql_statement": "SELECT ta_name, SUM(CAST(population_male AS INTEGER)) as total_male FROM population WHERE district_name = 'Chikwawa' GROUP BY ta_name ORDER BY total_male DESC LIMIT 1;",
1168 "sql_result": "[('TA Ngabu', 77120)]",
1169 "difficulty_level": "medium",
1170 "table": "population"
1171 },
1172 {
1173 "id": 131,
1174 "question_en": "How many households in Karonga?",
1175 "question_ny": "Ku Karonga kuli mabanja angati?",
1176 "sql_statement": "SELECT SUM(number_households) FROM population WHERE district_name = 'Karonga';",
1177 "sql_result": "[(74953.0,)]",
1178 "difficulty_level": "easy",
1179 "table": "population"
1180 },
1181 {
1182 "id": 132,
1183 "question_en": "How many distinct Traditional Authorities (TAs) are there in Lilongwe?",
1184 "question_ny": "Ku Lilongwe kuli mafumu akuluakulu osiyanasiyana angati?",
1185 "sql_statement": "SELECT COUNT(DISTINCT ta_name) FROM population WHERE district_name = 'Lilongwe';",
1186 "sql_result": "[(76,)]",
1187 "difficulty_level": "medium",
1188 "table": "population"
1189 },
1190 {
1191 "id": 133,
1192 "question_en": "List all the distinct Traditional Authorities (TAs) in Dedza",
1193 "question_ny": "Ku Dedza kuli mafumu akuluakulu osiyanasiyana angati?",
1194 "sql_statement": "SELECT DISTINCT ta_name FROM population WHERE district_name = 'Dedza';",
1195 "sql_result": "[('TA Tambala',), ('TA Kasumbu',), ('TA Kaphuka',), ('TA Kachere',), ('TA Chilikumwendo',), ('TA Chauma',), ('TA Kamenya Gwaza',), ('TA Kachindamoto',), ('Dedza Boma',)]",
1196 "difficulty_level": "easy",
1197 "table": "population"
1198 },
1199 {
1200 "id": 134,