SQL Quest › SQL Interview Questions › NULL Handling
Failures with No Loss Estimate
FDIC sometimes records a bank failure without an immediate estimated_loss figure (loss accounting closes later, or the failure resulted in zero loss to the deposit insurance fund). List the failures with NULL estimated_loss. Show name, city, state, failure_date. Order by failure_date descending.
Solve it in the browser editor →
Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect". Free accounts get 10 free challenge solves, and this can be one of them.
Schema
failures
| cert | name | city | state | failure_date | pre_failure_assets | pre_failure_deposits | resolution_type | estimated_loss |
|---|---|---|---|---|---|---|---|---|
| 57488 | METROPOLITAN CAPITAL B&T | CHICAGO | NULL | 1/30/2026 | 261185 | 212152 | FAILURE | NULL |
| 5520 | SANTA ANNA NATIONAL BANK | SANTA ANNA | NULL | 6/27/2025 | 76938 | 71376 | FAILURE | 23460 |
| 28611 | PULASKI SAVINGS BANK | CHICAGO | NULL | 1/17/2025 | 49466 | 42741 | FAILURE | 30284 |
Expected output: Bank failures pending loss accounting
Hint
Concepts
SELECT WHERE IS NULL NULL Handling
Practise the topic: SQL practice questions · NULL handling practice
Read the concept: IS NULL vs = NULL
In these company practice sets
A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.
Related questions
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test