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

Q-Write a SQL query to display product name and list price for products in category 2 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 ID.Hint: use the ANY clauseThe query returns 20 rows as following.PRODUCT_NAME LIST_PRICE-----------------------------------PNY VCQP6000-PB 5499.99PNY VCQM6000-24GB-PB 4139PNY VCQM6000-PB 3254.99ATI FirePro W90003192.97ATI FirePro S91503177.44AMD FirePro W91002998.89EVGA 12G-P4-3992-KR 2799.99AMD 100-5059892699.99PNY VCQK6000-PB 2290.79PNY VCQP5000-PB 2015.11HP C2J95AT 1999.89EVGA 12G-P4-1999-KR 1799.99PNY VCQM5000-PB 1759.99ATI FirePro S90501699AMD 100-50560621499.99PNY VCQK5200-PB 1449.98AMD FirePro S70001218.5ATI FirePro R5000999.99AMD 100-506061999.99PNY VCQK4200-PB 949.89Q-Find the category or categories contain the lowest price product, and display the corresponding category ID along with the maximum price (list price).This query return 1 row as following. CATEGORY_ID maximum price------------------------------58867.99

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!