coders.sh *

Loading Developers Heaven

The Vanishing Log

Mission brief

Challenge Briefing

Medium

Self-Joins
Date Functions
TIMESTAMP diffs

A user claims their data was deleted, but the audit_log shows no DELETE commands. Find the specific UPDATE that set a deleted_at flag exactly 3 seconds after a login.

Note: This environment runs SQLite, so use datetime(time, '+X seconds') for time adjustments.

The Vanishing Log

Find the specific UPDATE that set a deleted_at flag exactly 3 seconds after a login.

The Narrative

A user claims their data was deleted, but the audit_log shows no DELETE commands. Find the specific UPDATE that set a deleted_at flag exactly 3 seconds after a login.

Note: This environment runs SQLite, so use datetime(time, '+X seconds') for time adjustments.

Schema Diagram

audit_log

idINT

user_idINT

actionVARCHAR

timestampDATETIME

Challenge a Friend

One SQL table. One SQL condition.
Still tricky for most developers.

SQL Editor

Terminal Output

Initializing Database Engine v1.8.0...

Write a SQL query, then click Run Query

Keep practicing

Try another challenge

Similar difficulty and topics — pick up where you left off or stretch your SQL skills.

View all

Title	Complexity	Status	Solve
The Skimming Intern	Medium	Not solved	Solve
Git Blame Detective	Medium	Not solved	Solve
The Slow Query Hunt	Medium	Not solved	Solve