sql 下面这个语句应该如何写，请高手指点

如题所述

select rownum as id,B.bm_name,count(B.bm_sjzs) as "bm_sjzs（事件总数）",avg(B.bm_pjf) as "bm_pjf（平均分）"
from (select bm_name,count(bm_sj) as bm_sjzs,avg(bm_df) as bm_pjf from 表A group by bm_name) B;
这样写试一下，看看是否好用。

温馨提示：内容为网友见解，仅供参考

当前网址：https://22.t2y.org/zz/22662c0h0c2icff26f.html