MSSQL simple solution CTE
WITH CTE AS \n(\n    SELECT product_id, SUM(unit) AS unit\n    FROM Orders\n    WHERE LEFT(order_date,7) = \'2020-02\'\n    GROUP BY product_id\n)\n\nSELECT pro
WITH CTE AS \n(\n    SELECT product_id, SUM(unit) AS unit\n    FROM Orders\n    WHERE LEFT(order_date,7) = \'2020-02\'\n    GROUP BY product_id\n)\n\nSELECT product_name, unit\nFROM CTE\nJOIN products AS p\nON CTE.product_id = p.product_id\nWHERE unit > = 100
[]