Skip to content

Instantly share code, notes, and snippets.

@3v0k4

3v0k4/select_title_genre_count_from_films_group_by_genre.sql

Last active December 21, 2019 00:01
Show Gist options
  • Save 3v0k4/9b79232be06bafb79bd579388dc8bd64 to your computer and use it in GitHub Desktop.
Save 3v0k4/9b79232be06bafb79bd579388dc8bd64 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select_title_genre_count_from_films_group_by_genre.sql
=> SELECT title, genre, count(*) FROM films GROUP BY genre;
ERROR: column "films.title" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT title, genre, count(*) FROM films GROUP BY genre;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment