SQL 문제 30 - Top Travellers LeetCode 1407

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

원문링크 : SQL 문제 30 - Top Travellers LeetCode 1407