CommencerCommencez gratuitement

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.

Cet exercice fait partie du cours

<cours>Window Functions in Snowflake</cours>
Voir le cours

Instructions de l’exercice

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

Exercice interactif pratique

Essayez cet exercice en complétant ce code d’exemple.

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;
Modifier et exécuter le code