We have these 2 queries:

```
select jsh.jobid, max(jsh.Audit_CreatedDate)
from JobStatusHistories jsh 
join Jobs j on j.JobId = jsh.JobId
where j.JobStatusId = 11 
and jsh.Audit_CreatedBy <> 'Archiver'
and jsh.Audit_CreatedDate < '5/9/2015'
group by jsh.jobid

```

and 

```
select jsh.jobid 
from JobStatusHistories jsh 
join Jobs j on j.JobId = jsh.JobId
where j.JobStatusId = 11 
and jsh.Audit_CreatedBy <> 'Archiver'
group by jsh.jobid
having MAX(jsh.Audit_CreatedDate) < '5/9/2015'

```

The first returns 5.3 million records and the second returns 4.3 million. 

The goal is to get a list of jobids where the job status is 11 and has been modified over 5 months ago (old) but they may have been modified recently by the Archiver, so we want to ignore those.

Simplified data might look like:

```
JobId    Audit_CreatedDate    Audit_CreatedBy
234      3/25/2015            Importer
234      9/25/2015            Archiver
456      8/25/2015            Importer
456      9/25/2015            Archiver
789      3/25/2015            Importer
789      4/25/2015            Archiver

```

We would expect to get back:

```
JobId    Audit_CreatedDate    
234      3/25/2015            
789      3/25/2015            

```

Unfortunately, both queries return so many results, it's difficult to see which is doing what we want.