Group and Aggregate Data in Postgres

Brett Cassette
InstructorBrett Cassette

Share this video with your friends

Send Tweet

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.

EthanChou
EthanChou
~ 3 years ago

should delete last row in csv file otherwise there would raise import error

Nenad
Nenad
~ 2 years ago

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

Jikku Jose
Jikku Jose
~ 2 years ago

Yes, I was also confused where to find the insert.sql file