Skip to content

Instantly share code, notes, and snippets.

@3v0k4

3v0k4/select_title_genre_count_from_films_group_by_title_genre.sql

Last active December 21, 2019 00:01
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save 3v0k4/794b67aec6b79a099a82a9ab6a19da96 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save 3v0k4/794b67aec6b79a099a82a9ab6a19da96 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select_title_genre_count_from_films_group_by_title_genre.sql
=> SELECT title, genre, count(*) FROM films GROUP BY title, genre;
title | genre | count
-------------------+----------+-------
Blade Runner 2049 | thriller | 1
Inception | thriller | 1
Arrival | scifi | 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment