Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Using the same table as in the previous practice, amazon_users and microsoft_users. The team wants to know how many users we have for each level across these 2 companies.
Hint: If a user is present in both tables, we only want to account it once, not twice.
If you forget, here is the columns of the tables you will be using:
| Column Name | Description |
|---|---|
| user_id | Unique identifier for each user |
| name | Name of the user |
| age | Age of the user |
| level | User's proficiency level (e.g., beginner) |
| Email address of the user |
| country | Country where the user is located |
| level | nb_users |
|---|---|
| advanced | 12 |
| intermediate | 9 |
| beginner | 15 |
Using the same table as in the previous practice, amazon_users and microsoft_users. The team wants to know how many users we have for each level across these 2 companies.
Hint: If a user is present in both tables, we only want to account it once, not twice.
If you forget, here is the columns of the tables you will be using:
| Column Name | Description |
|---|---|
| user_id | Unique identifier for each user |
| name | Name of the user |
| age | Age of the user |
| level | User's proficiency level (e.g., beginner) |
| Email address of the user | |
| country | Country where the user is located |
| level | nb_users |
|---|---|
| advanced | 12 |
| intermediate | 9 |
| beginner | 15 |