1. Обучение
    2. /
  2. Курса
    3. /
  3. Window Functions in Snowflake
Connected

упражнение

Adding row numbers to charging sessions

Throughout the course, you'll build window functions using the charging table in the ELECTRIC_VEHICLES Snowflake schema. Each record in this table contains information about a "charging" session for an electric vehicle.

You'll start by using a window function to add a row number to each record.

Инструкции

100 XP
  • Add to the SELECT statement to return the charging_station_location and user_id fields.
  • Using a window function, assign a row number to each record and sort by charging_cost.
Powered by Snowflake