Hello,
The desired output can be achieved by this query

select * from (Table_name) where
( nvl(plotnumber,'NA') ,nvl(gangcode,'NA'), nvl(commonpool,0) )
in
(select nvl(plotnumber,'NA')...