DataDrivenDataDriven
LearnPracticeInterviewDiscussDailyJobs

Proof of Presence

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

Domain
SQL
Difficulty
medium
Seniority
L4

Problem

The security team is measuring how reliably users complete two-factor authentication, counting only the pushes that were actually delivered. For each client platform, find the confirmation rate: the share of delivered pushes the user opened.

Summary

Two-factor sent. How many confirmed?

Practice This Problem

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

Related

  • All Practice Problems
  • Mock Interview Mode
  • SQL Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons