select convert(char(10),sj,120) as sj,avg(sksw) as sksw,avg(skkr) as skkr
from tablename
group by convert(char(10),sj,120)
order by convert(char(10),sj,120)
from tablename
group by convert(char(10),sj,120)
order by convert(char(10),sj,120)
from tablename
group by convert(char(10),sj,120)
order by convert(char(10),sj,120)
from 表
group by sj
order by sj
from tablename
group by convert(char(10),sj,120)
order by convert(char(10),sj,120)