Select DISTRICT_NAME, sum(TOTAL_AMT) as TOTAL_AMT from POPULATION where LVL=2 GROUP BY DISTRICT_CODE order by TOTAL_AMT desc;