[Leetcode] Article Views I

문제 링크

정답

SELECT DISTINCT author_id as id
FROM Views 
WHERE author_id = viewer_id
ORDER BY 1;

✅ Point

• DISTINCT을 통해 unique 한 값 가져오기
• Order of Execution
  • FROM Views > WHERE author_id = viewer_id > SELECT DISTINCT author_id AS id > ORDER BY 1