EASY  MySQL solution using subquery ✅✅✅
please Upvote\n\n# Code\nmysql []\n# Write your MySQL query statement below\nwith tmp as (\n    select product_id, sum(unit) as sumu\n    from orders where MONT
please Upvote\n\n# Code\n```mysql []\n# Write your MySQL query statement below\nwith tmp as (\n    select product_id, sum(unit) as sumu\n    from orders where MONTH(order_date) = 2 and YEAR(order_date) = 2020 \n    group by product_id \n    having sumu >= 100\n)\nselect p.product_name, t.sumu as unit \nfrom Products p join tmp t \non p.product_id = t.product_id;\n```
['MySQL']