Leetcode Problem 1484. Group Sold Products By The Date

1484. Group Sold Products By The Date

Leetcode Solutions

Grouping and Aggregating Product Sales Data

Group the data by sell_date to collect all products sold on each date together.
Count the distinct number of products sold on each date to get num_sold.
Concatenate the distinct product names, sort them lexicographically, and separate them by commas to get products.
Order the final result by sell_date in ascending order to ensure the dates are from earliest to latest.

erDiagram
    Activities {
        date sell_date
        varchar product
    }

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Loading...

Suggested Answer

Answer

Full Screen

Copy Answer Code

Loading...