Commitdbf1890

committed

add 1587

1 parente1100dc commitdbf1890Copy full SHA for dbf1890

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1082,6 +1082,7 @@ _If you like this project, please leave me a star._ ★`
`1082`	`1082`	`\|1633\|[Percentage of Users Attended a Contest](https://leetcode.com/problems/percentage-of-users-attended-a-contest/)\|[Solution](../master/database/_1633.sql)\|\| Easy\|`
`1083`	`1083`	`\|1623\|[All Valid Triplets That Can Represent a Country](https://leetcode.com/problems/all-valid-triplets-that-can-represent-a-country/)\|[Solution](../master/database/_1623.sql)\|\| Easy\|`
`1084`	`1084`	`\|1607\|[Sellers With No Sales](https://leetcode.com/problems/sellers-with-no-sales/)\|[Solution](../master/database/_1607.sql)\|\| Easy\|`
	`1085`	`+\|1587\|[Bank Account Summary II](https://leetcode.com/problems/bank-account-summary-ii/)\|[Solution](../master/database/_1587.sql)\|\| Easy\|`
`1085`	`1086`	`\|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\|`
`1086`	`1087`	`\|1543\|[Fix Product Name Format](https://leetcode.com/problems/fix-product-name-format/)\|[Solution](../master/database/_1543.sql)\|\| Easy\|`
`1087`	`1088`	`\|1517\|[Find Users With Valid E-Mails](https://leetcode.com/problems/find-users-with-valid-e-mails/)\|[Solution](../master/database/_1517.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`	`+selectu.name,sum(t.amount)as balancefrom Users ujoin Transactions tonu.account=t.accountgroup byu.accounthaving balance>10000;`

Comments

(0)