Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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

Posted April 23, 2019 8:08pm by Nelson Pamplona

Nelson Pamplona
972 Points
3 Answers
Apoorva Seeram
790 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted March 28, 2019 8:09pm by Apoorva Seeram

Apoorva Seeram
790 Points
2 Answers
Robert Hecht
6,079 Points
SELECT first_name || " " || last_name || " " || "<" || email || ">" FROM patrons AS 'to_field';

Posted March 20, 2019 2:54pm by Robert Hecht

Robert Hecht
6,079 Points
1 Answer
David Wells
12,856 Points
In the second question of the library/full name question, how do I write the concatenation SQL statement?

Posted March 19, 2019 5:54pm by David Wells

David Wells
12,856 Points
2 Answers
Øystein Kallset
637 Points
What is wrong with this SQL-statement: SELECT REPLACE(email,"@","<at>") FROM customers

Posted February 28, 2019 7:43am by Øystein Kallset

Øystein Kallset
637 Points
1 Answer
Namazbek Bekarysuly
882 Points
What is wrong?

Posted February 23, 2019 12:59am by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
1 Answer
Namazbek Bekarysuly
882 Points
SELECT first_name || " " || last_name " " || "<" || email || ">" AS "to_field" FROM patrons;

Posted February 22, 2019 11:14pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
2 Answers
Dan Epstein
3,172 Points
Can anyone assist with how to order the statement in the first SQL Concatenation code challenge? I kind of got lost.

Posted February 14, 2019 10:07am by Dan Epstein

Dan Epstein
3,172 Points
6 Answers
Iman Ali
3,443 Points
ERROR WHEN CONCATENATING WITH A COMMA

Posted February 10, 2019 1:46pm by Iman Ali

Iman Ali
3,443 Points
2 Answers
Andrzej Szelemetko
25,447 Points
replace(email, '@', '<at>') problems in task I am getting the following error: Bummer: Expectin

Posted February 3, 2019 7:31pm by Andrzej Szelemetko

Andrzej Szelemetko
25,447 Points
1 Answer
Jeremy Jones
885 Points
Unclear what the desired answer is, again

Posted January 28, 2019 8:44pm by Jeremy Jones

Jeremy Jones
885 Points
1 Answer
vishal mishra
387 Points
select CONCAT(first_name , " " ,last_name , " " ,email)AS "to_field" from patrons what is wrong in it

Posted January 26, 2019 2:38pm by vishal mishra

vishal mishra
387 Points
1 Answer
Jeremy Jones
885 Points
Unclear what I am getting wrong...

Posted January 24, 2019 5:19pm by Jeremy Jones

Jeremy Jones
885 Points
2 Answers
Nerijus Velavicius
249 Points
SELECT Street || ", " || " " || City || ", " || " " || State || " " || Zip || "." || " " || Country || " " AS address

Posted January 23, 2019 7:10pm by Nerijus Velavicius

Nerijus Velavicius
249 Points
1 Answer
dfeem
3,818 Points
Stuck on this task?

Posted January 22, 2019 12:38am by dfeem

dfeem
3,818 Points
2 Answers
Grafton John
1,410 Points
Concatenation code challange

Posted January 2, 2019 6:21am by Grafton John

Grafton John
1,410 Points
2 Answers
Leslie Perez
943 Points
I keep getting an error with this query

Posted December 28, 2018 6:21pm by Leslie Perez

Leslie Perez
943 Points
4 Answers
Abiel Ortega
2,036 Points
I dont get it

Posted December 27, 2018 6:34am by Abiel Ortega

Abiel Ortega
2,036 Points
1 Answer
PRO

YA Abidakadr
Pro Student 2,017 Points
error

Posted December 24, 2018 4:30pm by YA Abidakadr

YA Abidakadr
Pro Student 2,017 Points
1 Answer
PRO

YA Abidakadr
Pro Student 2,017 Points
simple error

Posted December 24, 2018 4:28pm by YA Abidakadr

YA Abidakadr
Pro Student 2,017 Points
1 Answer
PRO

YA Abidakadr
Pro Student 2,017 Points
I do not know what is wrong

Posted December 24, 2018 3:52pm by YA Abidakadr

YA Abidakadr
Pro Student 2,017 Points
1 Answer
Abiel Ortega
2,036 Points
I don't see whats wrong

Posted December 19, 2018 5:38am by Abiel Ortega

Abiel Ortega
2,036 Points
1 Answer
Abiel Ortega
2,036 Points
I need help I don't understand how to change the format of the email I don't get what it's aking me to do there

Posted December 17, 2018 5:00am by Abiel Ortega

Abiel Ortega
2,036 Points
1 Answer
David Corrales
4,275 Points
Some small minor error perhaps reporting with SQL, can someone help?

Posted December 16, 2018 9:06pm by David Corrales

David Corrales
4,275 Points
2 Answers
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>"

Posted December 16, 2018 9:01pm by MADELINE COHEN

MADELINE COHEN
1,231 Points
1 Answer
David Corrales
4,275 Points
Confused need help properly adding brackets around an email!

Posted December 16, 2018 8:48pm by David Corrales

David Corrales
4,275 Points
2 Answers
PRO

naveen rajavasireddy
Pro Student 1,783 Points
what is the answer to challenge 1 in concatenation challenge in working-with-text concatenation?

Posted December 13, 2018 4:18am by naveen rajavasireddy

naveen rajavasireddy
Pro Student 1,783 Points
1 Answer
okilydokily
10,397 Points
I'm not seeing the difference?

Posted December 3, 2018 4:49am by okilydokily

okilydokily
10,397 Points
2 Answers
PRO

ct7
Pro Student 964 Points
Concatenate empty data

Posted November 30, 2018 7:05pm by ct7

ct7
Pro Student 964 Points
1 Answer
IT Support
1,483 Points
doesnt make sense

Posted November 30, 2018 11:13am by IT Support

IT Support
1,483 Points
1 Answer

Prev Page 1 of 4 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.