1327. List the Products Ordered in a Period.sql

SELECT
    p.product_name,
    SUM(o.unit) AS unit
FROM products p
LEFT JOIN orders o ON o.product_id = p.product_id
WHERE o.order_date BETWEEN '2020-02-01' AND '2020-02-29'
GROUP BY p.product_id
HAVING SUM(o.unit) >= 100;