MySQL, join, group by, having
\nSELECT p.product_name, SUM(o.unit) AS unit\nFROM Products p JOIN Orders o ON p.product_id = o.product_id\nWHERE MONTH(order_date) = 2 AND YEAR(order_date) = 2
```\nSELECT p.product_name, SUM(o.unit) AS unit\nFROM Products p JOIN Orders o ON p.product_id = o.product_id\nWHERE MONTH(order_date) = 2 AND YEAR(order_date) = 2020 \nGROUP BY p.product_name HAVING SUM(o.unit) >= 100\n```
['MySQL']