Practice Interview Questions
| Question | Status |
|---|---|
Imagine you're a Data Analyst at Airbnb. The product manager wants you to figure out if a guest's gender affects the average review score they give. You'll use the "from_type" column to identify guest reviews. "from_user" is the user_id that made the review and "to_user" is the user_id that received the review.
Your job is to show which gender tends to give higher review scores. The end result will be a clear list of genders and their average review scores. Round your results to 3 decimal points.
reviews table:
| Column Name | Description |
|---|---|
| from_user | User ID who made the review |
| to_user | User ID who received the review |
| from_type | Type of user who made the review |
| to_type | Type of user who received the review |
| review_score | Score given in the review. |
guests table:
| Column Name | Description |
|---|---|
| guest_id | Unique identifier for the guest |
| nationality | Nationality of the guest |
| gender | Gender of the guest |
| age | Age of the guest |
| gender | avg_score |
|---|---|
| F | 4.532 |
Imagine you're a Data Analyst at Airbnb. The product manager wants you to figure out if a guest's gender affects the average review score they give. You'll use the "from_type" column to identify guest reviews. "from_user" is the user_id that made the review and "to_user" is the user_id that received the review.
Your job is to show which gender tends to give higher review scores. The end result will be a clear list of genders and their average review scores. Round your results to 3 decimal points.
reviews table:
| Column Name | Description |
|---|---|
| from_user | User ID who made the review |
| to_user | User ID who received the review |
| from_type | Type of user who made the review |
| to_type | Type of user who received the review |
| review_score | Score given in the review. |
guests table:
| Column Name | Description |
|---|---|
| guest_id | Unique identifier for the guest |
| nationality | Nationality of the guest |
| gender | Gender of the guest |
| age | Age of the guest |
| gender | avg_score |
|---|---|
| F | 4.532 |