|
1
2
3
4
5
6
7
|
# Write your MySQL query statement below
select
sell_date, COUNT(DISTINCT product) num_sold,
group_concat(DISTINCT product) products
from Activities
group by sell_date
order by sell_date
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1407. Top Travellers (0) | 2022.03.31 |
|---|---|
| leetcode 1890. The Latest Login in 2020 (0) | 2022.03.30 |
| leetcode 1581. Customer Who Visited but Did Not Make Any Transactions (0) | 2022.03.30 |
| leetcode 1795. Rearrange Products Table (0) | 2022.03.30 |
| leetcode 1587. Bank Account Summary II (0) | 2022.03.30 |
댓글