Answered

At Westonci.ca, we connect you with the answers you need, thanks to our active and informed community. Get immediate and reliable answers to your questions from a community of experienced experts on our platform. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly platform.

Write a SELECT statement that answers this question: Which products have a list price that’s greater than the average list price for all products? Write this using a subquery. Return the ProductName and ListPrice columns for each product. Sort the results by the ListPrice column in descending sequence.

Sagot :

yoodyannapolis

Answer:

Following are the query to the given question:

Explanation:

Query:

SELECT ProductName,listprice FROM Products  where  listprice > (SELECT AVG (p.listprice)  FROM productsp)  ORDER BY  listprice DESC;

Description:

In the above-given query, multiple select statements are used, in the first statement, it selects the column that is "ProductName and listprice" from the products table and uses where clause to check the listprice that is greater than another select statement.

In this, it calculates the average listprice of the table and converts a value into descending order.  

Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. We hope you found what you were looking for. Feel free to revisit us for more answers and updated information. Westonci.ca is committed to providing accurate answers. Come back soon for more trustworthy information.