SELECT 
A.PF_CODE AS CODE
,B.PF_NAME NAME
,ROUND(cast(毎日 AS real)/cast(総数 AS real) * 100,1) AS PERCENTAGE
FROM (
    SELECT
     PF_CODE
    ,SUM(case WHEN CATEGORY_CODE ='110' THEN AMT ELSE 0 END) 総数
    ,SUM(case WHEN CATEGORY_CODE ='120' THEN AMT ELSE 0 END) 毎日
    FROM DRINK_HABITS
    WHERE GENDER_CODE IN('2','3')
    GROUP BY PF_CODE
) A
INNER JOIN PREFECTURE B ON A.PF_CODE =B.PF_CODE
order BY 3 DESC , 1 DESC