Practice SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Calculate the fraction of unique users who confirmed their signup relative to the total number of signups.
Include users with no texts in the denominator and treat them as unconfirmed.
Handle multiple text records per user by counting each user only once if they have at least one confirmation.

What This Tests

Using left joins to maintain the full population of signups while linking to activity logs.
Conditional aggregation to count distinct entities satisfying a specific condition.
Managing one-to-many relationships and ensuring correct cardinality in metrics.
Precision handling for decimal results and rounding requirements.

Common Patterns

Left Join

Aggregation

Deduplication

Accepted

11/49

Acceptance Rate22.4%

Test Cases

Input

-

Output

-

Expected

-