Simple Query With Explanation
\n/* Write your T-SQL query statement below */\n-- Remember the seq: Where --> Group by --> Having\n-- First select the table using where clause\n-- Use group b
```\n/* Write your T-SQL query statement below */\n-- Remember the seq: Where --> Group by --> Having\n-- First select the table using where clause\n-- Use group by to group the data\n-- Use having to filter the data after the group by\n\nselect p.product_name, sum(o.unit) as unit from orders o\ninner join products p on p.product_id = o.product_id\nwhere o.order_date between \'02/01/2020\' and \'02/29/2020\'\ngroup by o.product_id, p.product_name having sum(o.unit) >= 100\n```
[]