mediumHSBC · subqueryGlobal · hiring in AsiaBasicNew
Accounts above their own branch's average
HSBC wants to find high-value accounts relative to their local branch, not the whole bank.
From the accounts table, return the customer_name and balance of every account whose balance is above the average balance of its own branch.
Schema
▸accounts
| id | INT |
| customer_name | TEXT |
| branch | TEXT |
| balance | NUMERIC |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.