Databases Reporting with SQL Working with Text Concatenating Text

Nelson Pamplona
Nelson Pamplona
1,575 Points

I am not sure if I am supposed to include anything but first name, last name and email for this challenge.

My code isn't correct, but I am not sure what I did wrong.. Also not sure if I am supposed to use the brackets.

KRIS NIKOLAISEN
KRIS NIKOLAISEN
Pro Student 46,083 Points

Can you post your SQL? And yes you are supposed to concatenate the brackets.

3 Answers

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 46,083 Points

You brackets are fine. You don't need the period after the closing bracket though. Remove that and you'll pass.

Nelson Pamplona
Nelson Pamplona
1,575 Points

My guess is my brackets are off, just not sure how. Here is my SQL:

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