✅ 100% EASY || FAST 🔥|| CLEAN SOLUTION 🌟
\n\n# Code\n\nSELECT P.product_name, SUM(O.unit) unit FROM Products P LEFT OUTER \n\nJOIN Orders O  ON P.product_id = O.product_id WHERE TO_CHAR(order_date,\n\n
\n\n# Code\n```\nSELECT P.product_name, SUM(O.unit) unit FROM Products P LEFT OUTER \n\nJOIN Orders O  ON P.product_id = O.product_id WHERE TO_CHAR(order_date,\n\n\'YYYY-MM\') = \'2020-02\' GROUP BY product_name  HAVING SUM(unit) >= 100;\n```\n![5kej8w.jpg](https://assets.leetcode.com/users/images/a17f17f8-c295-49d9-8192-d00188a85826_1717491434.1059835.jpeg)\n
['Database', 'Oracle']