Skip to content

1084. Sales Analysis III 👍

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
SELECT
  Product.product_id,
  Product.product_name
FROM Product
INNER JOIN Sales
  USING (product_id)
GROUP BY 1, 2
HAVING SUM(
    Sales.sale_date < '2019-01-01'
    OR Sales.sale_date > '2019-03-31'
  ) = 0;