Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You are running an e-learning platform and have 2 main clients, Amazon and Microsoft. Each client has provided user data in separate tables, tracking details like user ID, name, age, level, email, and country.
Your task is to get the list from both tables of all user_id, name and email with a beginner level, so that you can send them new courses.
We will be using the amazon_users and microsoft_users tables that has the following columns:
| 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 |
| user_id | name | |
|---|---|---|
| 1 | Oliver Adams | oliveradams@microsoft.com |
| 3 | Harper Lee | harperlee@microsoft.com |
| 5 | Ava Smith | avasmith@microsoft.com |
| 6 | Emma Clark | emmaclark@example.com |
You are running an e-learning platform and have 2 main clients, Amazon and Microsoft. Each client has provided user data in separate tables, tracking details like user ID, name, age, level, email, and country.
Your task is to get the list from both tables of all user_id, name and email with a beginner level, so that you can send them new courses.
We will be using the amazon_users and microsoft_users tables that has the following columns:
| 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 |
| user_id | name | |
|---|---|---|
| 1 | Oliver Adams | oliveradams@microsoft.com |
| 3 | Harper Lee | harperlee@microsoft.com |
| 5 | Ava Smith | avasmith@microsoft.com |
| 6 | Emma Clark | emmaclark@example.com |