CommencerCommencer gratuitement

Surveying vehicle owners

Your market research team is interested in surveying vehicle owners to get a better understanding of their behavior. They'd like to be strategic about this and generate a well-represented sample. They'd like you to prepare 100 groups of vehicle owners, based on the amount each owner spent charging their vehicles. Give it a shot!

Cet exercice fait partie du cours

Window Functions in Snowflake

Afficher le cours

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

SELECT
    user_id,
    charging_station_location,
    charging_cost,
    
    -- Break records into 100 equally-sized buckets based on
    -- charging_cost
    ___(___) OVER(
      ORDER BY ___
    ) AS survey_group
    
FROM ELECTRIC_VEHICLES.charging

-- Order by survey_group and charging_station_location
ORDER BY ___, ___;
Modifier et exécuter le code