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

Marinko Klac
1,165 Points
Getting the right result, but program doesn't approve it.

Posted October 8, 2018 4:04pm by Marinko Klac

Marinko Klac
1,165 Points
2 Answers
tomd
16,701 Points
I've tried maybe 10 variations, and I still can't pass.

Posted September 30, 2018 12:02pm by tomd

tomd
16,701 Points
1 Answer
Karen Shumate
13,579 Points
Write a query that will retrieve all email addresses but will replace the @ symbol with <at> so they all look like andre

Posted September 29, 2018 10:31pm by Karen Shumate

Karen Shumate
13,579 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
I am having trouble with the following prompt:

Posted September 4, 2018 7:50pm by Daniel Sparks

Daniel Sparks
2,695 Points
1 Answer
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
Brian Ross
11,209 Points
Getting a weird error: Expected results to look like "Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001".

Posted August 26, 2018 11:04pm by Brian Ross

Brian Ross
11,209 Points
5 Answers
Erin Clayton
3,840 Points
What am I doing wrong?

Posted August 24, 2018 1:52am by Erin Clayton

Erin Clayton
3,840 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,098 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,098 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
PLUS

Takyi Akwah
Courses Plus Student 1,049 Points
Help with Length function

Posted August 12, 2018 11:10am by Takyi Akwah

Takyi Akwah
Courses Plus Student 1,049 Points
2 Answers
Haisam Elkewidy
26,987 Points
correct answer is being interpreted by the site as incorrect

Posted August 11, 2018 5:34pm by Haisam Elkewidy

Haisam Elkewidy
26,987 Points
1 Answer
Andy McMurry
4,276 Points
I think my code is right but keep getting an error message

Posted August 11, 2018 3:36pm by Andy McMurry

Andy McMurry
4,276 Points
2 Answers
Robbie Thomas
31,093 Points
Getting the length of a string

Posted August 2, 2018 3:13pm by Robbie Thomas

Robbie Thomas
31,093 Points
1 Answer
Avid Coder
2,053 Points
Using Length Function

Posted July 26, 2018 2:00pm by Avid Coder

Avid Coder
2,053 Points
1 Answer
Avid Coder
2,053 Points
SQL help regarding aliasing

Posted July 25, 2018 4:08pm by Avid Coder

Avid Coder
2,053 Points
2 Answers
Bryan Makle
4,531 Points
Expecting reuslts like 'L Chalkley' not 'L Chalkley'. I need assistance please?

Posted July 23, 2018 9:43pm by Bryan Makle

Bryan Makle
4,531 Points
2 Answers
Bryan Makle
4,531 Points
How do I add angle brackets at the beginning and end of the email? Please assist

Posted July 23, 2018 4:54pm by Bryan Makle

Bryan Makle
4,531 Points
2 Answers
PLUS

Takyi Akwah
Courses Plus Student 1,049 Points
Concatenation Challenge Help

Posted July 18, 2018 11:59am by Takyi Akwah

Takyi Akwah
Courses Plus Student 1,049 Points
2 Answers
PLUS

Amari Hanes
Courses Plus Student 2,025 Points
concat function sql

Posted July 15, 2018 2:58pm by Amari Hanes

Amari Hanes
Courses Plus Student 2,025 Points
0 Answers
PLUS

Amari Hanes
Courses Plus Student 2,025 Points
I am trouble with the concat function in sql

Posted July 15, 2018 2:44pm by Amari Hanes

Amari Hanes
Courses Plus Student 2,025 Points
2 Answers
PLUS

Scott McDowell
Courses Plus Student 1,233 Points
I can't solve this code

Posted July 1, 2018 12:48am by Scott McDowell

Scott McDowell
Courses Plus Student 1,233 Points
1 Answer
joshua inyang
948 Points
I've tried running it in the playground but I'm not seeing my error

Posted June 20, 2018 10:28pm by joshua inyang

joshua inyang
948 Points
1 Answer
joshua inyang
948 Points
Hello I'm a not understanding this can someone assist I thought this was saying to concatenate first, last, email?

Posted June 19, 2018 4:58pm by joshua inyang

joshua inyang
948 Points
3 Answers
Christopher Parke
21,978 Points
No error, but error?

Posted June 18, 2018 5:04pm by Christopher Parke

Christopher Parke
21,978 Points
3 Answers
Christopher Parke
21,978 Points
error messages are useless

Posted June 18, 2018 4:31pm by Christopher Parke

Christopher Parke
21,978 Points
1 Answer
barak ben ishay
1,951 Points
how to replace

Posted June 15, 2018 1:10pm by barak ben ishay

barak ben ishay
1,951 Points
3 Answers

Prev Page 8 of 10 Next

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