Need help with corecly applyingwhere statment

[yosiasz]

has already been asked to define business rule

Problem with creating quri for alocating amount

Good day some people alredy saw this qvestion from me but here i am again i made a good saple data this time Step one 1 create table olap.sampledata1 ( [Date] date ,TC1 varchar(100),Amount_New decimal(10,2) ) Step 2 INSERT INTO [OLAP].[sampledata1] ([Date] ,[TC1] ,[Amount_New]) VALUES ('2020-11-01','Houses:N-Home',70), ('2020-11-01','Houses:N-KL',80), ('2020-11-01','Default Category: Default Option',90), ('2020-11-01','Houses:NS-Home',22.5), ('2020-11-…