Skip to content

Instantly share code, notes, and snippets.

@3v0k4

3v0k4/select_id_films_id_films_title_films_genre_string_agg_reviews_content_from_films_left_join_reviews_group_by_films.id.sql

Last active December 21, 2019 00:02
Show Gist options
  • Save 3v0k4/453c67c26bf08c70989fa01d9ed25558 to your computer and use it in GitHub Desktop.
Save 3v0k4/453c67c26bf08c70989fa01d9ed25558 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select_id_films_id_films_title_films_genre_string_agg_reviews_content_from_films_left_join_reviews_group_by_films.id.sql
=> SELECT films.id, films.title, films.genre, string_agg(reviews.content, E'\n') FROM films LEFT JOIN reviews ON films.id = reviews.film_id GROUP BY films.id;
id | title | genre | string_agg
----+-------------------+----------+-----------------------------------------------------------
3 | Arrival | scifi |
1 | Blade Runner 2049 | thriller | Visually stunning and thought provoking, but not flawless+
| | | One of the best sequels of all time +
| | | Strangely boring, lacking tension and intelligence
2 | Inception | thriller | Amazing Directing, Captivating Plot, Overall Great
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment