728x90
< 문제 >
[SQL50] 1148. Article Views I (SELECT)
< 풀이 >
SELECT author_id AS id
FROM Views
WHERE author_id = viewer_id
GROUP BY author_id
ORDER BY author_id;728x90
'coding_test > SQL 문제' 카테고리의 다른 글
| [LeetCode] 1378. Replace Employee ID With The Unique Identifier (JOIN) (0) | 2025.02.07 |
|---|---|
| [LeetCode] 1683. Invalid Tweets (SELECT) (0) | 2025.02.07 |
| [LeetCode] 595. Big Countries (SELECT) (0) | 2025.02.07 |
| [LeetCode] 584. Find Customer Referee (SELECT) (0) | 2025.02.07 |
| [LeetCode] 1757. Recyclable and Low Fat Products (SELECT) (0) | 2025.02.07 |