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

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

Security wants the tenure profile of every API token still in service. A token is in service if it has no expiration date or its expiration is today or later. Across that population, report how many days separate the oldest and newest tokens, how many tokens were issued on that earliest day, and how many were issued on that latest day.

Summary

Tenure extremes among active tokens.

Practice This Problem

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