1. 学ぶ
  2. /
  3. コース
  4. /
  5. Window Functions in Snowflake

Connected

演習

Comparing energy consumed

Being able to compare records to summary metrics is one of the most powerful use cases for window functions. In this exercise, you'll build two window functions to compare each record to the minimum and maximum energy consumed.

指示1 / 2

undefined XP
    1
    2
  • Create a column called least_energy_consumed to find the minimum energy consumed in a charging session.