Question
Print the product name and actual price of products whose actual price is above the average actual price of all products. The actual price is
Print the product name and actual price of products whose actual price is above
the average actual price of all products.
The actual price is the price after the discount. Use the heading ACTUAL_PRICE for
the actual prices in the result.
Sort the result such that the product with the highest actual price appears
first. You MUST use SUBQUERY.
Use a subquery to get the average actual price of all products.
OUTPUT PRODUCT_NAME 1 Gibson SG 2 Gibson Les Paul 3 Tama 5-Piece Drum Set with Cymbals 679.9915 4 Fender Precision 559.993 ACTUAL_PRICE 1208.16 839.3
Step by Step Solution
3.38 Rating (142 Votes )
There are 3 Steps involved in it
Step: 1
In this query we first select the productname and actualprice co...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Using Microsoft Excel and Access 2016 for Accounting
Authors: Glenn Owen
5th edition
1337109048, 1337109045, 1337342149, 9781337342148 , 978-1337109048
