Skip to content

Latest commit

 

History

History
10 lines (10 loc) · 367 Bytes

1084. Sales Analysis III.md

File metadata and controls

10 lines (10 loc) · 367 Bytes

1084. Sales Analysis III

Question Link

Solution

# Write your MySQL query statement below
select s.product_id, p.product_name from Sales s left join Product p on s.product_id=p.product_id
group by product_id
having min(s.sale_date) >='2019-01-01' and max(s.sale_date)<='2019-03-31'
  • 2024.06.04