1. Apprendre
    2. /
  2. Cours
    3. /
  3. Window Functions in Snowflake
Connected

Exercice

Was that a fast charge?

One of the unique experiences of owning an electric vehicle is charging. Depending on the location, time of day, and home-setup, the time is takes to charge an EV differs from owner-to-owner.

In this exercise, you'll evaluate the amount of time it takes for drivers to charge their EV's at specific charging stations using RANK.

Instructions 1/2

undefined XP
  • 1
    • Complete the query to rank records by the charging_duration of each charge, from quickest to slowest.
  • 2
    • This time, build a window function to rank the query results by the charging_duration from slowest to quickest.