Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE rpt_tab (
    e_id      NUMBER(10),
    region    VARCHAR2(20),
    stages    VARCHAR2(20),
    end_date  DATE
);
BEGIN
INSERT INTO rpt_tab VALUES(10,'Mumbai','STG_1', DATE '2022-04-11');
INSERT INTO rpt_tab VALUES(11,'Mumbai','STG_1', DATE '2022-04-12');
INSERT INTO rpt_tab VALUES(12,'France','STG_1', DATE '2022-04-13');
INSERT INTO rpt_tab VALUES(13,'France','STG_1', DATE '2022-04-14');
END;
/
1 rows affected

SELECT COUNT(*) since_tuesday
FROM   rpt_tab
WHERE  end_date >= TRUNC(SYSDATE - 1, 'IW') + 1
AND    end_date <  TRUNC(SYSDATE) + 1
GROUP BY stages


SINCE_TUESDAY


1


-- Put in tomorrow's date rather than SYSDATE
SELECT COUNT(*) since_tuesday
FROM   rpt_tab
WHERE  end_date >= TRUNC(DATE '2022-04-13' - 1, 'IW') + 1
AND    end_date <  TRUNC(DATE '2022-04-13') + 1
GROUP BY stages


SINCE_TUESDAY


2


-- Put in 14th April rather than SYSDATE
SELECT COUNT(*) since_tuesday
FROM   rpt_tab
WHERE  end_date >= TRUNC(DATE '2022-04-14' - 1, 'IW') + 1
AND    end_date <  TRUNC(DATE '2022-04-14') + 1
GROUP BY stages


SINCE_TUESDAY


3