1084.sales-analysis-iii.sql

--
-- @lc app=leetcode id=1084 lang=mysql
--
-- [1084] Sales Analysis III
--

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