在Mysql中使用变量
set @num = 1;
select STOREID,CONTACTPHONE,count(*) ARRIVALNUM,CURRENT_DATE -@num COUNTDATE from cater_order_fact
where
CONTACTPHONE
in (
select CONTACTPHONE from crm_dw.cater_order_fact where DATEDIFF(now(),DINNINGTIME) = @num
)
AND DINNINGTIME > date_sub(CURRENT_DATE -@num ,interval 3 month)
group by CONTACTPHONE,STOREID