Can someone provide the answer with reference to SQL queries?
Question: Write a SELECT statement that answers this problem:
Which products have a list price that's greater than the average list price for all products?
Return the ProductName and ListPrice columns for each product.
Sort the results by the ListPrice column in descending sequence.
Please show all your work and give an explanation of steps