Very Simple and Easy to Understand Solution using CTE!
ApproachCombine the tables and GROUP the products with SUM of units (Filter the date here as well). Make that a CTE and query of that table to check whether uni
# Approach
Combine the tables and GROUP the products with SUM of units (Filter the date here as well). Make that a CTE and query of that table to check whether unit count is at least 100.


# Code
```mysql []
# Write your MySQL query statement below

WITH full_table AS (
    SELECT product_name, SUM(unit) AS unit
    FROM Products p
    JOIN Orders o USING(product_id)
    WHERE order_date LIKE '2020-02-__'
    GROUP BY product_name
    )
SELECT product_name, unit
FROM full_table
WHERE unit >= 100
;
```
['MySQL']