Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
886 Points
Unclear what I am getting wrong...

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

Jeremy Jones
886 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
4,660 Points
Stuck on this task?

Posted January 22, 2019 12:38am by dfeem

dfeem
4,660 Points
2 Answers
Grafton John
1,871 Points
Concatenation code challange

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

Grafton John
1,871 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,170 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,170 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,646 Points
Confused need help properly adding brackets around an email!

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

David Corrales
4,646 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
11,090 Points
I'm not seeing the difference?

Posted December 3, 2018 4:49am by okilydokily

okilydokily
11,090 Points
2 Answers
IT Support
1,806 Points
doesnt make sense

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

IT Support
1,806 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
13,579 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
13,579 Points
0 Answers
Sam Beattie
2,413 Points
I don't know what I'm missing on this challenge in the Reporting with SQL track. I need to "Alias it to to_field."

Posted September 11, 2018 8:13pm by Sam Beattie

Sam Beattie
2,413 Points
3 Answers
Daniel Sparks
2,695 Points
Stuck on a training challenge...

Posted August 31, 2018 5:56pm by Daniel Sparks

Daniel Sparks
2,695 Points
1 Answer
Domenic Crump
2,707 Points
How do you concatenate 3 columns?? I'm so confused, it's Challenge Question 1 Reporting w/ SQL

Posted August 31, 2018 5:55pm by Domenic Crump

Domenic Crump
2,707 Points
2 Answers
Branislav Galovic
713 Points
Challenge 2

Posted August 14, 2018 8:34pm by Branislav Galovic

Branislav Galovic
713 Points
1 Answer
Franklyn Gregory
12,083 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name,

Posted August 14, 2018 6:55am by Franklyn Gregory

Franklyn Gregory
12,083 Points
2 Answers
Amy Hsieh
6,023 Points
I can't see where the problem is. The system message: Your query needs didn't retireve the emails in the correct form

Posted August 13, 2018 5:15am by Amy Hsieh

Amy Hsieh
6,023 Points
1 Answer

Prev Page 2 of 3 Next

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