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.
Questo esercizio fa parte del corso
Window Functions in Snowflake
Istruzioni dell'esercizio
- 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.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
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;