SQL 문제 30 - Top Travellers LeetCode 1407 Top Travellers 풀이 -- ORACLE SELECT NAME , NVL(SUM(R.DISTANCE),0) AS TRAVELLED_DISTANCE FROM USERS U LEFT OUTER JOIN RIDES R ON U.ID = R.USER_ID GROUP BY NAME, U.ID ORDER BY TRAVELLED_DISTANCE DESC, U.NAME ASC; -- MYSQL SELECT NAME , IFNULL(SUM(R.DISTANCE),0) AS TRAVELLED_DISTANCE FROM USERS U LEFT OUTER JOIN RIDES R ON U.ID = R.USER_ID GROUP BY NAME, U.ID ORDER BY TRAVELLED_DISTANCE DESC, U.NAME ASC; -- MSSQL SELECT NAME , ISNULL(SUM(R.DISTANCE),0) AS TRA...
#
SQL
#
SQL_LeetCode1407
#
SQL_TopTravellers
#
SQL_TopTravellers_LeetCode1407
#
TopTravellers_LeetCode1407
