Is Tasks Count in the Weekend easy or hard?

Tasks Count in the Weekend is generally considered a medium-level SQL problem. The logic is simple once you know how weekday extraction functions work, but it checks practical knowledge of SQL date handling and conditional filtering.

Tasks Count in the Weekend Python/Java solution

This problem is designed for SQL rather than Python or Java. The solution is typically written in MySQL using date functions like DAYOFWEEK() or WEEKDAY() combined with COUNT(*) to compute the total number of tasks submitted on weekend days.

How to solve Tasks Count in the Weekend in O(n)?

Perform a single scan of the Tasks table and apply a date function to determine the weekday. In MySQL, use DAYOFWEEK(submit_date) and filter for values 1 and 7 to represent Sunday and Saturday. After filtering, apply COUNT(*) to return the total number of weekend tasks.

What is the best approach for Tasks Count in the Weekend?

The best approach filters rows using a SQL weekday function such as DAYOFWEEK() or WEEKDAY() and counts the matching rows. In MySQL, DAYOFWEEK(date) returns 1 for Sunday and 7 for Saturday, so filtering those values directly identifies weekend tasks. The query performs a single table scan with O(n) time and constant space.

Is Tasks Count in the Weekend asked at Google/Amazon/Meta?

Problems like Tasks Count in the Weekend appear frequently in SQL interview rounds across companies such as Amazon, Google, and Meta. The focus is usually on understanding date functions, filtering conditions, and writing efficient aggregation queries on relational tables.

What data structure is used in Tasks Count in the Weekend?

The problem operates on a relational database table rather than traditional in-memory data structures. The main concept involves SQL date functions and filtering operations within a database query engine.

What is the time complexity of Tasks Count in the Weekend?

The time complexity is O(n) because the database must evaluate the weekday function for each row in the Tasks table. Aggregation with COUNT(*) happens during the same scan. Space complexity is O(1) since no additional structures or intermediate tables are required.

2298. Tasks Count in the Weekend - Practice Online

Table: Tasks

+-------------+------+
| Column Name | Type |
+-------------+------+
| task_id     | int  |
| assignee_id | int  |
| submit_date | date |
+-------------+------+
task_id is the primary key (column with unique values) for this table.
Each row in this table contains the ID of a task, the id of the assignee, and the submission date.

Write a solution to report:

the number of tasks that were submitted during the weekend (Saturday, Sunday) as weekend_cnt, and
the number of tasks that were submitted during the working days as working_cnt.

Return the result table in any order.

The result format is shown in the following example.

Example 1:

Input: 
Tasks table:
+---------+-------------+-------------+
| task_id | assignee_id | submit_date |
+---------+-------------+-------------+
| 1       | 1           | 2022-06-13  |
| 2       | 6           | 2022-06-14  |
| 3       | 6           | 2022-06-15  |
| 4       | 3           | 2022-06-18  |
| 5       | 5           | 2022-06-19  |
| 6       | 7           | 2022-06-19  |
+---------+-------------+-------------+
Output: 
+-------------+-------------+
| weekend_cnt | working_cnt |
+-------------+-------------+
| 3           | 3           |
+-------------+-------------+
Explanation: 
Task 1 was submitted on Monday.
Task 2 was submitted on Tuesday.
Task 3 was submitted on Wednesday.
Task 4 was submitted on Saturday.
Task 5 was submitted on Sunday.
Task 6 was submitted on Sunday.
3 tasks were submitted during the weekend.
3 tasks were submitted during the working days.