SQL problem - Product Sales Analysis I

1 min read 101 words

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