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.
This exercise is part of the course
Window Functions in Snowflake
Exercise instructions
- 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.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
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;