Mysql – Find the genres that have at least 2 same directors, then print common genres and director id?
The dataset is like this: g1 = {d1,d3,d5} g2 = {d1,d3,d2} g3 = {d4,d3,d5} I have the following table called director_genre: director_id | genre d1 g1 d1 g2 d2 g2 d3 g1 d3 g2 d3 g3 d4 g3 d5 g1…