[SQL문제풀기 - Advent of SQL 2025 🎅] 초기 사용자의 친구 관계 찾기

문제

solvesql.com

https://solvesql.com/problems/friendship-between-early-users/

내가 작성한 정답

MySQL, PostgreSQL, SQLite

select user_a_id, user_b_id, user_a_id+user_b_id id_sum
from (select user_a_id, user_b_id, 
              percent_rank() over(order by user_a_id+user_b_id asc) pr
      from edges) e
where pr <= 0.001;