Simple & Easy Solution Using Group by and Having Clause
Code\n\n/* Write your PL/SQL query statement below */\nselect p.product_name, sum(unit) as unit \nfrom products p \njoin orders o on p.product_id = o.product_id
# Code\n```\n/* Write your PL/SQL query statement below */\nselect p.product_name, sum(unit) as unit \nfrom products p \njoin orders o on p.product_id = o.product_id \nwhere to_char(order_date, \'MON-YYYY\') = \'FEB-2020\' \ngroup by p.product_name \nhaving sum(unit ) >= 100\n```
['MySQL', 'Oracle', 'MS SQL Server']