SourCaPlacement OS

Targeted Campus Assessment Prep

Loading SourCa...

Synchronizing placement benchmarks & campus recruitment roadmaps

Practice Directory•

Confirmation Rate Calculationsql

Relational Database Schema

Confirmation Rate Calculation

The confirmation rate of a user is the number of 'confirmed' messages divided by the total number of requested confirmation messages. The confirmation rate of a user that did not request any confirmation messages is 0. Round the confirmation rate to two decimal places. Write an SQL query to find the confirmation rate of each user. ### Schema: `Signups` | Column Name | Type | | :--- | :--- | | user_id | int | | time_stamp | datetime | ### Schema: `Confirmations` | Column Name | Type | | :--- | :--- | | user_id | int | | time_stamp | datetime | | action | enum('confirmed', 'timeout') |

Tables & Sample Fixtures

Table: Signups

user_id (int)	time_stamp (datetime)
3	2020-03-21 10:16:13
7	2020-01-04 13:57:59
2	2020-07-29 23:09:44
6	2020-12-09 10:39:37

Table: Confirmations

user_id (int)	time_stamp (datetime)	action (varchar)
3	2021-01-06 03:30:46	timeout
3	2021-07-14 14:00:00	timeout
7	2021-06-12 11:57:29	confirmed
7	2021-06-13 12:58:28	confirmed
2	2021-01-22 00:00:00	confirmed

query.sql

Execution Output Result

Click 'Run & Verify Query' to test your SQL against the sample test fixture.