Signup Confirmation Rate

Unsolved

After signing up, users can request confirmation messages, each of which ends as 'confirmed' or 'timeout'. A user's confirmation rate is the number of confirmed messages divided by the number of messages they requested. Users who never requested a message have a rate of 0. Every signed-up user must appear. Write an SQL query that returns user_id and confirmation_rate rounded to 2 decimal places. Order the results by user_id ascending.

Learn the concept: INNER JOIN vs LEFT JOINCASE WHEN

SQL Query Editor (Ctrl+Enter to run)

0 characters · Valid

Canonical Solution Official

Official Solution is Hidden

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Community Q&A & Discussion

Ask questions, share alternate queries, and explore solutions

0 comments

Asked By:

Classic pattern · not tied to a specific company

Submission History

Your recent query executions and answer checks

Execution Pipeline:

FROM signups

Full source dataset

4 rows total

This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.

Signup Confirmation Rate

Official Solution is Hidden

Approach & Explanation

Community Q&A & Discussion

Submission History