로딩
요청 처리 중입니다...

SQL 문제 23 - Daily Leads and Partners LeetCode 1693

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...

# DailyLeadsandPartners_LeetCode1693 # SQL # SQL_DailyLeadsandPartners # SQL_DailyLeadsandPartners_LeetCode1693 # SQL_LeetCode1693

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

등록된 다른 글

SQL 문제 13 - 중복 제거하기(프로그래머스)
SQL 문제 13 - 중복 제거하기(프로그래머스)
SQL 문제 26 - Placements(HackerRank)
SQL 문제 26 - Placements(HackerRank)
SQL 문제 35 - Sales Analysis III LeetCode 1084
SQL 문제 35 - Sales Analysis III LeetCode 1084
SQL 문제 36 - Reformat Department Table LeetCode 1179
SQL 문제 36 - Reformat Department Table LeetCode 1179
JAVA_Find the Difference_LeetCode 389
JAVA_Find the Difference_LeetCode 389
JAVA_Keyboard Row_LeetCode 500
JAVA_Keyboard Row_LeetCode 500