-
Notifications
You must be signed in to change notification settings - Fork 4
gROUP sOLD PRODUCT BY DATE #41
-
Beta Was this translation helpful? Give feedback.
All reactions
Answered by
iamAntimPal
Mar 22, 2025
select sell_date, count( DISTINCT product ) as num_sold ,
GROUP_CONCAT( DISTINCT product order by product ASC separator ',' ) as products
FROM Activities GROUP BY sell_date order by sell_date ASC;
Replies: 1 comment
-
select sell_date, count( DISTINCT product ) as num_sold ,
GROUP_CONCAT( DISTINCT product order by product ASC separator ',' ) as products
FROM Activities GROUP BY sell_date order by sell_date ASC;
Beta Was this translation helpful? Give feedback.
All reactions
-
❤️ 1
0 replies
Answer selected by
Antim-IWP
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment