1148. Article Views I

https://leetcode.com/problems/article-views-i/

Article Views I - LeetCode

select distinct a.author_id as id
from Views as a
where a.author_id = a.viewer_id
order by id

best

SELECT AUTHOR_ID AS ID
FROM VIEWS
WHERE AUTHOR_ID=VIEWER_ID
GROUP BY ID
ORDER BY ID;