Sunbelt Computer Software

PL/B Language Development and Support

Home
About
Blog
Products
Forum
Support
Contact

Leetcode/database/_1407.sql at master · Algorithm-box/Leetcode · GitHub

9 lines (8 loc) · 284 Bytes

--# Write your MySQL query statement below
--credit: https://leetcode.com/problems/top-travellers/discuss/572803/MySQL-Simple-Solution
select name, sum(ifnull(distance, 0)) as travelled_distance
from rides r
right join users u
on r.user_id = u.id
group by name
order by 2 desc,1 asc;

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

_1407.sql

Latest commit

History

_1407.sql

File metadata and controls