Take a look in the table below:

```
Status ----------------- Email
Approved ----------------john@john.com 
Canceled --------------- john@john.com 
Canceled --------------- charles@charles.com 
Canceled --------------- charles@charles.com 
Canceled --------------- charles@charles.com 

```

I execute the query 

```
"SELECT DISTINCT Status, Email FROM dbo.sales":

Status ----------------- Email
Approved --------------- john@john.com 
Canceled ----------------john@john.com 
Canceled --------------- charles@charles.com 

```

I'd like to set up a query to select the rows that have the status "Canceled" ONLY WHEN there is not a row with the same email with the status "Approved".

In other words, I'd to select only the last entry (Canceled - charles@charles.com) in this example.

Is it possible? Thanks in advance.