select
    PREFECTURE.PF_CODE as CODE,
    PREFECTURE.PF_NAME as NAME,
    ROUND(CAST(DRINK_AMT as REAL)/CAST(AMT as REAL)*100,2) as PERCENTAGE
from
    PREFECTURE
inner join 
(
    select
        PF_CODE,
        SUM(AMT) AS AMT
    from DRINK_HABITS
    where CATEGORY_CODE='110' and
        (
        GENDER_CODE='2'
        or
        GENDER_CODE='3'
        )
    group by PF_CODE
) DH
on PREFECTURE.PF_CODE = DH.PF_CODE
inner join 
(
    select
        PF_CODE,
        SUM(AMT) AS DRINK_AMT
    from
        DRINK_HABITS
    where
        CATEGORY_CODE='120' and
        (
        GENDER_CODE='2'
        or
        GENDER_CODE='3'
        )
    group by
        PF_CODE
) DHE
on PREFECTURE.PF_CODE = DHE.PF_CODE
order by
    PERCENTAGE desc,
    CODE desc