Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
As part of the YouTube analytics team, you're analyzing the new Live Streaming Feature, where viewers can send gifts to their favorite creators. Your task is to identify the two regions globally where users are least likely to send gifts during live streams. This information will help YouTube strategize and boost feature adoption in these regions.
Write a SQL query to find the two regions with the lowest percentage of users sending gifts.
To answer this question from the team, you will have access to 2 tables:
users table:
| Column Name | Description |
|---|---|
| user_id | Unique identifier for each user |
| name | The user's full name |
| country | The user's country of residence |
| region | The specific region within the country where the user resides |
| gender | The user's gender |
user_session table:
| Column Name | Description |
|---|---|
| session_id | Unique identifier for each user session |
| user_id | Identifier for the user associated with the session |
| session_start_at | The date and time when the user session started |
| session_end_at | The date and time when the user session ended |
| nb_sent_gifts | Number of gifts sent by the user to creators during the session |
| region | ratio |
|---|---|
| North America | 0.02882.. |
| Asia | 0.125... |
As part of the YouTube analytics team, you're analyzing the new Live Streaming Feature, where viewers can send gifts to their favorite creators. Your task is to identify the two regions globally where users are least likely to send gifts during live streams. This information will help YouTube strategize and boost feature adoption in these regions.
Write a SQL query to find the two regions with the lowest percentage of users sending gifts.
To answer this question from the team, you will have access to 2 tables:
users table:
| Column Name | Description |
|---|---|
| user_id | Unique identifier for each user |
| name | The user's full name |
| country | The user's country of residence |
| region | The specific region within the country where the user resides |
| gender | The user's gender |
user_session table:
| Column Name | Description |
|---|---|
| session_id | Unique identifier for each user session |
| user_id | Identifier for the user associated with the session |
| session_start_at | The date and time when the user session started |
| session_end_at | The date and time when the user session ended |
| nb_sent_gifts | Number of gifts sent by the user to creators during the session |
| region | ratio |
|---|---|
| North America | 0.02882.. |
| Asia | 0.125... |