Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You are analyzing product review data for Apple's online store and will be using the product_reviews table:
| Column Name | Description |
|---|---|
| review_id | A unique identifier for each review. |
| product_name | The name of the product being reviewed. |
| customer_rating | The rating given by the customer, from 1 (worst) to 5 (best). |
Write a SQL query to category the number of reviews into 3 buckets:
You are analyzing product review data for Apple's online store and will be using the product_reviews table:
| Column Name | Description |
|---|---|
| review_id | A unique identifier for each review. |
| product_name | The name of the product being reviewed. |
| customer_rating | The rating given by the customer, from 1 (worst) to 5 (best). |
Write a SQL query to category the number of reviews into 3 buckets:
| review_category |
|---|
| nb_reviews |
|---|
| Poor | 4 |
| Average | 13 |
| Excellent | 10 |
| review_category |
|---|
| nb_reviews |
|---|
| Poor | 4 |
| Average | 13 |
| Excellent | 10 |