LeetCode 1484: Group Sold Products By The Date

Database

Problem Description

Explanation:

  • We can solve this problem using SQL queries.
  • We need to group the data by sell_date, then count the number of different products sold for each date, and concatenate the product names sorted lexicographically.
  • We can achieve this using GROUP BY, COUNT, and GROUP_CONCAT functions in SQL.

:

SQL:

Solutions

// This problem can be solved using SQL query
// Therefore, no Java solution is necessary

Loading editor...