Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings

gROUP sOLD PRODUCT BY DATE #41

Answered by iamAntimPal
Antim-IWP asked this question in Q&A
gROUP sOLD PRODUCT BY DATE #41
@Antim-IWP Antim-IWP
Mar 21, 2025 · 1 comment
Answered by iamAntimPal Return to top
Discussion options

Antim-IWP
Mar 21, 2025
Collaborator

1484. Group Sold Products By The Date
You must be logged in to vote
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;

EXPLANATION

View full answer

Replies: 1 comment

Comment options

iamAntimPal
Mar 22, 2025
Maintainer 

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;

EXPLANATION
You must be logged in to vote
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
Category
🙏
Q&A
Labels
question Further information is requested
2 participants
@Antim-IWP @iamAntimPal
Morty Proxy This is a proxified and sanitized view of the page, visit original site.