SQL Quest › SQL Interview Questions › Date Functions

Pre-1900 Banks

EasyFreeQuerying BasicsDate Functions

Find banks established before 1900 — the legacy institutions. The established_date column is text in MM/DD/YYYY format. Extract the year and filter. Show name, state, established_date. Order by year ascending (oldest first), then by name alphabetically for ties.

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: Pre-1900 chartered US banks

Hint

SQLite: extract the year with SUBSTR(established_date, 7, 4) and CAST it to integer, then filter < 1900. Order by that year ascending, then name ascending — the grader checks order exactly.

Concepts

SELECT WHERE Date Functions ORDER BY

Practise the topic: SQL practice questions · Date function 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.

Pre-1900 Banks

Schema

Hint

Concepts

In these company practice sets

Related questions