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 needs to identify which token owners had a live API token on November 1, 2026. A token is considered live on that date if its status is 'active', it was issued before that date, and it had not yet expired. Tokens with no expiration date should be treated as still valid. Return a deduplicated list of owner IDs.

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.