WITH Pre AS(
SELECT
    PF_CODE,
    SUM(CASE WHEN CATEGORY_CODE = '110' THEN AMT END) AS SOGO_AMT,
    SUM(CASE WHEN CATEGORY_CODE = '120' THEN AMT END) AS EVERYDAY_AMT
FROM
    DRINK_HABITS
WHERE
    GENDER_CODE IN ('2','3')
GROUP BY 
    PF_CODE
    )
SELECT
    D.PF_CODE,
    P.PF_NAME,
    round(cast(D.EVERYDAY_AMT AS real) / cast(D.SOGO_AMT AS real),3) * 100 AS PERCENTAGE
FROM
    Pre AS D
LEFT JOIN
    PREFECTURE AS P
ON
    D.PF_CODE = P.PF_CODE
ORDER BY
    PERCENTAGE DESC,
    D.PF_CODE DESC