leetcode

Solution to some Leetcode problems written in C++

git clone git://git.dimitrijedobrota.com/leetcode.git

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