Adding parameters to ORACLE sql case statement
When I run the initial query without the Sample.Status NOT IN ('X','A') I get:



What I trying to get is the same view but without a Sample.Status being 'X' or 'A'.

I'm not sure where in the initial code to put the condition to exclude those sample.status lines.