SELECT e.SURVEY_YEAR SV_YEAR, p.PF_NAME PREFECTURE, a.name Kind,
       SUM(COALESCE(e.ELEMENTARY, -100000) * a.elem +
           COALESCE(e.MIDDLE, -100000) * a.mid +
           COALESCE(e.HIGH, -100000) * a.high +
           COALESCE(e.JUNIOR_CLG, -100000) * jrclg +
           COALESCE(e.COLLEGE, -100000) * a.clg +
           COALESCE(e.GRADUATE, -100000) * a.grd) AMT FROM ENROLLMENT_STATUS e
JOIN PREFECTURE p ON e.PF_CODE = p.PF_CODE
LEFT JOIN (
  SELECT column1 name, column2 elem, column3 mid, column4 high, column5 jrclg, column6 clg, column7 grd, column8 sort
  FROM (VALUES ('小学校', 1, 0, 0, 0, 0, 0, 1), ('中学校', 0, 1, 0, 0, 0, 0, 2), ('高校', 0, 0, 1, 0, 0, 0, 3),
              ('短大', 0, 0, 0, 1, 0, 0, 4), ('大学', 0, 0, 0, 0, 1, 0, 5), ('大学院', 0, 0, 0, 0, 0, 1, 6))
) a
WHERE SV_YEAR = '2020'
GROUP BY e.PF_CODE, Kind HAVING AMT >= 0
ORDER BY p.PF_CODE ASC, a.sort ASC;