SOLUTION WITH INNER JOIN ( SQL SERVER )
Intuition\r\n Describe your first thoughts on how to solve this problem. \r\n\r\n# Approach\r\n Describe your approach to solving the problem. \r\n\r\n# Complex
# Intuition\r\n<!-- Describe your first thoughts on how to solve this problem. -->\r\n\r\n# Approach\r\n<!-- Describe your approach to solving the problem. -->\r\n\r\n# Complexity\r\n- Time complexity:\r\n<!-- Add your time complexity here, e.g. $$O(n)$$ -->\r\n\r\n- Space complexity:\r\n<!-- Add your space complexity here, e.g. $$O(n)$$ -->\r\n\r\n# Code\r\n```\r\n# Write your MySQL query statement below\r\n\r\n\r\nWITH CTE AS (\r\n        SELECT\r\n            T2.product_name,\r\n            SUM(T1.unit) unit\r\n        FROM\r\n            Orders T1\r\n        INNER JOIN\r\n            Products T2 ON T1.product_id = T2.product_id\r\n        WHERE\r\n            order_date > \'2020-01-31\' AND \r\n            order_date < \'2020-03-01\'\r\n        GROUP BY\r\n            T2.product_name\r\n)\r\nSELECT\r\n    *\r\nFROM\r\n    CTE \r\nWHERE\r\n    unit > 99\r\n```
['MySQL']