Databases Reporting with SQL Working with Text Concatenating Text

1 Answer

Peter Vann
MOD
Peter Vann
Treehouse Moderator 35,088 Points

Hi Charity!

This passes the first task:

SELECT first_name || " " || last_name || " <" || email || ">" AS to_field
FROM patrons;

This passes the second task:

SELECT street || ", " || city || ", " || state || " " || zip || ". " || country AS address
FROM addresses

I hope that helps.

Stay safe and happy coding!