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 Reporting by Example Day 3: Getting Good at Grouping Finding the Troublemaker

Stamos Bolovinos
Stamos Bolovinos
4,320 Points

What's wrong with having 5th period science and 7th period art?

Why is this student a troublemaker? I don't get it. I mean I could build the query to get the result, but don't understand the context.

2 Answers

Steven Parker
Steven Parker
231,184 Points

I don't think the class schedule has anything to do with being a "troublemaker". I think the idea is just that these two class times are both clues to identifying a particular student.

As to exactly who is a "troublemaker" or why is not explained. I suspect this is a reference to this particular episode of the "XKCD" comic strip in which a student's middle name is actually an SQL injection security attack. In that case, the "troublemaker" would actually be the student's mom.

Stamos Bolovinos
Stamos Bolovinos
4,320 Points

Got it! Because he's last name is 'Tables'... great comic strip site, thanks for that :-)

i'd say your suspicion is correct

Little Bobby Tables! That's brilliant!

Aside: it's fun to not only get the joke, but now understand some of the actual coding behind it!