If I wanted to pull data from a table call it sales where criteria is not met without doing a subselect what is the best way to do that.

I have been trying to pull all the data from the table where two criteria are not met

I am essentially trying to do

```
select * 
from  sales
where sales_id not in (select sales_id 
                       from  sales 
                       where sales_percentage<.02 
                         and sales_region in ('SW','SE'))

```

I tried the below but it isn't working as expected am I thinking about this incorrectly?

```
Select * 
from sales
where not(sales_percentage<.02 and sales_region in ('SW','SE'))

```