HTMLify
Day 42
Views: 2 | Author: djdj
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | # Write your MySQL query statement below SELECT p.product_name, SUM(o.unit) AS unit FROM Products AS p LEFT JOIN Orders AS o ON p.product_id = o.product_id WHERE o.order_date >= '2020-02-01' AND o.order_date < '2020-03-01' GROUP BY p.product_id, p.product_name HAVING SUM(o.unit) >= 100; |