select
    PREFECTURE.PF_CODE "CODE",
    PREFECTURE.PF_NAME "NAME",
    round(100. * everyday.AMT / total.AMT, 1) "PERCENTAGE"
from
    PREFECTURE
    join DRINK_HABITS as everyday on everyday.PF_CODE = PREFECTURE.PF_CODE
    and everyday.CATEGORY_CODE = '120'
    join DRINK_HABITS as total on total.PF_CODE = PREFECTURE.PF_CODE
    and total.CATEGORY_CODE = '110'
    and total.GENDER_CODE = everyday.GENDER_CODE
group by
    "CODE"
order by
    "PERCENTAGE" desc,
    "CODE" asc;