Commit84e00e2

committed

add 1543

1 parent194b3d5 commit84e00e2Copy full SHA for 84e00e2

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1002,6 +1002,7 @@ _If you like this project, please leave me a star._ ★`
`1002`	`1002`
`1003`	`1003`	`\| # \| Title \| Solutions \| Video \| Difficulty \| Tag`
`1004`	`1004`	`\|-----\|----------------\|---------------\|---------------\|---------------\|-------------`
	`1005`	`+\|1543\|[Fix Product Name Format](https://leetcode.com/problems/fix-product-name-format/)\|[Solution](../master/database/_1543.sql)\|\| Easy\|`
`1005`	`1006`	`\|1517\|[Find Users With Valid E-Mails](https://leetcode.com/problems/find-users-with-valid-e-mails/)\|[Solution](../master/database/_1517.sql)\|\| Easy\|`
`1006`	`1007`	`\|1495\|[Friendly Movies Streamed Last Month](https://leetcode.com/problems/friendly-movies-streamed-last-month/)\|[Solution](../master/database/_1495.sql)\|\| Easy\|`
`1007`	`1008`	`\|1484\|[Group Sold Products By The Date](https://leetcode.com/problems/group-sold-products-by-the-date/)\|[Solution](../master/database/_1484.sql)\|\| Easy\|`

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,5 @@`
	`1`	`+--# Write your MySQL query statement below`
	`2`	`+selectlower(trim(product_name)) product_name, date_format(sale_date,"%Y-%m") sale_date,count(sale_id) total`
	`3`	`+from sales`
	`4`	`+group by1,2`
	`5`	`+order by1,2`

Comments

(0)