Just looking at my XML field, my rows look like this:

```
<person><firstName>Jon</firstName><lastName>Johnson</lastName></person>
<person><firstName>Kathy</firstName><lastName>Carter</lastName></person>
<person><firstName>Bob</firstName><lastName>Burns</lastName></person>

```

Note that these are three rows in my table.

I'd like to return a SQL result as a table as in

```
Jon  | Johnson
Kathy| Carter
Bob  | Burns

```

What query will accomplish this?