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.
Deze oefening maakt deel uit van de cursus
Window Functions in Snowflake
Oefeninstructies
- 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.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
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;