728x90
https://leetcode.com/problems/product-sales-analysis-i/
SELECT p.product_name, s.year, s.price
FROM Sales as s
INNER JOIN Product as p ON s.product_id = p.product_id;
728x90
'IT > 코딩테스트' 카테고리의 다른 글
| [Leetcode] 620. Not Boring Movies (0) | 2023.08.25 |
|---|---|
| [Leetcode] 26. Remove Duplicates from Sorted Array (0) | 2023.08.24 |
| [Leetcode] 283. Move Zeroes (0) | 2023.08.23 |
| [Leetcode] 1378. Replace Employee ID With The Unique Identifier (0) | 2023.08.23 |
| [Leetcode] 595. Big Countries (0) | 2023.08.22 |