11. Write a SELECT statement that uses the ranking functions to rank products by thetotal quantity sold. Return these columns:The productname column from the Products tableA column named totalquantity that shows the sum of the quantity foreach product in the OrderItems tableA column named rank that uses the RANK function to rank the totalquantity in descending sequenceA column named denserank that uses the DENSERANK function torank the total quantity in descending sequence12. Write a SELECT stat

How to Use the RANK Function in Excel Formula Examples

RANK Function