Suppose you are given this query:
SELECT product_name, price, RANK() OVER ( ORDER BY price DESC ) AS price_rank FROM products WHERE price_rank BETWEEN 1 AND 10
What does this query represent?
Question 6 options:
It determines the top 10 products based on their ranks and assigns ranks to them.
It assigns ranks to products based on their prices in descending order and retrieves only the top 10 products based on their ranks.
It determines the top priced products.
It determines the ranking of top priced products.