SQL Server 2022

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

create table some_test_data
  (
    column_a varchar(10),
    column_b varchar(10)
  )
insert into some_test_data values ('TRA','ORIG');
insert into some_test_data values ('TRA','ORIG');
insert into some_test_data values ('TERM','_N');
insert into some_test_data values ('TRA','ORIG');
insert into some_test_data values ('ORIG-REV1','_N');
insert into some_test_data values ('ORIG-REV2','_N');
6 rows affected

select * 
  from some_test_data
 where column_b <> '_N'
    or (
       column_a <> 'ORIG-REV1'
   and column_a <> 'ORIG-REV2'
       )


column_a
column_b


TRA
ORIG

TRA
ORIG

TERM
_N

TRA
ORIG