I cannot figure out the solution to Challenge Task 1 of 2 under Reporting with SQL: Adding Text Columns Together

There's no answer function, but when you have trouble you can always post your code here and folks will generally help you identify the problems.

But before you do that I can give you a few hints based on commonly seen issues in the forum:

• the data must be concatenated in to a single string
• the single string gets a column alias
• the concatenation must include fields and literals to create proper spacing
• the literals must also include the <> characters that go around the email address

Give it another shot with those in mind and post your code here if you still have trouble.

Hello, my solution is the following: SELECT first_name || " " || last_name || " " || "<" || "email" || ">" AS "to_field" FROM patrons; And it is still marked as wrong. I tried this query in the SQL playground and it worked. The results I got, is exactly as the suggested one in the question The question was: 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.