Practice Interview Questions
| Question | Status |
|---|---|
Calculate the total number of orders each week, considering only those received during the first quarter of 2023.
orders_analysis table:
| Column Name | Description |
|---|---|
| stage_of_order | Stage of the order |
| week | Date of the week |
| quantity | Quantity of orders |
Example output:
| week | quantity |
|---|---|
| 2023-01-02T00:00:00.000 |
Calculate the total number of orders each week, considering only those received during the first quarter of 2023.
orders_analysis table:
| Column Name | Description |
|---|---|
| stage_of_order | Stage of the order |
| week | Date of the week |
| quantity | Quantity of orders |
Example output:
| week | quantity |
|---|---|
| 2023-01-02T00:00:00.000 |
| 102 |
| 2023-01-02T00:00:00.000 | 100 |
| 2023-01-02T00:00:00.000 | 101 |
| 2023-01-09T00:00:00.000 | 104 |
| 102 |
| 2023-01-02T00:00:00.000 | 100 |
| 2023-01-02T00:00:00.000 | 101 |
| 2023-01-09T00:00:00.000 | 104 |