/*两周充值分日数据*/

/两周充值分日数据/

SELECT DATE_FORMAT(op_time,'%m-%d-%Y') as time,count(distinct T.user_id) as '充值人数',count(T.user_id) as '充值笔数',sum(T.amount/100000000 )as '充值金额'
FROM management.t_deposit as T 
join management.t_trade_user as U on U.USER_ID = T.USER_ID  
WHERE U.language='EN'
and op_time>=(NOW() - interval 336 hour)
group by time
order by updated_at desc

/查询两周充值/

SELECT T.*
FROM management.t_deposit as T 
join management.t_trade_user as U on U.USER_ID = T.USER_ID  
WHERE U.language='EN'
and op_time>=(NOW() - interval 336 hour)
order by updated_at desc