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.
Latihan ini adalah bagian dari kursus
Window Functions in Snowflake
Petunjuk latihan
- Add to the
SELECTstatement to return thecharging_station_locationanduser_idfields. - Using a window function, assign a row number to each record and sort by
charging_cost.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
SELECT
-- Return the charging_station_location and user_id
___,
___,
charging_start_time,
charging_cost,
-- Assign a row number to each record, ordering by charging_cost
___() ___(___ ___ ___)
FROM ELECTRIC_VEHICLES.charging;