You have a database named Sales that contains the tables as shown in the exhibit.

You need to create a query that returns a list of products from Sales.ProductCatalog. The solution
must meet the following requirements:
– UnitPrice must be returned in descending order.
– The query must use two-part names to reference the table.
– The query must use the RANK function to calculate the results.
– The query must return the ranking of rows in a column named PriceRank.
– The list must display the columns in the order that they are defined in
the table.
– PriceRank must appear last.
Part of the correct T-SQL statement has been provided in the answer area. Provide the complete
code.

Answer: See the explanation

Explanation:
SELECT ProductCatalog.CatID, ProductCatalog.CatName,
ProductCatalog.ProductID, ProductCatalog.ProdName,
ProductCatalog.UnitPrice,
RANK() OVER (ORDER BY ProductCatalog.UnitPrice DESC) AS PriceRank
FROM Sales.ProductCatalog
ORDER BY ProductCatalog.UnitPrice DESC