WITH total AS 
(
 SELECT
  a.PF_CODE AS CODE,
  b.PF_NAME AS NAME,
  a.AMT AS AMT
 FROM
  DRINK_HABITS AS a
 LEFT JOIN
  PREFECTURE AS b
 USING
  (PF_CODE)
 WHERE
  CATEGORY_CODE = '110'
),

total_drink AS 
(
 SELECT
  a.PF_CODE AS CODE,
  b.PF_NAME AS NAME,
  a.AMT AS AMT
 FROM
  DRINK_HABITS AS a
 LEFT JOIN
  PREFECTURE AS b
 USING
  (PF_CODE)
 WHERE
  CATEGORY_CODE = '120'
)

SELECT
 a.CODE,
 a.NAME,
 a.AMT AS total,
 b.AMT AS drink,
 b.AMT / a.AMT
FROM
 total AS a
LEFT JOIN
 total_drink AS b
USING
 (CODE)