SQL Quest › SQL Interview Questions › Querying Basics

Texas Banks Above $5B

EasyFreeQuerying Basics

Filter the institutions table to Texas banks with total_assets above 5,000,000 (assets are reported in thousands of USD, so this is $5 billion). Show name, city, total_assets, total_deposits. Order by total_assets 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".

Schema

institutions

certnamecitystatezipcharter_classestablished_datetotal_assetstotal_depositstotal_equityoffice_countbank_class
628JPMorgan Chase Bank, National AssociationColumbusOH43240801/01/1824375266200026978420003359360005335N
3510Bank of America, National AssociationCharlotteNC282021304410/17/1904263682300021019680002462500003840N
7213Citibank, National AssociationSioux FallsSD57108146106/16/181218364360001465300000176530000958N

Expected output: Texas-headquartered banks above $5B in assets

Hint

WHERE state = 'TX' AND total_assets > 5000000 — and remember FDIC reports assets in thousands.

Concepts

SELECT WHERE ORDER BY

Practise the topic: SQL practice questions

In these company practice sets

JPMorgan

A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.

Related questions

Your First QueryEasy · FreePick Your ColumnsEasy · FreeFilter with WHEREEasy · FreeComparison OperatorsEasy · FreeMultiple Conditions (AND / OR)Easy · FreeThe IN OperatorEasy · Free

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