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

Posted by Chris Gauthier
Chris Gauthier
Courses Plus Student 6,434 Points

Reporting with SQL - Challenge Task 2 of 2

https://teamtreehouse.com/library/reporting-with-sql/working-with-text/changing-cases-of-strings

Im being asked to select a first_name, last_name and library_id from a database. The first_name and last_name are aliased to a single column. My solution is below:

> select first_name || " " || upper(last_name) as full_name, library_id as libary_id from patrons;

full_name   libary_id
Andrew CHALKLEY MCL1001
Dave MCFARLAND  MCL1010
Alena HOLLIGAN  MCL1100
Michael POLEY   MCL1011

That appears to be the exact output they want, but my solution is not correct.

Any help would be appreciated, Chris

2 Answers

Steven Parker
Steven Parker
231,128 Points
Steven Parker
Steven Parker
231,128 Points

You just have a typo/misspelling.

You wrote "libary_id" (just one "r") instead of "library_id" (two "r"s) for the last alias.

But you don't really need an alias there at all since that's the column name.

Chris Gauthier
PLUS
Chris Gauthier
Courses Plus Student 6,434 Points
Chris Gauthier
Chris Gauthier
Courses Plus Student 6,434 Points

Thank you!