Task Submission Split: Weekend vs Working Days

Medium

An operations analytics team tracks when tasks are submitted and needs a one-row activity split by day type. Table: Tasks task_id: unique task identifier assignee_id: user assigned to the task submit_date: calendar date when the task was submitted (YYYY-MM-DD) Classification rule: Weekend submissions are tasks created on Saturday or Sunday. Working-day submissions are tasks created on Monday through Friday. Task: Return exactly one row containing: weekend_cnt: total number of weekend submissions working_cnt: total number of working-day submissions Supported submission environments: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

Tasks:
| task_id | assignee_id | submit_date |
|---------|-------------|-------------|
| 1       | 10          | 2024-01-08  |
| 2       | 10          | 2024-01-09  |
| 3       | 20          | 2024-01-10  |
| 4       | 30          | 2024-01-13  |
| 5       | 40          | 2024-01-14  |
| 6       | 40          | 2024-01-14  |

Output

[
  {"weekend_cnt":3,"working_cnt":3}
]

Explanation

Three rows are on Saturday or Sunday (task_id 4, 5, 6), and three rows are on Monday through Wednesday (task_id 1, 2, 3).

Example 2

Input

Tasks:
| task_id | assignee_id | submit_date |
|---------|-------------|-------------|
| 11      | 7           | 2023-07-15  |
| 12      | 8           | 2023-07-16  |
| 13      | 9           | 2023-07-22  |

Output

[
  {"weekend_cnt":3,"working_cnt":0}
]

Explanation

All three rows fall on weekend dates.

Example 3

Input

Tasks:
[]

Output

[
  {"weekend_cnt":0,"working_cnt":0}
]

Explanation

With no rows, both counters are zero.

Constraints

0 <= number of rows in Tasks <= 1600
1 <= task_id <= 2000000000
1 <= assignee_id <= 1000000000
submit_date values use format YYYY-MM-DD
task_id values are unique
Weekend means Saturday or Sunday
Working day means Monday through Friday
Return exactly one row with columns weekend_cnt and working_cnt
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with exactly one row and columns weekend_cnt and working_cnt

Tasks: | task_id | assignee_id | submit_date | |---------|-------------|-------------| | 1 | 10 | 2024-01-08 | | 2 | 10 | 2024-01-09 | | 3 | 20 | 2024-01-10 | | 4 | 30 | 2024-01-13 | | 5 | 40 | 2024-01-14 | | 6 | 40 | 2024-01-14 |

Tasks: | task_id | assignee_id | submit_date | |---------|-------------|-------------| | 11 | 7 | 2023-07-15 | | 12 | 8 | 2023-07-16 | | 13 | 9 | 2023-07-22 |