https://blog.csdn.net/shenghuaday/article/details/51549919
～～～Java邮件

设置定时任务，每天18:00触发统计及发送邮件；统计前一天18：00至今天17:59:59的订单数据的数量

SELECT
order_status, COUNT(*) total
FROM
sfproxy.ais_order
WHERE
process_time >= '2019-01-29 18:00:00'
and process_time <= '2019-01-30 18:00:00'
GROUP BY order_status;

SELECT
COUNT(order_status)
FROM
ais_order
WHERE
process_time >= NOW() - INTERVAL 24 hour
and
process_time <= NOW()
and
order_status =3