sql - mysql count group by having - Stack Overflow
I have this table: Movies (ID, Genre) A movie can have multiple genres, so an ID is not specific to a genre, it is a many to many relationship. I want a query to find the total number of movies ... ... One way would be to use a nested query: SELECT count(...