Number all books from most to least expensive with ROW_NUMBER(). Columns: title, price, rn. Order by price descending.

Answer

SELECT title, price, ROW_NUMBER() OVER (ORDER BY price DESC) AS rn FROM books ORDER BY price DESC;