Query: imdb_movie_overview

select
  i.title as "Title",
  i.rating as "Rating",
  i.totalvotes as "Total Votes",
  string_agg(g.genre, ', ') as "Genre",
  i.budget as "Budget",
  i.runtime as "Runtime",
  i.metaCritic as "Meta Critic"
from
  imdb as i
  join genre as g on i.movie_id = g.movie_id
where
  i.movie_id = $1
group by
  i.title, i.rating, i.totalvotes, i.budget, i.runtime, i.metaCritic;