求一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
