Databases Reporting with SQL Working with Text Concatenating Text

Charity Thomas
seal-mask
.a{fill-rule:evenodd;}techdegree
Charity Thomas
Front End Web Development Techdegree Student 6,881 Points
Posted by Charity Thomas
.a{fill-rule:evenodd;}techdegree
Charity Thomas
Front End Web Development Techdegree Student 6,881 Points

Hello. I am stuck on this challenge. Can you please help? Thanks!

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

1 Answer

Peter Vann
MOD
Peter Vann
Treehouse Moderator 35,088 Points
Peter Vann
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!