Database Foundation Grouping and Joining question 2 passed but confusion

Question

Hi Guys the question is - Like before, group reviews by "movie_id", get the average "score" as "average" and filter out any averages over 2.

I have completed the question and i don't want to put the whole answer but for the last part it passed as

HAVING average < 2;

I thought that bracket was less than? and isnt the average suppose to be over 2 which would be

HAVING average > 2;

little bit confused? Scott

Answer 1 · 2013-11-03T22:40:43Z

November 3, 2013 10:40pm

The question says to "filter out" any averages over 2, which means you don't want to include any averages over 2.

Answer 2 · 2013-11-03T23:12:25Z

November 3, 2013 11:12pm

Ah ha that explains it, i misread the question and took it to mean over thanks Ben

Answer 3 · 2013-11-06T20:17:41Z

November 6, 2013 8:17pm

An important lesson to us all on carefully reading through the problem and fully understanding it rather than trying to spit out what we just learned lol. Thanks for chiming in, Ben!

Answer 4 · 2013-11-18T16:06:44Z

November 18, 2013 4:06pm

but shouldn't it be HAVING average <= 2 because it says filter out anything ABOVE two but that would mean that averages that are exactly 2 should be included...

Answer 5 · 2013-11-18T16:16:44Z

November 18, 2013 4:16pm

Yes, you're correct Michele.

It'll actually pass the quiz both ways because there aren't any averages exactly equal to 2 in the data. However, if there were any averages exactly equal to 2, then it would have to be <= 2.

Answer 6 · 2015-09-02T02:07:15Z

September 2, 2015 2:07am

Go here: https://teamtreehouse.com/community/code-challenge-3-2

for good code examples.

Welcome to the Treehouse Community

Looking to learn something new?

Scott Paterson

Scott Paterson

Database Foundation Grouping and Joining question 2 passed but confusion

6 Answers

Ben Rubin

Ben Rubin

Scott Paterson

Scott Paterson

Will Lam

Will Lam

Michele Guido

Michele Guido

Ben Rubin

Ben Rubin

ryanjones6

ryanjones6