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

junior, mid

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.

Practice This Problem

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