Faster than 95.27% of Oracle online submissions for Sales Analysis III
\nselect p.product_id\n        ,p.product_name\nfrom product p\njoin (select s.product_id from sales s\n      group by s.product_id\n      having min(s.sale_dat
```\nselect p.product_id\n        ,p.product_name\nfrom product p\njoin (select s.product_id from sales s\n      group by s.product_id\n      having min(s.sale_date) >= \'2019-01-01\'\n      and max(s.sale_date) <= \'2019-03-31\') s1\non\np.product_id = s1.product_id\n```
['Oracle']