这是代码：
select date_part('month',inspection.idate) as _month,inspector.iname,count(inspector.iname) as num
from inspector,inspection
where inspection.idate>='2021/1/1' and inspector.iid = inspection.iid
group by inspector.iname,_month
order by _month
结果如下： enter image description here
需要显示每个月的前 1 个计数，对于第 6 个月，有 2 个计数相同，需要同时显示。