SQL contar registros de una misma columna

[Libras]

complejo complejo la verdad no...un poco de logica nada mas :P

Código SQL:

CREATE TABLE #temp
(
codigo VARCHAR(20),
codigo1 VARCHAR(20)
)
 
INSERT INTO #temp VALUES ('I20','I21')
INSERT INTO #temp VALUES ('I20','I21')
INSERT INTO #temp VALUES ('I20','A1')
INSERT INTO #temp VALUES ('IEE0','A2')
INSERT INTO #temp VALUES ('IEE0','A3')
INSERT INTO #temp VALUES ('IEE1','A3')
INSERT INTO #temp VALUES ('IEE2','A3')
INSERT INTO #temp VALUES ('IEE2','IEE2')
 
 
SELECT SUM(total) total, codigo FROM(
SELECT COUNT(codigo) AS total, codigo FROM #temp GROUP BY codigo
UNION
SELECT COUNT(codigo1) AS total, codigo1 FROM #temp GROUP BY codigo1
) t1 GROUP BY codigo
 
----------------------Resultado----------------------
 
1   A1
1   A2
3   A3
3   I20
2   I21
2   IEE0
1   IEE1
3   IEE2
 

saludos!