Myql Using Month and Year function
select product_name,sum(unit) as unit\nfrom Products a\nleft join Orders b on a.product_id = b.product_id\nwhere month(order_date) = 2 and year(order_date) = \'
select product_name,sum(unit) as unit\nfrom Products a\nleft join Orders b on a.product_id = b.product_id\nwhere month(order_date) = 2 and year(order_date) = \'2020\'\ngroup by a.product_id\nHaving unit >=100
[]