Average balance by account type
GXBank wants to compare how much customers hold across account types.
From the accounts table, return each account_type and the average balance for that type as avg_balance.
Schema
▸accounts
| id | INT |
| account_type | TEXT |
| balance | NUMERIC(10,2) |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
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.
RM 25/mo · cancel anytime