Databases Reporting with SQL Working with Text Concatenating Text

David Corrales
David Corrales
4,646 Points

Confused need help properly adding brackets around an email!

Challenge Task 1 of 2 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.

Type in your command below, then press Ctrl-Enter.

Bummer: There's something wrong with your SQL statement. Please review your code and try again.

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

2 Answers

Steven Parker
Steven Parker
172,127 Points

You're really close! I see two issues left:

  • there's an extra concatenation operator ("||") after the last string
  • that last string also has an unneeded space at the end ("> ")
David Corrales
David Corrales
4,646 Points

Wow! You're so fast! Thank you I'll try it!

Steven Parker
Steven Parker
172,127 Points

Just a lucky coincidence, and glad to help. You can mark a question solved by choosing a "best answer".

And happy coding!