Database 1407. Top Travellers ¶ SQL 1 2 3 4 5 6 7 8SELECT Users.name, IFNULL(SUM(Rides.distance), 0) AS travelled_distance FROM Users LEFT JOIN Rides ON (Users.id = Rides.user_id) GROUP BY Users.id ORDER BY 2 DESC, 1; Was this page helpful? Thanks for your feedback! Thanks for your feedback! Help us improve this page by using our feedback form.