sql查询 同一个字段下另一个字段个数

select seriesid , count(reportid) from reportsystem
group by seriesid
having count(reportid) > 1