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 Joseph Damiani
Joseph Damiani
1,066 Points

Numeric and Aggregate Functions in Database Foundations.

I uploaded the new treehouse_movie_db and the reviews table is missing.

2 Answers

Andrew Gay
Andrew Gay
20,893 Points
Andrew Gay
Andrew Gay
20,893 Points

You need to run the script then refresh the SCHEMA

(That is what fixed it for me)

John Simoneau
PLUS
John Simoneau
Courses Plus Student 8,105 Points
John Simoneau
John Simoneau
Courses Plus Student 8,105 Points

Yeah, I had the same problem. I kept "opening" the script and then refreshing. But you have to "run" it via the lightning bolt then refresh (like Andrew said). In hind-sight it's very obvious but for some reason it wasn't clicking in my head at the time...