I have a table of customer ID's and a table of customer data. A customer can change ID's, but I want to query their earliest date in some cases, and the latest date in others. For example, I have two tables:

```
tbl_a
id        active_id
a         aa
b         aa
c         aa
d         bb
e         bb

tbl_b
id         date      city
a        1/1/2012    Dallas
b        1/1/2013    Houston
c        2/1/2013    Austin
d        1/1/2003    San Antonio
e        3/3/2013    El Paso

tbl_c
id    value
a      50
b      50
b      50
c      50
d      10
e      10
e      10

```

How would I query the data to return a single active\_id with the EARLIEST date and MOST RECENT city while summing the data from tbl\_c? For example, return the following:

```
active_id    date      city     sum(value)
aa           1/1/2012  Austin   200 
bb           1/1/2003  El Paso  30

```

In semantic terms, I'm trying to find the first date and most recent city for any active\_id, while summing the transaction values.