1327. List the Products Ordered in a Period
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 []
# Write your MySQL query statement below
select product_name,sum(unit)as unit
from Products p
join Orders o
on p.product_id=o.product_id
where order_date between'2020-02-01'and '2020-02-29'
group by p.product_name
having sum(unit)>=100;

```
['Database', 'MySQL', 'PostgreSQL']