1. 学习
    2. /
  2. 课程
    3. /
  3. Window Functions in Snowflake
Connected

练习

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.

说明 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.