力扣---高频SQL题---48---1327. 列出指定时间段内所有的下单产品

一、题目

二、代码

# Write your MySQL query statement below
-- select * from Products


select Products.product_name , table1.sum_count as unit   from
(
    select  table1.product_id ,sum(table1.unit ) as sum_count from
    (
        select * from Orders 
        where order_date >=  '2020-02-01' and order_date <=  '2020-02-29'
    ) as table1
    group by table1.product_id 
    having sum_count >= 100
) as table1
join Products
on table1.product_id = Products.product_id

三、运行结果