'How can I get the value to each state 2 district?
I have this question:
For the state of Maharashtra, Gujarat and Goa List down top 2 districts with highest overall recovery rate (Normal + Delta) ?
Code:
Select distinct *
From (SELECT State, District,
MAX(Recovered) + MAX(DeltaRecovered) as Overall_Recovery_Rate
FROM dataquest.detailedn
where State in ('Maharashtra','Goa','Gujarat')
group by District
order by Overall_Recovery_Rate DESC
) as Stat
Order by State DESC;
Out i Am getting :
Maharashtra Gadchiroli 259
Maharashtra Gondia 255
Maharashtra Hingoli 455
Maharashtra Jalgaon 9320
Maharashtra Jalna 1573
Maharashtra Kolhapur 2916
Maharashtra Latur 1480
Maharashtra Mumbai 93436
Maharashtra Mumbai Suburban 0
Maharashtra Nagpur 2227
Maharashtra Nanded 970
Maharashtra Nandurbar 500
Maharashtra Nashik 12117
Maharashtra Osmanabad 721
Maharashtra Palghar 10869
Maharashtra Parbhani 443
Maharashtra Pune 62333
Maharashtra Raigad 14155
Maharashtra Ratnagiri 1355
Maharashtra Sangli 1562
Maharashtra Satara 3189
Maharashtra Sindhudurg 318
Maharashtra Solapur 6014
Maharashtra Thane 72801
Maharashtra Wardha 156
Maharashtra Washim 509
Maharashtra Yavatmal 790
Gujarat Ahmedabad 22274
Gujarat Amreli 337
Gujarat Anand 476
Gujarat Aravalli 313
Gujarat Banaskantha 752
Gujarat Bharuch 768
Gujarat Bhavnagar 1305
Gujarat Botad 222
Gujarat Chhota Udaipur 157
Gujarat Dahod 185
Gujarat Dang 12
Gujarat Devbhumi Dwarka 47
Gujarat Gandhinagar 1285
Gujarat Gir Somnath 412
Gujarat Jamnagar 607
Gujarat Junagadh 865
Gujarat Kheda 582
Gujarat Kutch 434
Gujarat Mahisagar 210
Gujarat Mehsana 562
Gujarat Morbi 246
Gujarat Narmada 316
Gujarat Navsari 462
Gujarat Panchmahal 393
Gujarat Patan 736
Gujarat Porbandar 45
Gujarat Rajkot 1290
Gujarat Sabarkantha 354
Gujarat Surat 10413
Gujarat Surendranagar 499
Gujarat Tapi 137
Gujarat Vadodara 4107
Gujarat Valsad 498
Goa North Goa 502
Goa South Goa 896
Expected ANS like :
Maharashtra Jalgaon 9320
Maharashtra Mumbai 93436
Gujarat Ahmedabad 22274
Gujarat Surat 10413
Goa North Goa 502
Goa South Goa 896
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
