SQL problem - Product Sales Analysis I
Problem
Query
SELECT
product_name,
year,
price
FROM
Sales AS s
JOIN
Product AS p
ON s.product_id = p.product_id
Editorial Solution
SELECT
DISTINCT p.product_name, s.year, s.price
FROM
Sales s
JOIN
Product p
ON
s.product_id = p.product_id