Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Using the sales table, your goal is to display for each country, the list of unique product name sold, separated by a comma and space.
Hint: Ensure that each product name appears only once in the list for each country, even if it was sold multiple times.
sales table:
| Column Name | Description |
|---|---|
| sale_id | Identifier for each sale |
| product_name | Name of the product sold |
| country | Country the product was sold |
Using the sales table, your goal is to display for each country, the list of unique product name sold, separated by a comma and space.
Hint: Ensure that each product name appears only once in the list for each country, even if it was sold multiple times.
sales table:
| Column Name | Description |
|---|---|
| sale_id | Identifier for each sale |
| product_name | Name of the product sold |
| country | Country the product was sold |
| product_list |
|---|
| US | Banana, Watermelon, Apple |
| Canada | Mango, Cherry, Peach |
| Mexico | Cherry, Orange, Kiwi |
| product_list |
|---|
| US | Banana, Watermelon, Apple |
| Canada | Mango, Cherry, Peach |
| Mexico | Cherry, Orange, Kiwi |