SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE dds_Daily_MOP_Tb (
Store_Number int
, operations_day date
, mop varchar(50)
, mop_amount decimal(10,2)
)

INSERT INTO dds_Daily_MOP_Tb
VALUES (2322, '2021-07-21', 'CASH', 312.89)
,(2322, '2021-07-21', 'CHANGE', -52.93)
, (2322, '2021-07-21', 'DEBIT CARD', 1708.51)
3 rows affected

SELECT * FROM dds_Daily_MOP_Tb


Store_Number
operations_day
mop
mop_amount


2322
2021-07-21
CASH
312.89

2322
2021-07-21
CHANGE
-52.93

2322
2021-07-21
DEBIT CARD
1708.51


SELECT d.Store_Number
      , d.Operations_Day
      , CASE WHEN d.MOP IN ('Cash', 'Change') THEN 'CASH' ELSE d.MOP END AS MOP
      , SUM( d.MOP_Amount ) AS MOP_Amount
FROM dds_Daily_MOP_Tb d
WHERE d.Store_Number = 2322 
AND   d.Operations_Day = cast(dateAdd(d, -1 , GetDate()) as date)
GROUP BY  d.Store_Number
     , d.Operations_Day
     , CASE WHEN d.MOP IN ('Cash', 'Change') THEN 'CASH' ELSE d.MOP END
     
     


Store_Number
Operations_Day
MOP
MOP_Amount


2322
2021-07-21
CASH
259.96

2322
2021-07-21
DEBIT CARD
1708.51

Store_Number	operations_day	mop	mop_amount
2322	2021-07-21	CASH	312.89
2322	2021-07-21	CHANGE	-52.93
2322	2021-07-21	DEBIT CARD	1708.51