Commitc7ff64d

committed

add 1667

1 parent404bd0e commitc7ff64dCopy full SHA for c7ff64d

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1076,6 +1076,7 @@ _If you like this project, please leave me a star._ ★`
`1076`	`1076`	`\|1693\|[Daily Leads and Partners](https://leetcode.com/problems/daily-leads-and-partners/)\|[Solution](../master/database/_1693.sql)\|\| Easy\|`
`1077`	`1077`	`\|1683\|[Invalid Tweets](https://leetcode.com/problems/invalid-tweets/)\|[Solution](../master/database/_1683.sql)\|\| Easy\|`
`1078`	`1078`	`\|1677\|[Product's Worth Over Invoices](https://leetcode.com/problems/products-worth-over-invoices/)\|[Solution](../master/database/_1677.sql)\|\| Easy\|`
	`1079`	`+\|1667\|[Fix Names in a Table](https://leetcode.com/problems/fix-names-in-a-table/)\|[Solution](../master/database/_1667.sql)\|\| Easy\|`
`1079`	`1080`	`\|1607\|[Sellers With No Sales](https://leetcode.com/problems/sellers-with-no-sales/)\|[Solution](../master/database/_1607.sql)\|\| Easy\|`
`1080`	`1081`	`\|1581\|[Customer Who Visited but Did Not Make Any Transactions](https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/)\|[Solution](../master/database/_1581.sql)\|\| Easy\|`
`1081`	`1082`	`\|1543\|[Fix Product Name Format](https://leetcode.com/problems/fix-product-name-format/)\|[Solution](../master/database/_1543.sql)\|\| Easy\|`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+--# Write your MySQL query statement below`
	`2`	`+select user_id, concat(UCASE(LEFT(name,1)), LCASE(SUBSTRING(name,2)))as namefrom Usersorder by user_id;`

Comments

(0)