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'