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 SQL Basics Getting Data from a Database Retrieving Specific Columns of Information

I found a "mistake"?

"We're still using the phone_book table. Remember it has the columns of id, first_name, last_name and phone. Imagine a user is typing someone's last name in a search facility on the phone. As the user types, suggestions will appear on the screen. Bring back both the first name and last name for every person in the phone book. The phone will filter the appropriate suggestions."

It clearly says "Imagine a user is typing someone's ->last name<- in a search". So if someone is typing the last name, it should show the last name and then the name, or am i wrong? I mean okay, if you type "Jackson" you need just to search for the name. But still, it says "last name". So i assumed i need to show first the last_name column then the first_name.

1 Answer

Jennifer Nordell
seal-mask
STAFF
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher

Hi there, Damian Toczek ! No, not necessarily. Again, think of your contact list on your phone. Now I may have 5 people with the last name "Smith". If I search for "Smith" I would expect to see those 5 people as results. But in my contact list they are still shown with their first name first. Simply searching by last name shouldn't alter how the names are displayed. Similarly, if I search by email, I wouldn't expect the contact information to be listed with the email displayed first in my phone suddenly. Let's say I know I have contact information for a guy who works at one company. I remember the name of the company, but not the guy, so I know what domain his email is attached to. If I start searching by "@examplecompany.com". I would not expect to see the information displayed with the email in the place where I would normally see a first and last name. Rather, I would expect to see the first and last name and when I see it, I would likely think: "Oh yeah. That's his name. Right."

Hope this helps! :sparkles: