1. Learn
  2. /
  3. Courses
  4. /
  5. Window Functions in Snowflake

Connected

Exercise

Follow the money!

Partitioning data in a window function is what makes these tools so unique! Now, you're being tasked with ranking charging sessions for each location based on the cost of the charge. This could help to identify which charging stations drive the most revenue and inform operational changes.

Instructions 1/2

undefined XP
    1
    2
  • Create a window function to generate a rank for each record in the result set, highest to lowest, based on the charging_cost.