Databases Reporting with SQL Working with Text Concatenating Text

Mohd Aamir Mir
Mohd Aamir Mir
3,281 Points

where am i wrong in writing this query?

select first_name || last_name || "<" || email || ">." as "to_field" from patrons;

2 Answers

Steven Parker
Steven Parker
182,269 Points

You're pretty close, but:

  • you need a space between the names
  • you need a space between the last name and the first angle symbol
  • you don't need a period at the end
Steven Parker
Steven Parker
182,269 Points

Mohd Aamir Mir — Glad to help. You can mark a question solved by choosing a "best answer".
And happy coding!