# 1543. Fix Product Name Format

<https://leetcode.com/problems/fix-product-name-format>

## Description

Table: `Sales`

```
+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| sale\_id      | int     |
| product\_name | varchar |
| sale\_date    | date    |
+--------------+---------+
sale\_id is the primary key for this table.
Each row of this table contains the product name and the date it was sold.
```

Since table Sales was filled manually in the year `2000`, `product_name` may contain leading and/or trailing white spaces, also they are case-insensitive.

Write an SQL query to report

* `product_name` in lowercase without leading or trailing white spaces.
* `sale_date` in the format `('YYYY-MM')`.
* `total` the number of times the product was sold in this month.

Return the result table ordered by `product_name` in **ascending order**. In case of a tie, order it by `sale_date` in **ascending order**.

The query result format is in the following example.

```
Sales
+---------+--------------+------------+
| sale\_id | product\_name | sale\_date  |
+---------+--------------+------------+
| 1       | LCPHONE      | 2000-01-16 |
| 2       | LCPhone      | 2000-01-17 |
| 3       | LcPhOnE      | 2000-02-18 |
| 4       | LCKeyCHAiN   | 2000-02-19 |
| 5       | LCKeyChain   | 2000-02-28 |
| 6       | Matryoshka   | 2000-03-31 |
+---------+--------------+------------+
Result table:
+--------------+-----------+-------+
| product\_name | sale\_date | total |
+--------------+-----------+-------+
| lckeychain   | 2000-02   | 2     |
| lcphone      | 2000-01   | 2     |
| lcphone      | 2000-02   | 1     |
| matryoshka   | 2000-03   | 1     |
+--------------+-----------+-------+
In January, 2 LcPhones were sold, please note that the product names are not case sensitive and may contain spaces.
In Februery, 2 LCKeychains and 1 LCPhone were sold.
In March, 1 matryoshka was sold.
```

## ac

```java
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://jaywin.gitbook.io/leetcode/solutions/1543-fix-product-name-format.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.