List the Products Ordered in a Period

[Antim-IWP]

1327. List the Products Ordered in a Period

[iamAntimPal]

# Write your MySQL query statement below
SELECT P.PRODUCT_NAME, SUM(O.UNIT) AS UNIT  
FROM PRODUCTS P  
INNER JOIN ORDERS O  
ON P.PRODUCT_ID = O.PRODUCT_ID  
WHERE O.ORDER_DATE BETWEEN '2020-02-01' AND '2020-02-29'  
GROUP BY P.PRODUCT_NAME  
HAVING SUM(O.UNIT) >= 100;

FOR EPLAIN CLICK ON ME