coders.sh *

Loading Developers Heaven

The Ghost Feature

Mission brief

Challenge Briefing

Medium

Date Filtering
EXCEPT
BETWEEN

A feature was toggled on from "2023-11-01" to "2023-11-03". Find user_ids who logged in during that window, but haven't logged in any time after "2023-11-03".

The Ghost Feature

Find users active during a feature window who haven't logged in since.

The Narrative

A feature was toggled on from "2023-11-01" to "2023-11-03". Find user_ids who logged in during that window, but haven't logged in any time after "2023-11-03".

Schema Diagram

logins

user_idINT

login_dateDATE

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