Write a query to find the top 5 loans by balance within each geographical region.
Use the loans table. Exclude rows with a missing region or balance. Ties should be resolved by the smallest loan_id.
geographical_region, loan_id, and balance.geographical_region, then balance descending, then loan_id ascending.| Column | Type | Description |
|---|---|---|
| loan_idPK | INT | Unique loan identifier |
| geographical_region | VARCHAR(100) | Geographical region associated with the loan |
| balance | DECIMAL(14,2) | Outstanding loan balance |