I have a column "Status" which has value : archived, accepted, sold, sent.
I want to get the dealid which its status is either not accepted or not archived. But dealid A has multiple status by different time, i.e. sent, sold, archived. So, how can I get the dealid without dealid A.
This is the query I wrote, but it still return dealid A.
select dealid from dealview
where status <>'archived' or status<>'accepted'