1 2 3 4 5 |
SELECT mission_start, sum(product_quantity) as total FROM `orders` where status = 1 group by mission_start having DATE_SUB(mission_start, INTERVAL 1 Day) = '2018-11-04' |
1 2 3 4 5 |
SELECT mission_start, sum(product_quantity) as total FROM `orders` where status = 1 group by mission_start having DATE_SUB(mission_start, INTERVAL 1 Day) = '2018-11-04' |