ÎncepețiÎncepe gratuit

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.

Acest exercițiu face parte din cursul

Window Functions in Snowflake

Vezi cursul

Instrucțiuni pentru exercițiu

  • In the SELECT statement, retrieve the fields storing vehicle_model and battery_capacity from the ELECTRIC_VEHICLES.charging table.
  • Use a window function to return a ranking without gaps.
  • Determine the ranking by battery_capacity, from greatest to least.

Exercițiu interactiv practic

Încearcă acest exercițiu completând acest cod de exemplu.

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;
Editează și rulează codul