Simple Solutions Beats 99% of Users runtime  🚀
IntuitionStep 1: Get all the required info from the Orders table, as per this problem statement we need to get all the products that have total units sold >= 10
# Intuition
Step 1: Get all the required info from the Orders table, as per this problem statement we need to get all the products that have total units sold >= 100 and in month of Feb 2020.

# Approach
Get all the product_id and sum(unit) >= 100 and order_date between 2020-02-01 and 2020-02-29 from the Orders table, and then Join the Products table p on product_id to get the product_name

# 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
select p.product_name,sum(o.unit) as unit
from Orders o
join Products p on p.product_id = o.product_id
where o.order_date between '2020-02-01' and '2020-02-29'
group by o.product_id
having unit >= 100;
```
['MySQL']