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.
Este exercicio faz parte do curso
Window Functions in Snowflake
Instruções do exercicio
- 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.
exercicio interativo prático
Tente este exercicio completando este código de exemplo.
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;