SELECT
    s.CODE AS CODE
    ,s.NAME AS NAME
    ,round(cast (s.everyday as real) / cast(s.total as real) * 100, 1) AS PERCENTAGE
FROM
    (
        SELECT
            p.pf_code AS CODE
            ,p.pf_name AS NAME
            ,(
                SELECT
                    SUM(dh.amt)
                FROM
                    drink_habits dh
                WHERE
                    dh.gender_code IN('2', '3')
                AND dh.pf_code = p.pf_code
                AND dh.category_code = '110'
            ) AS total
            ,(
                SELECT
                    SUM(dh.amt)
                FROM
                    drink_habits dh
                WHERE
                    dh.gender_code IN('2', '3')
                AND dh.pf_code = p.pf_code
                AND dh.category_code = '120'
            ) AS everyday
        FROM
            prefecture p
    ) AS s
WHERE
    s.total IS NOT NULL and s.total > 0
ORDER BY
    round(cast (s.everyday as real) / cast(s.total as real) * 100, 1) DESC
    ,s.code desc