Practice Interview Questions
| Question | Status |
|---|---|
Write a query that returns the name of brands that have at least two different products and its average price is greater than $300. Return the result order by brand name.
products table:
| Column Name | Description |
|---|---|
| product_id | Unique identifier for each product |
| product_class_id | Identifier for the class/category |
| brand_name | Name of the brand of the product |
| product_name | Name of the product |
| price | Price of the product |
Write a query that returns the name of brands that have at least two different products and its average price is greater than $300. Return the result order by brand name.
products table:
| Column Name | Description |
|---|---|
| product_id | Unique identifier for each product |
| product_class_id | Identifier for the class/category |
| brand_name | Name of the brand of the product |
| product_name | Name of the product |
| price | Price of the product |
| brand_name |
|---|
| Apple |
| Dell |
| HP |
| brand_name |
|---|
| Apple |
| Dell |
| HP |