Project 27: To-Do Transaction Batch
SQL Architect
Query Task
Objective
Review day: a full transaction combining INSERT, UPDATE, and DELETE — days 14, 15, 16, and 18 — committed together as one unit.
You're given a tasks table with columns id (auto-generated), title, and is_done.
Task: inside a transaction — add a new task 'Ship the release notes' (not done), mark 'Write onboarding docs' as done, delete any done task titled 'Old draft', then commit.
query.sql
BEGIN;
INSERT INTO tasks (title, is_done) VALUES ('Ship the release notes', false);
UPDATE tasks SET is_done = true WHERE title = 'Write onboarding docs';
DELETE FROM tasks WHERE is_done = true AND title = 'Old draft';
COMMIT;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results