ilya_panov

Rank products by price from highest to lowest within each category using DENSE_RANK()

Assign a dense rank to products by price from highest to lowest, so tied prices share a rank and the

Rank products by their rating from highest to lowest using RANK()

Number each transaction within its user, ordered by transaction_date from earliest to latest

Assign a row number to each product ordered by price from highest to lowest

Show each product's name, category, price, and the highest price in its category

Show each product's name, category, price, and the average price within its category

Show each product's name, price, and the total price of all products combined

From products, return product_id, category, price, and COUNT(*) OVER (PARTITION BY category) as item

From products, return product_id, category, price, and the RANK within each category ordered by pric