access SQL 多表查询统计问题,烦请帮忙看一下,谢谢你!答:select a.class,(select count(*) from biao2 c where a.id = c.id group by c.id having count(*)>=2) as 'total>=2',sum(IIf(b.type = '表扬',1,0)) as 表扬,sum(IIf(b.type = '金奖',1,0)) as 金奖,sum(IIf(b.type = '银奖',1,0)) as 银奖 from biao1 a...