coders.sh *

Loading Developers Heaven

Zombie Accounts

Mission brief

Medium

We are charing people who haven't logged in for a year! Let's identify user IDs with an "active" subscription but a last login older than 2022-01-01.

Active subscriptions with no login for > 365 days.

We are charing people who haven't logged in for a year! Let's identify user IDs with an "active" subscription but a last login older than 2022-01-01.

users

idINT

last_loginDATETIME

subscriptions

user_idINT

statusVARCHAR

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

Initializing Database Engine v1.8.0...

Write a SQL query, then click Run Query

Keep practicing

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

Title	Complexity	Status	Solve
The Ghost of 2020	Easy	Not solved	Solve
The Skimming Intern	Medium	Not solved	Solve
Git Blame Detective	Medium	Not solved	Solve