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
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
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
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 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
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
IT Support
1,483 Points
doesnt make sense

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

IT Support
1,483 Points
1 Answer
Moritz Laube
6,989 Points
Concatenating SQL

Posted November 10, 2018 8:29am by Moritz Laube

Moritz Laube
6,989 Points
1 Answer
Foster Lartey
927 Points
How do I concatenate into this exact format - Andrew Chalkley <andrew@teamtreehouse.com>?

Posted November 10, 2018 4:31am by Foster Lartey

Foster Lartey
927 Points
2 Answers
Siraj Khan
3,451 Points
Whats wrong with my code in this challenge.?

Posted November 5, 2018 10:35am by Siraj Khan

Siraj Khan
3,451 Points
1 Answer
Siraj Khan
3,451 Points
Can anyone please help me with this code.?

Posted November 5, 2018 9:24am by Siraj Khan

Siraj Khan
3,451 Points
0 Answers
jamie rose
3,637 Points
What am i doing wrong?

Posted October 24, 2018 8:38pm by jamie rose

jamie rose
3,637 Points
0 Answers
Rhea Khanna
2,838 Points
Concatenate/ Alias help

Posted October 19, 2018 11:18am by Rhea Khanna

Rhea Khanna
2,838 Points
4 Answers
Shain Jones
1,151 Points
Concatenation of name and email, where have I went wrong?

Posted October 16, 2018 1:45pm by Shain Jones

Shain Jones
1,151 Points
1 Answer
Sandeep Padda
2,781 Points
please help!

Posted October 16, 2018 1:42am by Sandeep Padda

Sandeep Padda
2,781 Points
4 Answers
Fairooz Adams
2,704 Points
Can't solve, stuck:

Posted October 14, 2018 3:36am by Fairooz Adams

Fairooz Adams
2,704 Points
1 Answer
Karen Shumate
12,510 Points
Concatenate the street, city, state, zip and country in the following format. Street, City, State Zip. Country e.g. 34 N

Posted September 29, 2018 2:39pm by Karen Shumate

Karen Shumate
12,510 Points
0 Answers

Prev Page 1 of 2 Next

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