# Write your MySQL query statement below
SELECT Users.name as name, COALESCE(SUM(distance), 0) as travelled_distance
FROM Users
LEFT JOIN Rides ON Users.id = Rides.user_id
GROUP BY Users.id
ORDER BY travelled_distance DESC, name ASC;