SELECT
DH1.PF_CODE AS "CODE",
PREFECTURE.PF_NAME AS "NAME",
     ROUND( 
        -- 計算項目がINTEGER型なのでCAST関数でREAL型に変換して計算しています
        CAST(SUM(DH2.AMT) AS REAL) /
        CAST(SUM(DH1.AMT)  AS REAL )
        * 100
        , 1
    ) AS "PERCENTAGE"
FROM
-- 総数
DRINK_HABITS DH1
-- 毎日飲酒
JOIN
 (
  SELECT
   GENDER_CODE,
   PF_CODE,
   AMT
  FROM 
   DRINK_HABITS
  WHERE
   CATEGORY_CODE = '120'
) AS DH2
ON DH1.GENDER_CODE = DH2.GENDER_CODE
   AND 
   DH1.PF_CODE = DH2.PF_CODE
JOIN
 PREFECTURE
ON 
 DH1.PF_CODE  = PREFECTURE.PF_CODE
WHERE
 DH1.GENDER_CODE IN ('2' , '3')
GROUP BY
 DH1.PF_CODE
ORDER BY
PERCENTAGE DESC,
CODE DESC