1. 학습
  2. /
  3. 강의
  4. /
  5. Window Functions in Snowflake

Connected

연습 문제

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!

지침 1/2

undefined XP
    1
    2
  • Use a window function to break the records into 100 equally-sized buckets, based on charging_cost.
  • Order the final results by survey_group and charging_station_location and observe the output.