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...

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