|
1
2
3
4
5
6
7
8
|
/* Write your PL/SQL query statement below */
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
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1587. Bank Account Summary II (0) | 2022.03.30 |
|---|---|
| leetcode 1873. Calculate Special Bonus (0) | 2022.03.29 |
| leetcode 1741. Find Total Time Spent by Each Employee (0) | 2022.03.29 |
| leetcode 1757. Recyclable and Low Fat Products (0) | 2022.03.29 |
| hacker rank The Report (0) | 2022.03.29 |
댓글