WITH T
AS (SELECT
        SERVICE.CODE_SERVICE,
        CASE
          WHEN EXTRACT(WEEKDAY FROM CURRENT_TIMESTAMP) = 0
          THEN 7
          ELSE EXTRACT(WEEKDAY FROM CURRENT_TIMESTAMP)
        END AS CURR_D_NUMBER,
        CASE
          WHEN EXTRACT(WEEKDAY FROM SERVICE.BYDATE) = 0
          THEN 7
          ELSE EXTRACT(WEEKDAY FROM SERVICE.BYDATE)
        END AS D_NUMBER
    FROM
        SERVICE
    WHERE SERVICE.BYDATE BETWEEN DATEADD(-1 WEEK TO CURRENT_TIMESTAMP) AND CURRENT_TIMESTAMP)
SELECT
    COUNT(T.CODE_SERVICE) AS CNT,
    COUNT(
    CASE
      WHEN (CURR_D_NUMBER >= D_NUMBER) AND D_NUMBER = 1
      THEN T.CODE_SERVICE
    END) AS CNT_MON,
    COUNT(
    CASE
      WHEN (CURR_D_NUMBER >= D_NUMBER) AND D_NUMBER = 2
      THEN T.CODE_SERVICE
    END) AS CNT_TUE,
    COUNT(
    CASE
      WHEN (CURR_D_NUMBER >= D_NUMBER) AND D_NUMBER = 3
      THEN T.CODE_SERVICE
    END) AS CNT_WEN,
    COUNT(
    CASE
      WHEN (CURR_D_NUMBER >= D_NUMBER) AND D_NUMBER = 4
      THEN T.CODE_SERVICE
    END) AS CNT_THU,
    COUNT(
    CASE
      WHEN (CURR_D_NUMBER >= D_NUMBER) AND D_NUMBER = 5
      THEN T.CODE_SERVICE
    END) AS CNT_FRI,
    COUNT(
    CASE
      WHEN (CURR_D_NUMBER >= D_NUMBER) AND D_NUMBER = 6
      THEN T.CODE_SERVICE
    END) AS CNT_SAT,
    COUNT(
    CASE
      WHEN (CURR_D_NUMBER >= D_NUMBER) AND D_NUMBER = 7
      THEN T.CODE_SERVICE
    END) AS CNT_SUN
FROM
    T