Practice Interview Questions
| Question | Status |
|---|---|
A Microsoft Azure Supercloud customer is a company which buys at least 1 product from a minimum of 3 different product categories. Write a query to report the company ID(s) that are Supercloud Users.
customer_contracts table:
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for each customer |
| product_id | Product ID purchased by the customer |
| amount | Value of the purchase. |
products table:
| Column Name |
|---|
A Microsoft Azure Supercloud customer is a company which buys at least 1 product from a minimum of 3 different product categories. Write a query to report the company ID(s) that are Supercloud Users.
customer_contracts table:
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for each customer |
| product_id | Product ID purchased by the customer |
| amount | Value of the purchase. |
products table:
| Column Name |
|---|
| product_id | Unique identifier for each product |
| product_category | The category of the product |
| product_name | The name of the product |
| customer_id |
|---|
| 3 |
| 12 |
| 1 |
| product_id | Unique identifier for each product |
| product_category | The category of the product |
| product_name | The name of the product |
| customer_id |
|---|
| 3 |
| 12 |
| 1 |