selectcount(distinct customer_id)as rich_count

from Store

where amount>500;

| 3172|[Second Day Verification](https://leetcode.com/problems/second-day-verification/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_3172.sql)|| Easy|

| 2990|[Loan Types](https://leetcode.com/problems/loan-types/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_2990.sql)|| Easy|

| 2205|[The Number of Users That Are Eligible for Discount](https://leetcode.com/problems/the-number-of-users-that-are-eligible-for-discount/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_2205.sql)|| Easy|

| 2082|[The Number of Rich Customers](https://leetcode.com/problems/the-number-of-rich-customers/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_2082.sql)|| Easy|

| 1789|[Primary Department for Each Employee](https://leetcode.com/problems/primary-department-for-each-employee/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1789.sql)|| Easy|

| 1757|[Recyclable and Low Fat Products](https://leetcode.com/problems/recyclable-and-low-fat-products/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1757.sql)|| Easy|

| 1741|[Find Total Time Spent by Each Employee](https://leetcode.com/problems/find-total-time-spent-by-each-employee/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1741.sql)|| Easy|