Skip to content

Instantly share code, notes, and snippets.

@3v0k4

3v0k4/select_id_films_id_films_title_films_genre_count_from_films_left_join_reviews_group_by_films.id.sql

Last active December 21, 2019 00:02
Show Gist options
  • Save 3v0k4/640caa922a1ec46270345803d2f49450 to your computer and use it in GitHub Desktop.
Save 3v0k4/640caa922a1ec46270345803d2f49450 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select_id_films_id_films_title_films_genre_count_from_films_left_join_reviews_group_by_films.id.sql
=> SELECT films.id, films.title, films.genre, count(*) as number_of_reviews FROM films LEFT JOIN reviews ON films.id = reviews.film_id GROUP BY films.id;
id | title | genre | number_of_reviews
----+-------------------+----------+-------------------
3 | Arrival | scifi | 1
1 | Blade Runner 2049 | thriller | 3
2 | Inception | thriller | 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment