SQL 문제 35 - Sales Analysis III LeetCode 1084

SQL 문제 35 - Sales Analysis III LeetCode 1084 Sales Analysis III 풀이 - ORACLE, MSSQL SELECT S.PRODUCT_ID, P.PRODUCT_NAME FROM SALES S INNER JOIN PRODUCT P ON S.PRODUCT_ID = P.PRODUCT_ID GROUP BY S.PRODUCT_ID, P.PRODUCT_NAME HAVING MIN(S.SALE_DATE)>= '2019-01-01' AND MAX(S.SALE_DATE) <= '2019-03-31' - MYSQL SELECT S.PRODUCT_ID , P.PRODUCT_NAME FROM SALES S LEFT OUTER JOIN PRODUCT P ON S.PRODUCT_ID = P.PRODUCT_ID GROUP BY S.PRODUCT_ID HAVING SUM(S.SALE_DATE BETWEEN '2019-01-01' AND '2019-03-31') = C...

원문링크 : SQL 문제 35 - Sales Analysis III LeetCode 1084