求一SQL语句，万分感谢
现有一张表名为T，共有四个字段（C1，C2，C3，C4），有如下数据

C1C2C3C4

AACB
CDBA
DACB
CCBA
ADCA
DCAB
BADA
CADD
DCBA

要求用SQL语句进行统计，实现如下输出

AlphabetCountNum
A12
B7
C9
D8



[解决办法]
amandag(高歌) ( )
是不能统计出来的

字段的值 是在不同的数据列中
[解决办法]
楼上的还是测试一下吧，谢谢提醒，少了All

create table T
(
C1 varchar(10),
C2 varchar(10),
C3 varchar(10),
C4 varchar(10)
)

insert into T values( 'A ', 'A ', 'C ', 'B ')
insert into T values( 'C ', 'D ', 'B ', 'A ')
insert into T values( 'D ', 'A ', 'C ', 'B ')
insert into T values( 'C ', 'C ', 'B ', 'A ')
insert into T values( 'A ', 'D ', 'C ', 'A ')
insert into T values( 'D ', 'C ', 'A ', 'B ')
insert into T values( 'B ', 'A ', 'D ', 'A ')
insert into T values( 'C ', 'A ', 'D ', 'D ')
insert into T values( 'D ', 'C ', 'B ', 'A ')

select c1 as Alphabet , count(c1) AS CountNum
from
(select c1 from T
union all
select c2 from T
union all
select c3 from T
union all
select c4 from T) as A
group by c1