SQL Quest › SQL Interview Questions › Conditional Logic

Asset Tier Classification

EasyFreeQuerying BasicsConditional Logic

Categorize each bank into an asset_tier: 'Mega' if total_assets >= 1,000,000,000 (>$1T), 'Giant' if >= 100,000,000 (>$100B), 'Large' if >= 10,000,000 (>$10B), 'Mid' otherwise. Show name, state, total_assets, asset_tier. Order by total_assets descending. (FDIC reports in thousands.)

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

cert	name	city	state	zip	charter_class	established_date	total_assets	total_deposits	total_equity	office_count	bank_class
628	JPMorgan Chase Bank, National Association	Columbus	OH	43240	8	01/01/1824	3752662000	2697842000	335936000	5335	N
3510	Bank of America, National Association	Charlotte	NC	28202	13044	10/17/1904	2636823000	2101968000	246250000	3840	N
7213	Citibank, National Association	Sioux Falls	SD	57108	1461	06/16/1812	1836436000	1465300000	176530000	958	N

Expected output: Each bank labeled Mega / Giant / Large / Mid

Hint

CASE WHEN total_assets >= 1000000000 THEN 'Mega' WHEN total_assets >= 100000000 THEN 'Giant' WHEN total_assets >= 10000000 THEN 'Large' ELSE 'Mid' END

Concepts

SELECT CASE

Practise the topic: SQL practice questions · CASE WHEN practice

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.

Asset Tier Classification

Schema

Hint

Concepts

In these company practice sets

Related questions