select
  D.PF_CODE as CODE,
  P.PF_NAME as NAME,
  round((D.M_AMT+D.F_AMT)*1.0*100/(D.M_TAMT+D.F_TAMT),1) as PERCENTAGE
from
(select
  PF_CODE,
  SUM(CASE WHEN CATEGORY_CODE=110 AND GENDER_CODE=2 THEN AMT END) as M_TAMT,
  SUM(CASE WHEN CATEGORY_CODE=110 AND GENDER_CODE=3 THEN AMT END) as F_TAMT,
  SUM(CASE WHEN CATEGORY_CODE=120 AND GENDER_CODE=2 THEN AMT END) as M_AMT,
  SUM(CASE WHEN CATEGORY_CODE=120 AND GENDER_CODE=3 THEN AMT END) as F_AMT
from
  DRINK_HABITS
group by
  PF_CODE) D
inner join
  PREFECTURE P
on
  D.PF_CODE=P.PF_CODE
order by
  PERCENTAGE DESC, CODE DESC
;