Rank function example

Overview of SQL RANK functions

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