Beginner-Friendly Solution Using SQL Server || Clear
\n# Complexity\n- Time complexity:\n Add your time complexity here, e.g. O(n) \n\n- Space complexity:\n Add your space complexity here, e.g. O(n) \n\n# Code\n\n
\n# Complexity\n- Time complexity:\n<!-- Add your time complexity here, e.g. $$O(n)$$ -->\n\n- Space complexity:\n<!-- Add your space complexity here, e.g. $$O(n)$$ -->\n\n# Code\n```\n/* Write your T-SQL query statement below */\nselect product_name, sum(unit) as unit\nfrom Products p\njoin Orders o on p.product_id = o.product_id\nwhere year(order_date) = 2020 and month(order_date) = 2\ngroup by p.product_id, product_name\nhaving sum(unit) >= 100\n\n```
['MS SQL Server']