Leecode - 2298. Tasks Count in the Weekend

Table of Contents

Solution

Problem

[Tasks Count in the Weekend - LeetCode

Tasks Count in the Weekend - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

LeetCode

](https://leetcode.com/problems/tasks-count-in-the-weekend/description/)

Solution

SELECT COUNT(weekend) AS weekend_cnt, COUNT(working) AS working_cnt
FROM (
    SELECT CASE WHEN WEEKDAY(submit_date) > 4 THEN 'weekend' END as weekend,
             CASE WHEN WEEKDAY(submit_date) < 5 THEN 'working' END as working
    FROM Tasks
) AS Temp