MySQL 5.6

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

CREATE TABLE transaction (
  Id int NOT NULL AUTO_INCREMENT,
  Name varchar(50),
  Price int,
  PRIMARY KEY (Id)
);

INSERT into transaction (Name, Price) VALUES ('Apple', 5);
INSERT into transaction (Name, Price) VALUES ('Car Wash', 30);
INSERT into transaction (Name, Price) VALUES ('Orange', 10);
INSERT into transaction (Name, Price) VALUES ('Car Wash', 25);
INSERT into transaction (Name, Price) VALUES ('Apple', 5);
-- Without the next line, I should recieve count of '2'.
INSERT into transaction (Name, Price) VALUES ('Car Wash', 0);
INSERT into transaction (Name, Price) VALUES ('Car Wash', 30);
-- With that line, I should recieve count of '1'

SELECT * 
FROM transaction t1
WHERE Name LIKE '%Car Wash%'
  AND NOT EXISTS ( SELECT NULL
                   FROM transaction
                   WHERE t1.id <= id
                     AND Name LIKE '%Car Wash%'
                     AND Price = 0 );
                     
SELECT COUNT(*)
FROM transaction t1
WHERE Name LIKE '%Car Wash%'
  AND NOT EXISTS ( SELECT NULL
                   FROM transaction
                   WHERE t1.id <= id
                     AND Name LIKE '%Car Wash%'
                     AND Price = 0 );

Id	Name	Price
7	Car Wash	30

COUNT(*)
1