Treehouse | Community | Creating Excerpts

🤑 Join the Treehouse affiliate program and earn 25% commission!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Christopher Endswell
1,781 Points
Getting the following error message: Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'. What is going on?

Posted June 22, 2019 8:45am by Christopher Endswell

Christopher Endswell
1,781 Points
2 Answers
omid ayoobe
5,274 Points
get same results but error in code. SUBSTR(first_name,1,1)

Posted June 20, 2019 5:12pm by omid ayoobe

omid ayoobe
5,274 Points
1 Answer
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
2,226 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
2,226 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,992 Points
why id did not work

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

Faisal Aleissa
1,992 Points
1 Answer
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,797 Points
SELECT first_name || " " || last_name || " " || "<" || email || ">" FROM patrons AS 'to_field';

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

Robert Hecht
6,797 Points
1 Answer
David Wells
13,270 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
13,270 Points
2 Answers
Øystein Kallset
11,044 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
11,044 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,233 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,233 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
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
886 Points
Unclear what the desired answer is, again

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

Jeremy Jones
886 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
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
2,184 Points
Concatenation code challange

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

Grafton John
2,184 Points
2 Answers
Leslie Perez
993 Points
I keep getting an error with this query

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

Leslie Perez
993 Points
4 Answers
Abiel Ortega
2,171 Points
I dont get it

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

Abiel Ortega
2,171 Points
1 Answer
PLUS

YA Abidakadr
Courses Plus Student 2,017 Points
error

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

YA Abidakadr
Courses Plus Student 2,017 Points
1 Answer
PLUS

YA Abidakadr
Courses Plus Student 2,017 Points
simple error

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

YA Abidakadr
Courses Plus Student 2,017 Points
1 Answer
PLUS

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

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

YA Abidakadr
Courses Plus Student 2,017 Points
1 Answer
Abiel Ortega
2,171 Points
I don't see whats wrong

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

Abiel Ortega
2,171 Points
1 Answer
Abiel Ortega
2,171 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,171 Points
1 Answer
David Corrales
4,698 Points
Some small minor error perhaps reporting with SQL, can someone help?

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

David Corrales
4,698 Points
3 Answers

Prev Page 6 of 10 Next

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