Exercise

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!

Instructions 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.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions 1/2

Exercise