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

Development Tools

Michael Caveney
Michael Caveney
50,144 Points
Posted by Michael Caveney
Michael Caveney
50,144 Points

Grouping, Joining, and Cleaning Up Challenge 2 of 3 Bugged?

Stuck on this question. Here is my code:

SELECT movies.title, IFNULL(AVG(score),0) AS average FROM reviews RIGHT OUTER JOIN movies ON movies.id = reviews.movie_id GROUP BY movie_id HAVING average < 2;

Looking through the forums, it seems that others have passed this with similar or exact code. Is this bugged?

2 Answers

Ken Alger
STAFF
Ken Alger
Treehouse Teacher
Ken Alger
Ken Alger
Treehouse Teacher

Michael;

Have you tried:

# Course: Database Foundations
# Module: SQL Calculating, Aggregating and Other Functions
# Challenge: Grouping, Joining, and Cleaning Up
# Task: 2 of 3


SELECT AVG(score) AS average FROM reviews GROUP BY movie_id HAVING average < 2;

Happy coding,

Ken

Michael Caveney
Michael Caveney
50,144 Points
Michael Caveney
Michael Caveney
50,144 Points

That did it. I clearly need to spend more time with the SQL documentation. Thanks!