728x90
< 문제 >
[SQL50] 1068. Product Sales Analysis I (JOIN)


< 풀이 >
SELECT B.product_name, A.year, A.price
FROM Sales A LEFT JOIN Product B ON A.product_id = B.product_id;
728x90
'coding_test > SQL 문제' 카테고리의 다른 글
[LeetCode] 197. Rising Temperature (JOIN) (0) | 2025.02.08 |
---|---|
[LeetCode] 1581. Customer Who Visited but Did Not Make Any Transactions (JOIN) (0) | 2025.02.07 |
[LeetCode] 1378. Replace Employee ID With The Unique Identifier (JOIN) (0) | 2025.02.07 |
[LeetCode] 1683. Invalid Tweets (SELECT) (0) | 2025.02.07 |
[LeetCode] 1148. Article Views I (SELECT) (0) | 2025.02.07 |