Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Shikhar Prateek
1,778 Points
'Your query didn't retrieve the emails in the correct format.' But the query is giving the same result in the workspace.

Posted June 14, 2019 12:23pm by Shikhar Prateek

Shikhar Prateek
1,778 Points
1 Answer
brayden gosse
749 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 May 21, 2019 3:10am by brayden gosse

brayden gosse
749 Points
2 Answers
Hugo Macfarland
2,030 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 May 19, 2019 4:48pm by Hugo Macfarland

Hugo Macfarland
2,030 Points
1 Answer
Faisal Aleissa
1,677 Points
why id did not work

Posted April 27, 2019 11:14pm by Faisal Aleissa

Faisal Aleissa
1,677 Points
0 Answers
Nelson Pamplona
1,575 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
1,575 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,314 Points
SELECT first_name || " " || last_name || " " || "<" || email || ">" FROM patrons AS 'to_field';

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

Robert Hecht
6,314 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,224 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,224 Points
6 Answers
Iman Ali
3,460 Points
ERROR WHEN CONCATENATING WITH A COMMA

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

Iman Ali
3,460 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,838 Points
Stuck on this task?

Posted January 22, 2019 12:38am by dfeem

dfeem
3,838 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,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,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

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.