SQL 문제 23 - Daily Leads and Partners LeetCode 1693

SQL 문제 23 - Daily Leads and Partners LeetCode 1693 Daily Leads and Partners 풀이 -- ORACLE SELECT TO_CHAR(DATE_ID,'YYYY-MM-DD') AS DATE_ID , MAKE_NAME , COUNT(DISTINCT LEAD_ID) AS UNIQUE_LEADS , COUNT(DISTINCT PARTNER_ID) AS UNIQUE_PARTNERS FROM DAILYSALES GROUP BY DATE_ID, MAKE_NAME; -- MYSQL, MSSQL SELECT DATE_ID , MAKE_NAME , COUNT(DISTINCT LEAD_ID) AS UNIQUE_LEADS , COUNT(DISTINCT PARTNER_ID) AS UNIQUE_PARTNERS FROM DAILYSALES GROUP BY DATE_ID, MAKE_NAME; * 출처 Level up your coding skills and q...

원문링크 : SQL 문제 23 - Daily Leads and Partners LeetCode 1693