Keys That Never Die

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The security team is auditing API token hygiene. A token with no expiration date (expires IS NULL) lives forever and is a standing risk. What percentage of all API tokens are these never-expiring tokens? Return a single number rounded to 2 decimal places as perpetual_pct.

Summary

Some API keys have no expiry date at all. That should worry someone.

Practice This Problem

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