Simple solution with INNER JOIN and BETWEEN
Approach\nMakes use of INNER JOIN and BETWEEN. \n\n# Code\n\nSELECT p.product_name, SUM(o.unit) AS unit\nFROM Products p \nINNER JOIN Orders o\nON p.product_id 
# Approach\nMakes use of **INNER JOIN** and **BETWEEN**. \n\n# Code\n```\nSELECT p.product_name, SUM(o.unit) AS unit\nFROM Products p \nINNER JOIN Orders o\nON p.product_id = o.product_id\nWHERE o.order_date BETWEEN \'2020-02-01\' AND \'2020-02-29\'\nGROUP BY o.product_id\nHAVING SUM(o.unit) >= 100;\n\n```\n
['Database', 'MySQL']