Practice Interview Questions
| Question | Status |
|---|---|
As a new analyst at Tiktok, you are provided with 2 tables. The first table, named emails, contains records of user email signups. The second table, texts, contains information about the text confirmation received by each user.
Your goal is to calculate the email confirmation rate. This rate is defined as the % of emails who have been confirmed. Round your result to 2 decimal points.
emails table:
| Column Name | Description |
|---|---|
| email_id | Identifier for the email record |
| user_id | Identifier for the sign-up user |
| signup_date | Time the user signup |
texts table:
| Description |
|---|
| text_id | Identifier for each text received |
| email_id | Identifier for the email |
| signup_action | Status of the email signup |
| activation_rate |
|---|
| 0.43 |
As a new analyst at Tiktok, you are provided with 2 tables. The first table, named emails, contains records of user email signups. The second table, texts, contains information about the text confirmation received by each user.
Your goal is to calculate the email confirmation rate. This rate is defined as the % of emails who have been confirmed. Round your result to 2 decimal points.
emails table:
| Column Name | Description |
|---|---|
| email_id | Identifier for the email record |
| user_id | Identifier for the sign-up user |
| signup_date | Time the user signup |
texts table:
| Column Name | Description |
|---|---|
| text_id | Identifier for each text received |
| email_id | Identifier for the email |
| signup_action | Status of the email signup |
| activation_rate |
|---|
| 0.43 |