Simple & Easy-to-Understand Solution
\'\'\'\n\n\n\tselect s.product_id, p.product_name\n\tfrom sales s, product p\n\twhere s.product_id = p.product_id\n\tgroup by s.product_id, p.product_name\n\tha
\'\'\'\n\n\n\tselect s.product_id, p.product_name\n\tfrom sales s, product p\n\twhere s.product_id = p.product_id\n\tgroup by s.product_id, p.product_name\n\thaving min(s.sale_date) >= \'2019-01-01\' \n\t\tand max(s.sale_date) <= \'2019-03-31\'\n\'\'\'
['MySQL']