For each product, show its name, category_id, price, and its rank within its category based on price (most expensive = rank 1). Use RANK() so tied prices share the same rank. Sort by category_id, then rank.