Practice Interview Questions
| Question | Status |
|---|---|
Write a query to retrieve the unique customer IDs that made over $140 purchase AND registered in the past 10 days - assuming it is December 31st, 2024.
customer_purchase table:
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for the customer. |
| purchase_date | Date of the purchase. |
| product_id | Unique identifier of the product. |
| unit_price | Price per unit of the product |
| units_purchased | Number of units bought |
table:
Write a query to retrieve the unique customer IDs that made over $140 purchase AND registered in the past 10 days - assuming it is December 31st, 2024.
customer_purchase table:
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for the customer. |
| purchase_date | Date of the purchase. |
| product_id | Unique identifier of the product. |
| unit_price | Price per unit of the product |
| units_purchased | Number of units bought |
table:
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for the customer. |
| registration_date | Date the customer registered on the platform |
| customer_id |
|---|
| 1435 |
| 413 |
| 410 |
| Column Name | Description |
|---|---|
| customer_id | Unique identifier for the customer. |
| registration_date | Date the customer registered on the platform |
| customer_id |
|---|
| 1435 |
| 413 |
| 410 |