I am using SQL. I don't know how to do subqueries yet. Please use the simplest subquery with explanation. Thank you so much.

(Use the "my guitar shop" database to answer this question.) 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?" (Your query should include a way to calculate that average each time the query is run, so that if the data in the database changes, it will still generate an accurate result set at the time of running the query. A good way of doing that is using a subquery.) Return the product name and list price columns for each product. Sort the results by the list price column in descending sequence. This is the result set you should get: Result Grid l ETE Filter Rows product name list price 2517.00 Gibson SG Gibson Les Paul 1199.00 (2 rows