Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Alex Forseth
Alex Forseth
8,017 Points
Posted by Alex Forseth
Alex Forseth
8,017 Points

My Creating Excerpts Challenge Answer is technically correct but wont allow me to pass - Please Help

In the Reporting SQL course doing the Creating Excerpts Challenge I get the following reason for why I am not passing - 

 Bummer! Expecting results like 'L Chalkley' not 'L Chalkley'.

Which obviously is confusing but I am guessing I didn't solve it the way treehouse wants me to solve it - Below is how I solved challenge: 

SELECT SUBSTR(first_name, 1, 1) AS "intitial", last_name FROM customers;

``

Any help would be appreciated.


HERE IS A LINK TO THE CHALLENGE:!!!  
https://teamtreehouse.com/library/reporting-with-sql/working-with-text/creating-excerpts
Jennifer Nordell
seal-mask
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher
Jennifer Nordell
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher

Hi there! Unfortunately, you haven't linked the challenge so I can't tell exactly which one you're working on. That being said, I have a feeling that should be AS "initial" instead of AS "intitial". Note the spelling differences between the two. Try correcting the spelling and see if that helps! :sparkles:

2 Answers

Steven Parker
Steven Parker
231,236 Points
Steven Parker
Steven Parker
231,236 Points

Your query is returning the correct values, but the problem is in the heading.

As Jennifer pointed out, you have "intitial" (with an extra "t") as the first column alias, but the challenge is expecting "initial".

codegritty
codegritty
5,749 Points
codegritty
codegritty
5,749 Points

Agree with the two. It's your spelling of the Alias. "Intitial" vs "INITIAL". If you believe your queries are correct, but find it to be wrong, always double check spelling.