[LeetCode] 1407. Top Travellers

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT u.name
     , IFNULL(SUM(r.distance), 0) AS travelled_distance
FROM Users AS u
    LEFT JOIN Rides AS r ON u.id = r.user_id
GROUP BY u.id
ORDER BY travelled_distance DESC, name ASC