SELECT
  PR.PF_CODE CODE
  , PR.PF_NAME NAME
  , round(cast(A120 as REAL) / cast(ALLP as REAL) * 100 , 1) PERCENTAGE
FROM
(
SELECT
 sum(CASE WHEN CATEGORY_CODE = '120' THEN AMT ELSE null end) A120
 , sum(AMT) ALLP
 , PF_CODE
FROM
 DRINK_HABITS
GROUP BY
 PF_CODE
) as DH
INNER JOIN PREFECTURE PR ON PR.PF_CODE = DH.PF_CODE
ORDER BY
  PERCENTAGE DESC
  , CODE DESC
;