SELECT
    DH.PF_CODE AS CODE
    ,P.PF_NAME AS NAME
    --飲酒率の計算
           --毎日飲酒の人数
    ,ROUND(SUM(CASE WHEN DH.CATEGORY_CODE = 120
              THEN CAST(DH.AMT AS float)
              ELSE 0
              END --総数
              ) / SUM(CASE WHEN DH.CATEGORY_CODE = 110
                           THEN CAST(DH.AMT AS float)
                           ELSE 0
                           END
                           ) * 100, 1) AS PERCENTAGE
FROM
    DRINK_HABITS AS DH
LEFT OUTER JOIN
    PREFECTURE AS P
  ON
    DH.PF_CODE = P.PF_CODE
WHERE
    GENDER_CODE IN (2, 3)
GROUP BY
    DH.PF_CODE
ORDER BY
    PERCENTAGE DESC
    ,DH.PF_CODE ASC;