`no such table`What is "no such table"?

SQLite stops with "no such table" when a query names a table the database does not have. Usually a typo, a missing s, or a table never created.

SQL5 min

What SQLite is telling you

Output

no such table: song

SQLite looked for a table called song and the database has nothing by that name. It checks every table name before it runs anything, so not a single row comes back.

The usual reasons:

Singular or plural. The table is songs, you wrote song. Most databases name tables in the plural, but not all.
A typo or a different word. player for players, user for users, order for orders.
The table was never made. A CREATE TABLE that failed, or one that runs further down the script.

How to find it

The message names the table it could not find, after the colon. Compare it letter by letter with the real names. To see the real names, run SELECT name FROM sqlite_master WHERE type = 'table'; or look at the tables listed above the editor. If you created the table yourself, check that its CREATE TABLE ran before the query, with no error of its own.

Run it: one letter short

Press Run and read the error from the bottom up.

Tables artists, songs, listeners, plays

artists 8 rows, 4 columns

id	name	country	genre
1	Nova Lane	UK	pop
2	The Tidewater	US	indie
3	Kaito Mori	JP	electronic
4	Amara Osei	GH	afrobeats
5	Lumen Choir	SE	pop
6	Rust & Velvet	UK	rock
7	Pixel Hearts	KR	pop
8	Juno Bay	AU	indie

songs 30 rows, 5 columns

id	title	artist_id	seconds	year
1	Neon Rain	6	178	2022
2	Slow Motion	1	158	2025
3	Paper Planes	2	233	2023
4	Static	1	269	2020
5	Golden Hour	1	162	2022
6	Night Bus	7	157	2020
7	Echoes	2	281	2022
8	Sugar Rush	1	284	2019
9	Low Tide	4	289	2019
10	Glass House	7	152	2020
11	Satellite	1	282	2025
12	Wildfire	3	214	2022

First 12 of 30 rows. Query the table to see the rest.

listeners 10 rows, 4 columns

id	username	age	country
1	maya_k	15	UK
2	devraj	17	IN
3	lucia.p	16	ES
4	tom_h	14	UK
5	ana.s	18	BR
6	kenji	16	JP
7	zoe_r	15	US
8	femi	17	NG
9	liv	13	SE
10	oscar.b	16	NULL

plays 70 rows, 5 columns

id	listener_id	song_id	day	skipped
1	10	16	2026-09-01	0
2	8	3	2026-09-01	0
3	5	16	2026-09-01	0
4	2	2	2026-09-01	0
5	5	21	2026-09-01	0
6	5	23	2026-09-02	0
7	6	1	2026-09-02	0
8	6	6	2026-09-02	0
9	8	2	2026-09-02	1
10	5	5	2026-09-02	0
11	7	13	2026-09-02	0
12	2	6	2026-09-03	0

First 12 of 70 rows. Query the table to see the rest.

query.sql to run

SELECT title, year
FROM song
WHERE year >= 2023;

The listener list that will not load

This should list the username and age of every listener from the UK. It stops with "no such table". Fix it.

exercise_1.sql to run

SELECT username, age
FROM listener
WHERE country = 'UK';

Code editor. Press Control or Command plus Enter to run the code. Tab indents; to move focus out of the editor, press Escape and then Tab.