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

Ioannis Bouramas
Ioannis Bouramas
12,583 Points
Posted by Ioannis Bouramas
Ioannis Bouramas
12,583 Points

CHALLENGE 3 DRIVES ME CRAZY

Like before, select the average "score" as "average", setting to 0 if null, by grouping the "movie_id" from the "reviews" table. Also, do an outer join on the "movies" table with its "id" column and display the movie "title" before the "average". Finally, filter out any "average" score over 2.

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

That is what I type..I am really stuck....ruined my morning

1 Answer

Petros Sordinas
Petros Sordinas
16,181 Points
Petros Sordinas
Petros Sordinas
16,181 Points

Hi Ioannis,

I think your problem is here : IFNULL(AVG(score),0) AS average - You are basically telling mySQL to select the average of score and if that is null, convert it to 0

You probably want it like this: AVG(IFNULL(score, 0)) AS average

Ioannis Bouramas
Ioannis Bouramas
12,583 Points
Ioannis Bouramas
Ioannis Bouramas
12,583 Points

Tried it ...it doesn't work....thanks for the answer though...