I have a table:

```
Ticket #      SubmitDate    Status
    101        1/1/2015     Closed
    102        1/1/2015     Closed
    103        1/1/2015     Closed
    104        1/2/2015      Open
    105        1/2/2015     Closed
    106        1/2/2015      Open
    107        1/2/2015      Open
    108        1/2/2015     Closed
    109        1/3/2015     Closed
    110        1/4/2015      Open
    111        1/5/2015     Closed
    112        1/5/2015     Closed
    113        1/5/2015      Open
    114        1/5/2015      Open
    115        1/5/2015      Open

```

I'm trying to find the oldest ticket that is still open.
I know that MIN(SubmitDate) will get the me oldest SubmitDate but I'm having trouble putting the query together.

NEW EDIT:
Hi again all. I am revising the question so it is more clear. I apologize to anyone that thought it was confusing. I was under pressure to get an answer right away so I posted it too hastily.

I am trying to determine the oldest ticket # that is still in 'Open' status.
I've being going about it all wrong:

Here is one of my failed queries:

```
SELECT

MIN(SubmitDate) as [Date Submitted]
,(SELECT FROM TicketTable WHERE Status = 'Open' AND SubmitDate = MIN(SubmitDate)) as [Ticket #]
,Status as [Status]

FROM TicketTable

```

The result I am trying to achieve is:

```
Date Submitted  Ticket #    Status
1/2/2015          104        Open

```

Again, I apologize profusely. It was never my intention to simply get the answer. I was merely hoping for a hint. Thanks again all.