如果condition为true，则SQL Filter行

I am trying to run a query that will filter the rows by this expression (If instance name LIKE '1 %' then remove all the rows that has the same EntityKeyID) I removed some columns on the example no place for them I am trying to run a query that will filter the