select (select avg(sales) from 表名 b where (a.date-b.date) between 0 and 20) as [前20日平均销量],* from 表名 a创建表：create table t

mysql 怎么统计七天内的订单，和每日的订单select count(distinct user_id)from(select user_id from db_amazon.tbl_order where `date` = ...unio

select (select avg(sales) from 表名 b where (a.date-b.date) between 0 and 20) as [前20日平均销量],* from 表名 a创建表：create table t

select (select avg(sales) from 表名 b where (a.date-b.date) between 0 and 20) as [前20日平均销量],* from 表名 a创建表：create table t