Practice Interview Questions
| Question | Status |
|---|---|
Write a SQL query to calculate the % of high-frequency customers for January 2023. A high-frequency customer is defined as someone who places more than 5 orders in a month. Your output should only include the % of these high-frequency customers.
Round your results to 2 decimal points.
delivery_order table:
| Column Name | Description |
|---|---|
| restaurant_id | Identifier of the restaurant |
| delivery_id | Unique identifier for each delivery |
| customer_id | ID of the customer placing the order |
| order_timestamp | Time the order was placed |
| ratio |
|---|
| 0.24 |
Write a SQL query to calculate the % of high-frequency customers for January 2023. A high-frequency customer is defined as someone who places more than 5 orders in a month. Your output should only include the % of these high-frequency customers.
Round your results to 2 decimal points.
delivery_order table:
| Column Name | Description |
|---|---|
| restaurant_id | Identifier of the restaurant |
| delivery_id | Unique identifier for each delivery |
| customer_id | ID of the customer placing the order |
| order_timestamp | Time the order was placed |
| ratio |
|---|
| 0.24 |