最SQL - MS-SQL Server / 基础类

SQL code:

select
id,s.sid,
(select total_aver_score from car_comment_score where sid = tb2.sid) as '总评分',
supports,series
from
(
select
id,sid,supports,row_number() over (partition by sid order by id desc) as row_id2
from car_comment as comm
) as tb2
inner join car_series as s on tb2.sid = s.sid
where row_id2 = 1 and MinPrice >=0 and MaxPrice <= 550000
order by id desc

现执行如上SQL得到如下的数据，意为不同系列的某一条数据，若现在想得到每个系列下的总个数该怎么弄呢。。。如系列新威驰有88个、昌河海象有35个

---

？？快沉了

---

引用

select
id,s.sid,
(select total_aver_score from car_comment_score where sid = tb2.sid) as '总评分',
supports,series, count(series) AS seriesNum
from
(
select
id,sid,supports,row_number() ove……

还是没看到我要的结果。。。

---

SQL code:
select
id,s.sid,
(select total_aver_score from car_comment_score where sid = tb2.sid) as '总评分',
supports,series,count(1)over(partition by series) as 总个数
from
(
select
id,sid,supports,row_number() over (partition by sid order by id desc) as row_id2
from car_comment as comm
) as tb2