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 Database Foundations SQL Calculating, Aggregating and Other Functions Numeric and Aggregate Functions

Posted by dotz
dotz
6,733 Points

numeric and aggregate functions challenge 3

Totally stumped! sorry so long

I tried SELECT AVG(score) AS average_all_scores FROM reviews;

but I get an error referencing the lack of min_score used. I don't follow this tip.

Also, the word "joint" here sounds like we are looking perhaps for a RIGHT OUTER JOIN between reviews and movies (two tables) but the question says "movie's" (my quotes) - is this a typo? Neither the Reviews nor Movies tables has a movie (singular) column.

I don't usually look for an answer outright, but this time I'm clueless. Thank you.

1 Answer

Nathan Smutz
Nathan Smutz
9,492 Points
Nathan Smutz
Nathan Smutz
9,492 Points

I successfully used the same answer.

I think the site just glitched in this case. The "min_score" hint sounds like it's for the previous question (2).

I'd just try it again; maybe after logging out and back in or restarting your browser.

dotz
dotz
6,733 Points

ugh! Thank you for taking the time. I will try logging out next time before posting a question too.