Marketing the right vehicles
Your marketing team is interested in identifying the vehicles with greatest battery capacity. This will allow for them to work with car manufacturers to market these vehicles at various charging stations. Your job is to create a ranking for these vehicles, based on the battery capacity of each vehicle.
This exercise is part of the course
Window Functions in Snowflake
Exercise instructions
- In the
SELECTstatement, retrieve the fields storingvehicle_modelandbattery_capacityfrom theELECTRIC_VEHICLES.chargingtable. - Use a window function to return a ranking without gaps.
- Determine the ranking by
battery_capacity, from greatest to least.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
-- Return the vehicle model and battery capacity
___,
___,
-- Use a window function to return a ranking without gaps
___() OVER(
-- Battery capacity from greatest to least
___
) AS battery_capacity_rank
FROM ELECTRIC_VEHICLES.charging;