Content-Length: 286466 | pFad | http://github.com/iamAntimPal/LeetCode_SQL_Database/discussions/41

11 gROUP sOLD PRODUCT BY DATE · iamAntimPal LeetCode_SQL_Database · Discussion #41 · GitHub
Skip to content

gROUP sOLD PRODUCT BY DATE #41

Answered by iamAntimPal
Antim-IWP asked this question in Q&A
Discussion options

You must be logged in to vote
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

Replies: 1 comment

Comment options

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








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/iamAntimPal/LeetCode_SQL_Database/discussions/41

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy