[SQL문제풀기] 최대값을 가진 행 찾기

문제

solvesql.com

https://solvesql.com/problems/max-row/

SQLite

내가 작성한 정답

select id
from points
where (id,x) = (select id, max(x) from points)
    or (id,y) = (select id, max(y) from points)
order by 1 asc