[LeetCode/MySQL50] 1068. Product Sales Analysis I
2025. 1. 14. 23:27ㆍ개인활동/코테
반응형
Problem
Solution
# Write your MySQL query statement below
select Product.product_name, Sales.year, Sales.price
from Sales
inner join Product on Sales.product_id = Product.product_id;
여기서는 그냥 join을 사용해도 상관 없음
반응형
'개인활동 > 코테' 카테고리의 다른 글
[LeetCode/MySQL50] 197. Rising Temperature (0) | 2025.01.28 |
---|---|
[LeetCode/MySQL50] 1581. Customer Who Visited but Did Not Make Any Transactions (0) | 2025.01.22 |
[LeetCode/MySQL50] 1378. Replace Employee ID With The Unique Identifier (0) | 2025.01.13 |
[LeetCode/MySQL50] 1683. Invalid Tweets (0) | 2025.01.13 |
[LeetCode/MySQL50] 1148. Article Views I (0) | 2025.01.12 |