ROW_NUMBER vs RANK vs DENSE_RANK

When values are tied:

• ROW_NUMBER: Assigns different numbers (arbitrary order for ties)
• RANK: Same rank for ties, then skips numbers
• DENSE_RANK: Same rank for ties, no gaps

Example (values: 100, 100, 80):

Function	Result
ROW_NUMBER	1, 2, 3
RANK	1, 1, 3
DENSE_RANK	1, 1, 2

Your Task

Show all three ranking methods for products by price:

• name, price
• row_num, rank_num, dense_rank_num

Order by price descending.