问句SQL怎么写，谢谢！

[gwsr]

一个表（其实是视图），两个字段，name和a，a只有两种值，要么是A，要么是B，现在表中数据是：

name a
------------
aaaa A
aaaa B
aaaa A
aaaa A
bbbb A
cccc B
cccc A

我要得到两个数，
1、name是aaaa的记录总数
2、name是aaaa的，并且a字段内容是A的记录总数
要求结果只有一条记录。
---------------
谢谢各位！

[QQMagicer]

select count(*) from tablename where name = 'aaaa'

select count(*) from tablename where name = 'aaaa' and a = 'A'

[lxzm1001]

select sum(name) from tablename where name='aaaa'
select sum(a) from tablename where a='A'

[zlp321002]

Agree 1 floor

[lxzm1001]

i am very sorry
select count(name) from tablename where name='aaaa'
select count(a) from tablename where a='A'

[churchatp1]

select count(*) as num1,(select count(*) from tablename where name='aaaa' and a='A')as num2 from tablename where name = 'aaaa'

[churchatp1]

这样就只有一条记录了