Project 15: Contact Message Resolver
SQL Architect
Builds on these lessons
Query Task
Objective
UPDATE changes existing rows. Its WHERE clause matters just as much as SELECT's — an UPDATE with no WHERE at all changes every single row in the table.
You're given a contact_messages table with columns id, message, and is_resolved.
Task: mark the message with id of 12 as resolved (is_resolved = true).
query.sql
UPDATE contact_messages SET is_resolved = true WHERE id = 12;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results