Practice Interview Questions
| Question | Status |
|---|---|
Write a SQL query to calculate the average number of items per order on Alibaba's platform. The result should be rounded to 1 decimal place.
items_per_order table:
| Column Name | Description |
|---|---|
| item_count | Number of items in an order |
| order_occurrences | Frequency of orders with this count |
| mean |
|---|
| 3.8 |
Write a SQL query to calculate the average number of items per order on Alibaba's platform. The result should be rounded to 1 decimal place.
items_per_order table:
| Column Name | Description |
|---|---|
| item_count | Number of items in an order |
| order_occurrences | Frequency of orders with this count |
| mean |
|---|
| 3.8 |