Question

In SQL

Use AdventureWorksDW2014

List bikes that have a list price less than or equal than the average list
price for all bikes. Show

Answer 1

To list bikes with a list price less than or equal to the average list price from the AdventureWorksDW2014 database, a subquery is used to calculate the average and then filter the results.

Step-by-step explanation:

The AdventureWorksDW2014 database contains a variety of tables that can be used to run queries on product data, including information about bikes. To list the bikes that have a list price less than or equal to the average list price for all bikes, we can use a subquery in SQL to first calculate the average list price and then use it to filter the main query results.

Here's an example SQL query that accomplishes this task:

SELECT ProductName, ListPrice
FROM AdventureWorksDW2014.Products
WHERE Category = 'Bike'
AND ListPrice <= (
SELECT AVG(ListPrice)
FROM AdventureWorksDW2014.Products
WHERE Category = 'Bike'
);

This query selects the ProductName and ListPrice from the Products table, filtering the results to those bikes whose list price is less than or equal to the average list price of all bikes in the same category.