单位取平均分排榜

select (select mc from gs where bm = (select dw from jbxx where openid = qdtest.[openid] ) )as dd, total as tt from qdtest   where ksbm in (select ksbm from kdtest where ksztbm = '20001')

select count(dd) as rs, avg(tt) as fs, dd as dw  from yzbw group by dd order by fs DESC