Active Tokens on Target Date

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

The security team is auditing which owners held a live API token on November 1 of 2026. The status column is populated inconsistently by different services, so count a token as enabled only when its status reads exactly as the lowercase word 'active'; on top of that, a live token must have been issued before that date and not yet reached its expiration, with a missing expiration date treated as still valid. Return each qualifying owner once.

Summary

One specific day. Which tokens were still alive?

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.