Answered

Get the answers you need from a community of experts on IDNLearn.com. Join our Q&A platform to access reliable and detailed answers from experts in various fields.

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 :

Yoodyannapolisidn

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.  

Your participation means a lot to us. Keep sharing information and solutions. This community grows thanks to the amazing contributions from members like you. Thank you for choosing IDNLearn.com. We’re committed to providing accurate answers, so visit us again soon.