MS SQL | JOIN, HAVING
Code\n\nSELECT\n    p.product_name,\n    SUM(o.unit) AS unit\nFROM\n    Products p\n        JOIN Orders o\n        ON p.product_id = o.product_id\n            A
# Code\n```\nSELECT\n    p.product_name,\n    SUM(o.unit) AS unit\nFROM\n    Products p\n        JOIN Orders o\n        ON p.product_id = o.product_id\n            AND o.order_date BETWEEN \'2020-02-01\' AND \'2020-02-29\'\nGROUP BY\n    p.product_name\nHAVING\n    SUM(o.unit) >= 100\n```
['MS SQL Server']