Databases Reporting with SQL Working with Text Concatenating Text

brayden gosse
brayden gosse
750 Points

In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

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.

2 Answers

Antonio De Rose
Antonio De Rose
20,840 Points

make an effort, if you do something, we can help you with something, if you dont, we cannot help, if you don't know, where to start the quiz, go back, still if you cannot find, go back, until the course start.

brayden gosse
brayden gosse
750 Points

select first_name || " " || last_name || " " || email as "to_field", from patrons

Antonio De Rose
Antonio De Rose
20,840 Points

good that you have taken some effort, you have got almost all correct, couple of issues.

alias is correct, the concatenation operator is correct, in sqllite

your answer

select first_name || " " || last_name || " " || email as "to_field", from patrons

addressing your issues

1) why there is a semicolon, after the alias, take that off select first_name || " " || last_name || " " || email as "to_field" from patrons

2) where is the angle bracket, surrounding the email select first_name || " " || last_name || " " || "<" || email || ">" as "to_field" from patrons