[ MYSQL ] ✅✅ Simple MYSQL Solution Using Having Clause || Group By 🥳✌👍
If You like the Solution, Don\'t Forget To UpVote Me, Please UpVote! \uD83D\uDD3C\uD83D\uDE4F\n# Runtime: 998 ms, faster than 87.37% of MySQL online submissions
# If You like the Solution, Don\'t Forget To UpVote Me, Please UpVote! \uD83D\uDD3C\uD83D\uDE4F\n# Runtime: 998 ms, faster than 87.37% of MySQL online submissions for Sales Analysis III.\n# Memory Usage: 0B, less than 100.00% of MySQL online submissions for Sales Analysis III.\n\n\tselect p.product_id, p.product_name\n\tfrom Product p\n\tinner join Sales s on p.product_id = s.product_id\n\tgroup by s.product_id\n\thaving min(sale_date) >= \'2019-01-01\'\n\tand max(sale_date) <= \'2019-03-31\';
['MySQL']