How to create Native Derived Table with brand wise Rank() over order by Sum of Sale price.

[ratnadeep_burma]

Here I want to create rank column with help of Sum(sales) aggregation value in the same query. 

select brand, Sum(Sale_price), Rank() over(order by Sum(Sale_price))

from table1 group by 1 order by 2 desc

How we create native derive table.