01327-list-the-products-ordered-in-a-period.sql

-- normal join- can use Inner or Left join, use HAVING CLAUSE for sum of units

select p.product_name, sum(unit) as unit
from Orders o
left join Products p
on o.product_id = p.product_id
where o.order_date like '2020-02%'
group by o.product_id
having sum(unit) >= 100


-- amazon- 1