Top Active API Tokens

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

Surface the issuance dates of the 5 most-used tokens that have not yet expired. A token is unexpired if it has no expiration date or its expiration is still in the future. Rank by request volume descending. Show each token and its issuance date.

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.