leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE

1407.sql (188B)

0 SELECT U.name,
1 IFNULL(SUM(R.distance), 0) AS travelled_distance
2 FROM Users U
3 LEFT JOIN Rides R
4 ON U.id = R.user_id
5 GROUP BY U.id
6 ORDER BY SUM(R.distance) DESC,
7 U.name ASC