리트코드(LeetCode) SQL 문제풀이 - 1407. Top Travellers

MySQL 문제 1407. Top Travellers

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 u.id
    order by 2 desc,1 asc;