SELECT
uid,
suid,
DATE_FORMAT(FROM_UNIXTIME(createtime), '%Y-%m-%d') days,
COUNT(id) COUNT
FROM fm_retail_log.industry_amount_cash_log
WHERE createtime >=1719763200
GROUP BY days,uid,suid;
SELECT
uid,
suid,
DATE_FORMAT(FROM_UNIXTIME(createtime), '%Y-%m-%d') days,
COUNT(id) COUNT
FROM fm_retail_log.industry_amount_cash_log
WHERE createtime >=1719763200
GROUP BY days,uid,suid;