演習

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.

指示

100 XP

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.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}演習

指示

演習