PostgreSQL|Beats 90%|Simple solution with JOIN and GROUP BY
Approach\n Describe your approach to solving the problem. \n\n# Code\n\nSELECT product_name, SUM(o.unit) unit\nFROM products p\n         JOIN orders o on p.prod
# Approach\n<!-- Describe your approach to solving the problem. -->\n\n# Code\n```\nSELECT product_name, SUM(o.unit) unit\nFROM products p\n         JOIN orders o on p.product_id = o.product_id\nWHERE o.order_date >= \'2020-02-01\'\n  AND o.order_date <= \'2020-02-29\'\nGROUP BY product_name\nHAVING SUM(o.unit) >= 100\n```
['PostgreSQL']