Simple MySQL solution (JOIN, GROUP BY, HAVING, EXTRACT, SUM)
\n# Write your MySQL query statement below\nSELECT\n    product_name,\n    SUM(unit) AS unit\nFROM Orders o\nJOIN Products p ON p.product_id=o.product_id AND EX
```\n# Write your MySQL query statement below\nSELECT\n    product_name,\n    SUM(unit) AS unit\nFROM Orders o\nJOIN Products p ON p.product_id=o.product_id AND EXTRACT(YEAR_MONTH FROM order_date)=202002\nGROUP BY product_name\nHAVING unit >= 100;\n```
['MySQL']