求一SQL

[梅子]

表A如下：
[Title] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[AnswerTime] [datetime] NULL,
[AnswerName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,

实例数据如下：

Title           AnsterTime               AnswerName
111            2011-01-01 00:00:00       BBB
111            2011-01-02 21:00:00       AAA
222            2011-01-02 22:00:00       BBB
333            2011-01-03 09:00:00       CCC
111            2011-01-03 20:00:00       BBB
222            2011-01-04 02:00:00       CCC
444            2011-01-04 03:00:00       CCC
..........

select count(*),answername from A where answertime>=? and answertime<=? group by answername

我要想的结果是：

AnswerName    count(*)      Title次数
BBB           3               2 (一共有2个Title，111和222)
AAA           1               1 (一共有1个Title，111)
CCC           2               3 (一共有2个Title，333、222和444)

不知道表达清楚没啊。。。求教大大们~~~

[快溜]

select count(*),count(distinct Title) as Title,answername 
from A where answertime>=? and answertime<=? group by answername

[--小F--]

select answername,count(1),count(distinct title) from tb group by answername

[一十七]

select answername,count(1),count(distinct title) from tb group by answername



+1

[梅子]

谢谢大大们，结贴