SELECT
    T01.PF_CODE AS CODE
  , T00.PF_NAME AS NAME
  , ROUND(cast((T02.SUM_飲酒*100)as real)/cast(T01.SUM_総数 as real), 1) AS PERCENTAGE
FROM
    PREFECTURE T00
, 
(
SELECT
    PF_CODE
  , CATEGORY_CODE
  , SUM(AMT) AS SUM_総数
FROM
    DRINK_HABITS
WHERE
    GENDER_CODE IN ("2","3")
AND CATEGORY_CODE = "110"
GROUP BY
    PF_CODE
  , CATEGORY_CODE
) T01
, (
SELECT
    PF_CODE
  , CATEGORY_CODE
  , SUM(AMT) AS SUM_飲酒
FROM
    DRINK_HABITS
WHERE
    GENDER_CODE IN ("2","3")
AND CATEGORY_CODE = "120"
GROUP BY
    PF_CODE
  , CATEGORY_CODE
) T02
WHERE
    T01.PF_CODE = T02.PF_CODE
AND T01.PF_CODE = T00.PF_CODE
ORDER BY
    PERCENTAGE DESC
  , CODE DESC