00:00:00

Description

Editorial

Count Customers with Any High-Value Bill

EASY10 pts

A billing analytics team wants a quick metric showing how many unique customers have ever produced a high-value bill.

Table: Store

bill_id: unique bill identifier
customer_id: identifier of the billed customer
amount: billed amount for that bill

Business rule:

A customer is considered rich if they have at least one bill where amount > 500.

Task: Return a single-row result with one column rich_count containing the number of rich customers.

Output requirements:

Return exactly one column: rich_count
Return exactly one row

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

Store:
| bill_id | customer_id | amount |
|---------|-------------|--------|
| 6       | 1           | 549    |
| 8       | 1           | 834    |
| 4       | 2           | 394    |
| 11      | 3           | 657    |
| 13      | 3           | 257    |

Output

[{"rich_count":2}]

Explanation

Customers 1 and 3 each have at least one bill above 500. Customer 2 does not.

Example

Input

Store:
| bill_id | customer_id | amount |
|---------|-------------|--------|
| 101     | 9           | 500    |
| 102     | 9           | 499    |
| 103     | 10          | 501    |
| 104     | 10          | 500    |
| 105     | 11          | 500    |

Output

[{"rich_count":1}]

Explanation

Only customer 10 qualifies because the threshold is strictly greater than 500.

Example

Input

Store:
[]

Output

[{"rich_count":0}]

Explanation

No bills means no customer can qualify as rich.

Accepted0/0·0% Acceptance

Constraints

0 <= number of rows in Store <= 900
1 <= bill_id <= 2000000000
1 <= customer_id <= 1000000000
0 <= amount <= 5000
bill_id values are unique
A rich customer is one with at least one row where amount > 500
Return exactly one output column named rich_count
Return exactly one output row
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with one row and one column rich_count

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

Store =

[{"bill_id":1,"customer_id":1,"amount":549},{"bill_id":2,"customer_id":1,"amount":834},{"bill_id":3,"customer_id":2,"amount":394},{"bill_id":4,"customer_id":3,"amount":657},{"bill_id":5,"customer_id":3,"amount":257}]

Loading problem...

101

00:00:00

Description

Editorial

Count Customers with Any High-Value Bill

EASY10 pts

A billing analytics team wants a quick metric showing how many unique customers have ever produced a high-value bill.

Table: Store

bill_id: unique bill identifier
customer_id: identifier of the billed customer
amount: billed amount for that bill

Business rule:

A customer is considered rich if they have at least one bill where amount > 500.

Task: Return a single-row result with one column rich_count containing the number of rich customers.

Output requirements:

Return exactly one column: rich_count
Return exactly one row

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

Store:
| bill_id | customer_id | amount |
|---------|-------------|--------|
| 6       | 1           | 549    |
| 8       | 1           | 834    |
| 4       | 2           | 394    |
| 11      | 3           | 657    |
| 13      | 3           | 257    |

Output

[{"rich_count":2}]

Explanation

Customers 1 and 3 each have at least one bill above 500. Customer 2 does not.

Example

Input

Store:
| bill_id | customer_id | amount |
|---------|-------------|--------|
| 101     | 9           | 500    |
| 102     | 9           | 499    |
| 103     | 10          | 501    |
| 104     | 10          | 500    |
| 105     | 11          | 500    |

Output

[{"rich_count":1}]

Explanation

Only customer 10 qualifies because the threshold is strictly greater than 500.

Example

Input

Store:
[]

Output

[{"rich_count":0}]

Explanation

No bills means no customer can qualify as rich.

Accepted0/0·0% Acceptance

Constraints

0 <= number of rows in Store <= 900
1 <= bill_id <= 2000000000
1 <= customer_id <= 1000000000
0 <= amount <= 5000
bill_id values are unique
A rich customer is one with at least one row where amount > 500
Return exactly one output column named rich_count
Return exactly one output row
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with one row and one column rich_count

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

Store =

Count Customers with Any High-Value Bill

Hints

Count Customers with Any High-Value Bill

Hints