✅✅Simple solution using left join ||
IntuitionApproachComplexity
Time complexity:

Space complexity:
Code
# Intuition
<!-- Describe your first thoughts on how to solve this problem. -->

# 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 []
select p.product_name, sum(o.unit) as unit
from products p
left join orders o
on p.product_id   = o.product_id   
where extract(year_month from o.order_date) = 202002
group by o.product_id
having sum(o.unit) >=100
```
['MySQL']