Databases Reporting with SQL Working with Text Concatenating Text

MADELINE COHEN
MADELINE COHEN
1,231 Points

I cannot figure out how to reformat the email in this statement to return a result in between these characters "<email>"

the challenge asks me to write a statement in which I join first name, last name, and email in a string, with the email reformatted between these characters "<>" so that email portion of the result is formatted as email@emailaddress.com

1 Answer

Steven Parker
Steven Parker
172,127 Points

Here's a few hints:

  • the concatenation operator ("||") will come in handy, you can use it to join data fields and/or fixed strings
  • remember to provide spaces in appropriate places while creating the joined result
  • also remember to give the joined result the correct alias name

I'll bet you can get it from here.