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 naga Shanmukha
naga Shanmukha
Courses Plus Student 12,482 Points

The library is generating new library cards that will display the full name and their library ID. The full name needs to

The library is generating new library cards that will display the full name and their library ID. The full name needs to have the last name in all caps. Create a report with two columns of results, one is an alias of full_name the second being the library_id.

Steven Parker
Steven Parker
231,248 Points
Steven Parker
Steven Parker
231,248 Points

Have you written any code yet? After a good-faith attempt, if you're still having problems, try posting your code here.

Also, it's helpful if you provide a link to the challenge itself.

1 Answer

Steven Parker
Steven Parker
231,248 Points
Steven Parker
Steven Parker
231,248 Points

If you're working on the challenge I'm thinking of, the most common errors seem to be using the alias. Note that the challenge asks for two columns, one is made from other columns and gets an alias, but the other one is simply selected with no alias.