produce a Product list (name, unit price) of the twenty most expensive products, in descending order...

Transcribed Image Text:

produce a Product list (name, unit price) of the twenty most expensive products, in descending order of price. Set product column name as "Twenty Most Expensive Products". Be sure to not display duplicates. Do not use a nested query, but just keywords to limit results. CODE Twenty Most Expensive Products Cte de Blaye Thringer Rostbratwurst Mshi Kobe Niku Sir Rodney's Marmalade Camarvon Tigers Radette Courdavault Manjimup Dried Apples Tarte au sucre Ipoh Coffee Rssle Sauerkraut Schoggi Schokolade Vegie-spread Northwoods Cranberry Sauce Alce Mutton Gnocchi di nonna Alice Queso Manchego La Pastora Gudbrandsdalsost Mozzarella di Giovanni Camembert Pierrot Wimmers gute Semmekindel UnitPrice 263.5000 123.7900 97.0000 81.0000 62.5000 55.0000 53.0000 49.3000 46.0000 45.6000 43.9000 43.9000 40.0000 39.0000 38.0000 38.0000 36.0000 34.8000 34.0000 33.2500 produce a Product list (name, unit price) of the twenty most expensive products, in descending order of price. Set product column name as "Twenty Most Expensive Products". Be sure to not display duplicates. Do not use a nested query, but just keywords to limit results. CODE Twenty Most Expensive Products Cte de Blaye Thringer Rostbratwurst Mshi Kobe Niku Sir Rodney's Marmalade Camarvon Tigers Radette Courdavault Manjimup Dried Apples Tarte au sucre Ipoh Coffee Rssle Sauerkraut Schoggi Schokolade Vegie-spread Northwoods Cranberry Sauce Alce Mutton Gnocchi di nonna Alice Queso Manchego La Pastora Gudbrandsdalsost Mozzarella di Giovanni Camembert Pierrot Wimmers gute Semmekindel UnitPrice 263.5000 123.7900 97.0000 81.0000 62.5000 55.0000 53.0000 49.3000 46.0000 45.6000 43.9000 43.9000 40.0000 39.0000 38.0000 38.0000 36.0000 34.8000 34.0000 33.2500

Answer rating: 100% (QA)

To obtain a product list of the twenty most expensive products in ... View the full answer