Databases Reporting with SQL Working with Text Concatenating Text

1 Answer

Balazs Pukli
Balazs Pukli
45,975 Points

You need to use concatination in this challenge.

The challenge wants you to use the concatenation operator ( || ). More info: https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators003.htm

In a real life situation, you could have used another solution, which is the CONCAT() function. More info: https://www.w3schools.com/sql/trymysql.asp?filename=trysql_func_mysql_concat2

Now the solution has to look something like this:

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