Databases Reporting with SQL Working with Text Concatenating Text

Posted by Kathuri k
Kathuri k
586 Points

syntax looks ok but throwing error

What's the issue here?

1 Answer

Peter Vann
MOD
Peter Vann
Treehouse Moderator 35,088 Points
Peter Vann
Peter Vann
Treehouse Moderator 35,088 Points

Hi Kathuri!

This passes the first challenge:

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

This passes the second:

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

I hope that helps.

Stay safe and happy coding!