Project 14: Newsletter Subscriber Insert
SQL Architect
Builds on these lessons
Query Task
Objective
INSERT INTO adds a new row. Name the columns you're supplying values for, in the same order as the VALUES list — any column you leave out gets its default (or NULL).
You're given a subscribers table with columns id (auto-generated), email, and subscribed_at.
Task: insert a new subscriber with email 'reader@example.com' and subscribed_at of '2026-08-21'.
query.sql
INSERT INTO subscribers (email, subscribed_at) VALUES ('reader@example.com', '2026-08-21');
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results