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.
Den här övningen är en del av kursen
Window Functions in Snowflake
Övningsinstruktioner
- 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.
Interaktiv övning med praktiskt arbete
Testa den här övningen genom att slutföra den här exempelkoden.
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;