Loading...
2FA Confirmation Rate
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Problem
The security team is measuring how reliably users complete two-factor authentication across different client platforms. Only notifications with a delivered status count as valid 2FA pushes; everything else is noise. A push is considered confirmed when the user opened it. For each platform, compute the confirmation rate as a ratio of confirmed pushes to total delivered pushes.
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.