Write a SQL query using window functions to rank data records within specific partitions at Rhombus Power.
