平均数查询

Question

我想实现以上查询，请兄弟们帮忙！

Answer 1

select convert(varchar(10),info_date,120),avg(info_used) 
from tb group by convert(varchar(10),info_date,120),

Answer 2

select id,AVG(分数)
FROM TABLE
GROUP BY id

Answer 3

select convert(char(10),info_date,120),avg(info_used)
from td group by infodate
group by convert(char(10),info_date,120)

Answer 4

select info_date,avg(info_used) as info_used from tb group by info_date

Answer 5

select convert(char(10),info_date,120) as info_date,avg(info_used) as info_used
from tb
group by convert(char(10),info_date,120)

Answer 6

select convert(char(10),info_date,120) as info_date,avg(info_used) as info_used
from tb
group by convert(char(10),info_date,120)
+++