Databases Reporting with SQL Working with Text Concatenating Text

Daniel Sparks
Daniel Sparks
2,695 Points

Stuck on a training challenge...

This is the prompt I am having trouble responding to:

"In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, last_name, address, email, library_id and zip_code. Generate a list of strings that are in the following format: Andrew Chalkley andrew@teamtreehouse.com. Concatenate the first name, last name and email address for all users. Alias it to to_field. This will be used in the "To" field in email marketing."

I am not certain how to incorporate all of the elements of such a query together yet. The model we have been given to work with resemble this: "SELECT <value or column> || <value or column> || <value or column> FROM <table>;"

Thus, we have been trying inputs that resemble: "SELECT first_name || last_name || email FROM patrons AS to_field;"

We are most commonly receiving the feedback that there is a formatting issue with the email output but we assume there are other issues with our query as well.

Any input would be much appreciated.

1 Answer

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 42,368 Points

There are spaces and <> around the email address to consider. Try:

SELECT first_name || ' ' || last_name || ' <' || email || '>' AS to_field FROM patrons;
Daniel Sparks
Daniel Sparks
2,695 Points

Thanks so much Kris, That did end up working! I'll be sure to parse out how everything it that query contributes to the output.