with mainiti as (
select pf_code,
       sum(amt) suma
from DRINK_HABITS
where GENDER_CODE in (2, 3)
and CATEGORY_CODE = "120"
GROUP BY
    pf_code
),
totals as (
select pf_code,
       sum(amt) suma
from DRINK_HABITS
where GENDER_CODE in (2, 3)
and CATEGORY_CODE = "110"
GROUP BY
    pf_code
)
select t.pf_code as CODE,
	   p.PF_NAME as NAME,
       round(
        cast(m.suma * 100 as REAL) / cast(t.suma as REAL)
        , 1) as PERCENTAGE
       from totals t
       inner join mainiti m on t.pf_code = m.pf_code 
       INNER JOIN PREFECTURE p ON t.pf_code = p.pf_code
order by 
PERCENTAGE desc,
t.pf_code desc