#1407 Top Travellers

SELECT u.name,
    CASE 
        WHEN SUM(distance) IS NULL THEN 0
        ELSE SUM(distance)
    END travelled_distance
FROM Users u LEFT JOIN Rides r 
ON u.id = r.user_id
GROUP BY u.name
ORDER BY travelled_distance DESC, u.name ASC

Previous#1179 Reformat Department Table Next#1484 Group Sold Products By The Date

Last updated 3 years ago

Was this helpful?

SELECT u.name,
    CASE 
        WHEN SUM(distance) IS NULL THEN 0
        ELSE SUM(distance)
    END travelled_distance
FROM Users u LEFT JOIN Rides r 
ON u.id = r.user_id
GROUP BY u.name
ORDER BY travelled_distance DESC, u.name ASC

https://leetcode.com/problems/top-travellers/