Xorthax is curious about how different product categories compare in total sales. Write a query to assign a rank to each category based on its total revenue, ensuring that tied categories receive the same rank and that no ranks are skipped.