SELECT
count(1),
SUM(mb.pay_money) AS payMoney,
substr(mb.create_time, 1, 10)
FROM
market_bill mb
WHERE
mb.market_id = 378379036843991041
AND (
mb.bill_state = mb.bill_state = 20
OR mb.bill_state = 15
)
AND mb.create_time LIKE '2019-09%'
GROUP BY
substr(mb.create_time, 1, 10)
