BEATS 97.01% - THE EASIEST SOLUTION
Code\npostgresql []\n-- Write your PostgreSQL query statement below\n\nSELECT p.product_name,\n       t.unit\nFROM products AS p\nRIGHT JOIN\n  (SELECT o.produc
# Code\n```postgresql []\n-- Write your PostgreSQL query statement below\n\nSELECT p.product_name,\n       t.unit\nFROM products AS p\nRIGHT JOIN\n  (SELECT o.product_id,\n          sum(o.unit) AS unit\n   FROM orders AS o\n   WHERE TO_CHAR(o.order_date, \'YYYY-MM\') = \'2020-02\'\n   GROUP BY o.product_id\n   HAVING sum(o.unit) >= 100) AS t ON p.product_id = t.product_id\n```
['PostgreSQL']