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

General Discussion

Benjamin Botwin
Benjamin Botwin
13,434 Points
Posted by Benjamin Botwin
Benjamin Botwin
13,434 Points

SQL question possibly broken...

The last question on this page (https://teamtreehouse.com/library/grouping-joining-and-cleaning-up) doesn't seem to work.

I've tried this line of sql in mysql workbench and it seems to work fine.

select title, ifnull(avg(score), 0) as average from reviews left outer join movies on reviews.movie_id = movies.id group by movie_id having avg(score) <= 2;

but when I enter it into the question it tells me it's wrong :(

Is it broken or am I doing something wrong?

Thanks, Ben

1 Answer

Cameron Lichtenstein
Cameron Lichtenstein
3,912 Points
Cameron Lichtenstein
Cameron Lichtenstein
3,912 Points

Had a heck of a time with this one myself. I submitted some feedback to Treehouse about it since the error messages are very unhelpful (and flat out wrong I believe on the IFNULL detection). Hopefully they'll fix it a bit.