How can we see a histogram of movies on IMDB with a particular rating? Or how much movies grossed at the box office each month? Or how many movies there are of each genre? These are examples of data aggregation questions, and this lesson will teach us how to answer them.
should delete last row in csv file otherwise there would raise import error
Was able to import without a problem but there was no obvious link to file
Csv here: https://s3-us-west-1.amazonaws.com/brett-egghead/window_functions/movies.csv And bash script here: https://github.com/brettshollenberger/postgres_101/blob/master/bin/create_tables
Yes, I was also confused where to find the insert.sql file