Leetcode Problem 1543. Fix Product Name Format

1543. Fix Product Name Format

Leetcode Solutions

Grouping and Formatting Sales Data

Use LOWER() to convert product_name to lowercase.
Use TRIM() to remove leading and trailing whitespace from product_name.
Use DATE_FORMAT() to convert sale_date to the 'YYYY-MM' format.
Group the results by the cleaned product_name and formatted sale_date.
Use COUNT() to calculate the total number of sales for each group.
Order the final result by product_name and sale_date in ascending order.


erDiagram
    Sales {
        int sale_id PK
        varchar product_name
        date sale_date
    }

Nothing

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...