Easiest solutions to understand. Faster than 90%. [MySQL] [CTE] [Clean Formatting]
Approach 1:\n\n\nSELECT\n    Products.product_name,\n    SUM(Orders.unit) AS unit\nFROM\n    Products\nINNER JOIN\n    Orders\nON\n    Products.product_id = Ord
Approach 1:\n\n```\nSELECT\n    Products.product_name,\n    SUM(Orders.unit) AS unit\nFROM\n    Products\nINNER JOIN\n    Orders\nON\n    Products.product_id = Orders.product_id\nWHERE\n    Orders.order_date BETWEEN \'2020-02-01\' AND \'2020-02-29\'\nGROUP BY\n    Products.product_id\nHAVING\n    unit >= 100\n```\n\nApproach 2:\n\n```\nWITH atleast_100_orders AS (\n    SELECT\n        Orders.product_id,\n        Orders.order_date,\n        SUM(Orders.unit) AS unit\n    FROM\n        Orders\n    WHERE\n        Orders.order_date BETWEEN \'2020-02-01\' AND \'2020-02-29\'\n    GROUP BY\n        Orders.product_id\n    HAVING\n        unit >= 100\n)\n\nSELECT\n    Products.product_name,\n    atleast_100_orders.unit\nFROM\n    Products\nINNER JOIN\n    atleast_100_orders\nON\n    Products.product_id = atleast_100_orders.product_id\n```
['MySQL']