select  Dat,
suma1,
rank() over( order by suma1 ),
suma2,
rank() over( order by suma2)
from
(
 Select
 sum(a.QUANTITY_SOLD) as suma1,
 sum(a.amount_sold) as suma2,
 to_char(a.time_id,'YYYY-MM') as Dat
 from SH.SALES a
 group by to_char(a.time_id,'YYYY-MM')
)