ComeçarComece de graça

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 exercício faz parte do curso

Window Functions in Snowflake

Ver curso

Instruções do exercício

  • 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.

Exercício interativo prático

Experimente este exercício 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;
Editar e executar o código