Write a SELECT statement that uses the ranking functions to rank products by the total quantity sold. Return these columns: The product_name column from the Products table A column named total_quantity that shows the sum of the quantity for each product in the Order_Items table A column named rank that uses the RANK function to rank the total quantity in descending sequence A column named dense_rank that uses the DENSE_RANK function to rank the total quantity in descending sequence.

2 Administrators AdminID EmailAddress Password FirstName LastName OrderItems ItemID OrderID Productio ItemPrice DiscountAmount Quantity Addresses AddressID Customer Line! Orders Orderin CustomerID Order Date ShipAmount TexAmount ShipDate ShipAddressID Card Type Card Number CardExpires BillingAddress Line2 City State ZipCode Phone Disabled Products ProductID CategoryID Product Code Product Name Description ListPrice DiscountPercent Date Added 8 Categories CategoryID CategoryName Customers Customer Email Address Password First Name LastName ShippingAddressID BillingAddressID