sqlserver数据加总排序的语句怎么写？

sqlserver数据加总排序的语句怎么写？
如下数据表table
id
a
a
a
b
b
c

我要得到的为：
a 3
b 2
c 1

这样加总id名称一样的并进行排序应该怎么写？

---

SQL code:
select id,count(1) from tb group by id

---

SQL code:
SELECT *,(SELECT COUNT(1) from TB WHERE ID=T.ID)AS NUM
from TB T ORDER BY
(SELECT COUNT(1) from TB WHERE ID=T.ID) DESC

---

SQL code:
select id,count(1) as px from tb order by px desc

这样？还是巧合？

---

SQL code:
select id,count(1) from tb group by id ORDER BY 2 DESC

---

SQL code:
select id,count(1) as px from tb order by count(1) desc

---

SQL code:
---测试数据---
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([id] varchar(1))
insert [t