Problem1.sql

#Approach 1
select u.name,ifnull(sum(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, u.name;