MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT SUBDATE(CURDATE(), weekday(CURDATE())); --Start of week


SUBDATE(CURDATE(), weekday(CURDATE()))


2022-05-02


SELECT DATE(CURDATE() + INTERVAL (6 - WEEKDAY(CURDATE())) DAY); --End of week


DATE(CURDATE() + INTERVAL (6 - WEEKDAY(CURDATE())) DAY)


2022-05-08


CREATE TABLE dailydata (
    employee_id int,
    date date,
    total int
);
INSERT INTO dailydata
VALUES
(20,'2022-04-25	',10),
(20,'2022-04-26	',10),
(20,'2022-04-27	',10),
(20,'2022-04-28	',50),
(20,'2022-04-29	',40),
(20,'2022-04-30	',10),
(20,'2022-05-01	',50),
(20,'2022-05-02	',10),
(20,'2022-05-03	',60),
(20,'2022-05-04	',10),
(20,'2022-05-05	',70),
(20,'2022-05-07	',80),
(31,'2022-05-02	',10),
(31,'2022-05-03	',60),
(31,'2022-05-06	',60)
SELECT employee_id, IFNULL(SUM(total),0) AS total,
IFNULL(SUM(CASE date WHEN subdate(CURDATE(), 1) THEN total ELSE 0 END),0) AS yesterday_total
FROM dailydata
WHERE date BETWEEN SUBDATE(CURDATE(), weekday(CURDATE())) AND (CURDATE() + INTERVAL (6 - WEEKDAY(CURDATE())) DAY)
GROUP BY employee_id


employee_id
total
yesterday_total


20
230
0

31
130
60