i have a database on a checklist of videogames and i'm trying to run a query to show me how many games from each publisher i have but i'm having a problem, it'll only show each publisher once but it won't count any of the yes and no it just counts the total of how many times the publisher shows up in the row so instead of being
it'll return the results as5/10 Ubisoft
8/13 EA
2/5 Activision
on top of this i have another question that i want to know if it's possible to expand/shrink in each publisher result so for example if it was correctly displaying the way i want it above it'd be like this10 Ubisoft
13 EA
5 Activision
5/10 ubisoft-yes prince of persia 1
-yes prince of persia 2
-no prince of persia 3
-no assassin's creed 5
-yes assassin's creed 6
-no assassin's creed 7
-no ghost recon 4
-no ghost recon 5
-yes ghost recon 6
-yes ghost recon 7