1、表结构如下
2、表数据如下
3、SQL如下
select SUM(tt.ll)/count(1) from
(SELECT create_date,SUM(standard_value) as ll
FROM day_statistics_log
where LEFT(create_date,7) ='2022-11' group by create_date ) tt
1、表结构如下
2、表数据如下
3、SQL如下
select SUM(tt.ll)/count(1) from
(SELECT create_date,SUM(standard_value) as ll
FROM day_statistics_log
where LEFT(create_date,7) ='2022-11' group by create_date ) tt