SQLで、１列を複数列に分けたい

SELECT 
  MAX(CASE WHEN クラス = 1 THEN 名前 END) AS クラス1,
  MAX(CASE WHEN クラス = 2 THEN 名前 END) AS クラス2
FROM (
  SELECT *, ROW_NUMBER() OVER (PARTITION BY クラス ORDER BY 名前) rn
  FROM T
) X
GROUP BY rn;

CREATE TABLE IF NOT EXISTS `team` (
  `id` int(6) unsigned NOT NULL,
  `class` int(3) unsigned NOT NULL,
  `name` varchar(10) NOT NULL,
  PRIMARY KEY (`id`, `class`)
) DEFAULT CHARSET = utf8;

INSERT INTO `team` (`id`, `class`, `name`) VALUES
  ('1', '1', 'hoge'),
  ('2', '1', 'fuga'),
  ('3', '1', 'piyo'),
  ('4', '2', 'hogehoge'),
  ('5', '2', 'fugafuga'),
  ('6', '2', 'piyopiyo');

SELECT 
  id,
  MAX(CASE WHEN class = 1 THEN name END) AS class1,
  MAX(CASE WHEN class = 2 THEN name END) AS class2
FROM
  team
WHERE class IN(1, 2)
GROUP BY id