Top Travellers.md

⚙문제보기

🔎문제 풀이 MySQL

SELECT DISTINCT name, COALESCE(SUM(distance) OVER(PARTITION BY U.id), 0) AS 'travelled_distance'
FROM Users U LEFT JOIN Rides R ON U.id = R.user_id
ORDER BY travelled_distance DESC, name;