请问一个查询语句！

[tuiger2003]

你好，我想将表中一个字段值相同的记录统计，并按统计数的大小排出。比如Communication表,其中有一个字段StreetName,我想找出住在同一条街的人数，并按人数多少顺序列出，请帮我写个SQL查询语句？

[aierong]

select StreetName,count(*) as counts
from Communication as c
group by StreetName
order by c.counts

[yujohny]

select StreetName,Count(*) as Sl from 表 group by StreetName order by Sl

[愉快的登山者]

select streetname, sum(1) 人数 from communication
group by streetname
order by sum(1)

[yujohny]

select StreetName,Count(*) as Sl from Communication
group by StreetName order by Sl

[sdhdy]

select StreetName,Count(1) as Sl from Communication group by StreetName order by Sl

[sdhdy]

--我记得别名不能用在order by后面的，sorry!

[sdhdy]

select streetname, sum(1) 人数 from communication
group by streetname order by sum(1)

[tuiger2003]

对不起，忘记了一点，就是这一查询要建立在另一个字段项相同的情况下。比如同一区。区字段用area表示 。 这个查询可以描述为：将表中一个字段值相同的记录统计，并按统计数的大小排出。比如Communication表,其中有两个字段area,StreetName,我想同一area中，住在同一条街的人数，并按人数多少顺序列出，并且也要列出其所属area.请帮我写个SQL查询语句？
如何办？

[DigJim]

select Area,StreetName,Count(*) as Sl from Communication
group by Area,StreetName order by Sl

[gmlxf]

select Area,StreetName,Count(*) as Number from Communication group by Area,StreetName order by Number

[tuiger2003]

国庆日希望我们的国家更加富强。散分！
前面的朋友是因为我说明不清，是我的错，一样给分！