SQL/LeetCode

[1407] Top Travellers

소금깨 2022. 7. 11. 16:33
 

Top Travellers - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

 

문제 조건 

유저별 이동한 거리를 출력하시오

travelled_distance를 기준으로 내림차순하고, 같을 경우 name을 기준으로 오름차순 정렬하시오. 

 

# LEFT JOIN 
SELECT name, SUM(COALESCE(R.distance,0)) AS travelled_distance
FROM Users U 
    LEFT JOIN Rides R ON U.id = R.user_id 
GROUP BY R.user_id
ORDER BY travelled_distance DESC, name ASC;