Dashboard Temp Share Shortlinks Frames API

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;