Month and Year with Left Join
select p.product_name, sum(unit) as unit\nfrom Orders o\nleft join Products p \non o.product_id  = p.product_id \nwhere month(order_date) = 2 and year(order_dat
select p.product_name, sum(unit) as unit\nfrom Orders o\nleft join Products p \non o.product_id  = p.product_id \nwhere month(order_date) = 2 and year(order_date) = 2020\ngroup by o.product_id\nhaving sum(unit) >= 100;
[]