How do I extract a value (row) from this value table column?

[Libbyb23]

Hi,

How do I pull out a value from this value table?

Here is my query: 

I need to pull email_address out of the address column.

Thanks!

[Greg_Deckler · Accepted solution]

@Libbyb23 See those diverging arrows in the header of "address" column? Click those and then select the email address. 

[Libbyb23]

Thanks Greg!