Picking a survey group
Question
You work for a large hardware company (one that manufactures watches, computers, and phones) and you're trying to understand user sentiment towards the company's brand and the products. You decide to send out a survey to a random set of users across different products. Can you create a query that samples across the different product offerings? The output of your query should be user_id and group (e.g. the sampling group the user belongs to).
You have a table with all users and their registered devices. The schema of the table is below:
Table: user_devices
| Column Name | Data Type | Description |
|---|---|---|
| user_id | integer | id of the user |
| devices | array of strings | lists the devices (watch, computer, phone) |
| device_ids | array of integers | id of the devices used by the user |
| user_create_time | integer | epoch time of the user's account |
| total_spend | integer | lifetime spend of a user |
| country | string | user country |