Practice Interview Questions
| Question | Status |
|---|---|
Assuming that the emails table contains information about the email addresses of new TikTok users and the texts table contains information about the text confirmation received by each user, write a SQL query that retrieves the IDs of the users who did not confirm on the first day of sign-up, but confirmed on the second day.
emails table:
| Column Name | Description |
|---|---|
| email_id | Unique identifier for each email record |
| user_id | Identifier for the sign-up user |
| signup_date | Time when the user signed up |
texts table:
| Column Name |
|---|
Assuming that the emails table contains information about the email addresses of new TikTok users and the texts table contains information about the text confirmation received by each user, write a SQL query that retrieves the IDs of the users who did not confirm on the first day of sign-up, but confirmed on the second day.
emails table:
| Column Name | Description |
|---|---|
| email_id | Unique identifier for each email record |
| user_id | Identifier for the sign-up user |
| signup_date | Time when the user signed up |
texts table:
| Column Name |
|---|
| Description |
|---|
| text_id | Identifier for each text record |
| email_id | Identifier of the email record |
| signup_action | Type of action taken by the user |
| action_date | Time the action was taken |
| user_id |
|---|
| 1322 |
| Description |
|---|
| text_id | Identifier for each text record |
| email_id | Identifier of the email record |
| signup_action | Type of action taken by the user |
| action_date | Time the action was taken |
| user_id |
|---|
| 1322 |