MySQL / 행을 열로

SELECT b.largedivisionid AS large_division_name, MAX(b.NAME1) AS small_division_name,
       MAX(b.NAME2) AS small_division_name, MAX(b.NAME3) AS small_division_name, MAX(b.NAME4) AS small_division_name
FROM
(
 SELECT largedivisionid,
  CASE WHEN NAME = '학원/교육기관' THEN NAME END AS NAME1,
  CASE WHEN NAME = '유아용품점' THEN NAME END AS NAME2,
  CASE WHEN NAME = '온라인강의' THEN NAME END AS NAME3,
  CASE WHEN NAME = '기타' THEN NAME END AS NAME4
 FROM
 (
  SELECT largedivisionid, NAME
  FROM smalldivision
 ) a
) b
WHERE b.largedivisionid = 'LD00000002'
;