1084-sales-analysis-iii

DevGod

Elf Vtuber

Caution

DevGod needs to write an editorial for this problem!

sql

# Write your MySQL query statement below
SELECT product_id, product_name
FROM Product
JOIN Sales
USING (product_id)
GROUP BY product_id
HAVING MAX(sale_date) <= '2019-03-31' AND
MIN(sale_date) >= '2019-01-01'