Count with sub querry in SQL Posted October 2, 2020 I have this table "plays": artist title artist_1 title_1 artist_1 title_1 artist_1 title_2 artist_2 title_1 I want to have something like this: artist title counts artist_1 title_1 2 artist_1 title_2 1 artist_2 title_1 1 I tried some querries wih SELECT DISTINCT and and GROUP BY but did not get what i wanted. Do you have any hint for me? I guess i need a sub querry. Thank you!
Count with sub querry
in SQL
Posted
I tried some querries wih SELECT DISTINCT and and GROUP BY but did not get what i wanted.
Do you have any hint for me? I guess i need a sub querry. Thank you!