代码:
sql完结撒花!!!
# Write your MySQL query statement below
select product_name, sum(unit) as unit
from(
select p.product_id,p.product_name,o.order_date,o.unit
from Products as p
left join Orders as o
on p.product_id = o.product_id
where o.order_date between '2020-02-01' and '2020-02-29'
)t1
group by t1.product_id
having sum(unit) >= 100