SELECT 
    DISTRICT_CODE,
    DISTRICT_NAME,
    CASE 
        WHEN ROUND(MALE_AMT * 1.0 / TOTAL_AMT, 2) = ROUND(MALE_AMT * 1.0 / TOTAL_AMT, 1) 
        THEN ROUND(MALE_AMT * 1.0 / TOTAL_AMT, 1) 
        ELSE ROUND(MALE_AMT * 1.0 / TOTAL_AMT, 2) 
    END AS PERCENTAGE
FROM 
    TBL_POPULATION
WHERE 
    TOTAL_AMT > 0
ORDER BY 
    DISTRICT_CODE DESC;