Having and group by

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'

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'

M	T	W	T	F	S	S
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30

Rex's Personal Site

This site is built on WordPress and contains personal notes, photos and videos

Having and group by