連番のカラムを作る

--連番のカラムを作る
CREATE TABLE #T(name varchar(100))

INSERT INTO #T VALUES ('ABC'),('DEF'),('GHI')

SELECT t1.name, count(*) AS seq
 FROM #T t1
  INNER JOIN #T t2 ON t1.name >= t2.name
 GROUP BY t1.name
 ORDER BY seq DESC
DROP TABLE #T