> For the complete documentation index, see [llms.txt](https://jaywin.gitbook.io/leetcode/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jaywin.gitbook.io/leetcode/solutions/1543-fix-product-name-format.md).

# 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
```