Databases Reporting with SQL Working with Text Concatenating Text

Cole Vance
Cole Vance
882 Points

How does my query need to be adjusted?

Request: Generate a list of strings that are in the following format: Andrew Chalkley andrew@teamtreehouse.com.

Query: SELECT first_name || " " ||last_name || " " || email FROM patrons;

1 Answer

Rick Gleitz
Rick Gleitz
41,835 Points

Hi Cole,

You're pretty close!

You just need to concatenate the angle brackets around the email field and do the alias part of the instructions using the AS keyword.

Hope this helps!