EASY UNDERSTANDABLE SQL CODE
IntuitionThere are conditions applied on product_id. So that's why i applied group by on product_id and HAVING clause on sum(units)>=100.
Before this i want pro
# Intuition
<!-- Describe your first thoughts on how to solve this problem. -->
There are conditions applied on product_id. So that's why i applied group by on product_id and HAVING clause on sum(units)>=100.
Before this i want products in month of february  and in year 2020 only so that's why i applied WHERE clause.
After this using CTC i stored this table in t. Now i just have to join the product table ans this t table to get this answer.

# Approach
<!-- Describe your approach to solving the problem. -->

# Complexity
- Time complexity:
<!-- Add your time complexity here, e.g. $$O(n)$$ -->

- Space complexity:
<!-- Add your space complexity here, e.g. $$O(n)$$ -->

# Code
```mysql []
# Write your MySQL query statement below
WITH t AS (SELECT product_id,SUM(unit) AS unit_1
FROM Orders
WHERE MONTH(order_date)=2 AND YEAR(order_date)=2020
GROUP BY product_id
HAVING unit_1>=100)
SELECT p.product_name,t.unit_1 AS unit
FROM t
JOIN Products p
ON p.product_id=t.product_id
```
['MySQL']