Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
After you sent this category report to one of your stakeholder, they came back to you with another request.
They noticed that some categories have been targeted by scammers and we want to exclude all the ones that have over $10,000 in total sales or an average sale amount of over $1,000. Only return the category names that have not been targeted by scammers.
Hint: If you want to exclude the categories with total sales over 10,000 dollars or average sales over 1,000 dollars, it means you want to include categories with total sales less or equal to 10,000 AND with an average sales less or equal to 1,000.
If you don't recall, you'll be using shopify_sales table which has these columns:
| Column Name | Description |
|---|---|
| sale_id | Unique identifier for each sale |
| product_id | Identifier for the product sold |
| category_name |
| Name of the product category |
| quantity_sold | Number of units sold in the sale |
| sale_amount | Total amount of the sale |
| sale_date | Date of the sale |
| category_name |
|---|
| Electronics |
| Toy |
| Books |
After you sent this category report to one of your stakeholder, they came back to you with another request.
They noticed that some categories have been targeted by scammers and we want to exclude all the ones that have over $10,000 in total sales or an average sale amount of over $1,000. Only return the category names that have not been targeted by scammers.
Hint: If you want to exclude the categories with total sales over 10,000 dollars or average sales over 1,000 dollars, it means you want to include categories with total sales less or equal to 10,000 AND with an average sales less or equal to 1,000.
If you don't recall, you'll be using shopify_sales table which has these columns:
| Column Name | Description |
|---|---|
| sale_id | Unique identifier for each sale |
| product_id | Identifier for the product sold |
| category_name | Name of the product category |
| quantity_sold | Number of units sold in the sale |
| sale_amount | Total amount of the sale |
| sale_date | Date of the sale |
| category_name |
|---|
| Electronics |
| Toy |
| Books |