Question: Q - Write a SQL query to display product name and list price for products in category 2 which have the list price greater than
QWrite a SQL query to display product name and list price for products in category which have the list price greater than ANY highest list price in each category. Sort the output by top list prices first and then by the product IDHint: use the ANY clauseThe query returns rows as following.PRODUCTNAME LISTPRICEPNY VCQPPB PNY VCQMGBPB PNY VCQMPB ATI FirePro WATI FirePro SAMD FirePro WEVGA GPKR AMD PNY VCQKPB PNY VCQPPB HP CJAT EVGA GPKR PNY VCQMPB ATI FirePro SAMD PNY VCQKPB AMD FirePro SATI FirePro RAMD PNY VCQKPB QFind the category or categories contain the lowest price product, and display the corresponding category ID along with the maximum price list priceThis query return row as following. CATEGORYID maximum price
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
