Practice Interview Questions
| Question | Status |
|---|---|
Using the customer_purchase table, your goal is to list all customers that made at least 2 purchases in any period of six months.
customer_purchase table:
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for each customer |
| purchased_at | Time of when the purchase was made |
| customer_id |
|---|
| 11 |
| 29 |
Using the customer_purchase table, your goal is to list all customers that made at least 2 purchases in any period of six months.
customer_purchase table:
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for each customer |
| purchased_at | Time of when the purchase was made |
| customer_id |
|---|
| 11 |
| 29 |