初学者，有个sql语句写不出来，请帮忙看看
假设我在给别人发钞票。每次来人就给一元。
建表send，只有一个字段，id 表示每个人的id。
发了几天终于发完了，现在我想统计来领了1次的人有多少，领了两次的人有多少，领了5次的人有多少？？？
该怎么写呢 ？？？？？？？？？？？？？？？？？？？？？？？？
[解决办法]
select id,count(1) as 次数 from tablename group by id
[解决办法]
select 次数,count(1) from (select id,count(1) as 次数 from tablename group by id) t group by 次数
[解决办法]
select count(*) from send group by id having count(*)=1 or having count(*)=2 or having count(*)=5
[解决办法]
select id,count(1) as 次数 from tablename group by id
[解决办法]
select id,count(*) as 次数
from tb group by id
having count(*)=?
[解决办法]
Create Table TEST(ID Int)
Insert TEST Select 1
Union All Select 2
Union All Select 3
Union All Select 2
Union All Select 3
Union All Select 1
Union All Select 5
Union All Select 3
Union All Select 7
GO
Select 次數, Count(*) As 人數 From
(
Select ID, Count(*) As 次數 From TEST Group By ID) A
Group By 次數
Order By 次數
Go
Drop Table TEST
/*
次數人數
12
22
31
*/
