Easy Step-by-step solution
STEP BY STEP SOLUTION:\n - Select the required columns \n    \n    \n    SELECT p.product_name, SUM(o.unit) AS unit\n\n- We use a LEFT JOIN to join the two tabl
### STEP BY STEP SOLUTION:\n - Select the required columns \n    \n    ```\n    SELECT p.product_name, SUM(o.unit) AS unit\n    ```\n- We use a LEFT JOIN to join the two tables:\n    \n    ```\n    FROM Products p\n    LEFT JOIN Orders o\n    ON p.product_id = o.product_id\n    ```\n- Use the WHERE Clause to put condition on the order_date as follows: \n    \n    ```\n    WHERE MONTH(order_date) = \'02\' AND YEAR(order_date) = \'2020\'\n    ```\n- We use the GROUP BY clause to find the sum of units corresponding to product_id and calculate if sum of units >= 100\n\n    ```\n    GROUP BY p.product_name\n    HAVING unit >= 100 \n\n    ```\n# Code\n```\nSELECT p.product_name, SUM(o.unit) AS unit\nFROM Products p\nLEFT JOIN Orders o\nON p.product_id = o.product_id\nWHERE MONTH(order_date) = \'02\' AND YEAR(order_date) = \'2020\'\nGROUP BY p.product_name\nHAVING unit >= 100 \n\n```\n\n\n\n**\uD83D\uDE07Upvote if this helped**\n
['MySQL', 'Oracle', 'MS SQL Server']