SQL 문제 31 - Market Analysis I LeetCode 1158

SQL 문제 31 - Market Analysis I LeetCode 1158 Market Analysis I 풀이 -- ORACLE SELECT U.USER_ID AS BUYER_ID , TO_CHAR(U.JOIN_DATE,'YYYY-MM-DD') AS JOIN_DATE , NVL(COUNT(O.ORDER_ID),0) AS ORDERS_IN_2019 FROM ORDERS O RIGHT OUTER JOIN USERS U ON O.BUYER_ID = U.USER_ID AND TO_CHAR(ORDER_DATE,'YYYY') = '2019' GROUP BY U.USER_ID, U.JOIN_DATE ORDER BY U.USER_ID; -- MYSQL SELECT U.USER_ID AS BUYER_ID , U.JOIN_DATE AS JOIN_DATE , IFNULL(COUNT(O.ORDER_ID),0) AS ORDERS_IN_2019 FROM ORDERS O RIGHT OUTER JOIN U...

원문링크 : SQL 문제 31 - Market Analysis I LeetCode 1158