SQL
leetcode 1407. Top Travellers
무적김두칠
2022. 3. 31. 10:05
|
1
2
3
4
5
6
|
# Write your MySQL query statement below
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 2 desc, 1 asc
|
cs |
반응형