Does it support inner query ?

I want to construct query like below
`SELECT
      inner_table.*,
      ROW_NUMBER() OVER (ORDER BY colum1 DESC) AS RN
    FROM (
           SELECT
             colum1
           FROM
             test
         ) inner_table `

Is it possible ?