I was working through this exercise in the Analyze Data with SQL skill path.
Step 5 asked me to:
Create a list of countries and their number of LoL viewers using
I had no problem doing that, however, I wanted to take things a little bit further and show a list of the number of viewers of each game, per country. Something like, in the US there are 400 LoL viewers and 200 Agar.io viewers, while in Mexico there are 200 LoL viewers and 50 Agar.io viewers, etc.
And…I feel like I’m having a breakdown. I tried to solve a similar problem before, and couldn’t find a way to solve it. Now here I am again, and still don’t have a clue of how to achieve what I want. And I feel like it’s such an easy thing. It’s a terrible feeling, like, if you gave me the solution I’d probably understand it, but when I try to find a way to solve it, my brain goes completely blank.
I didn’t want to ask for help because finding the solution myself is something that would’ve made me really happy.
But I’ve been stuck with this problem literally for hours…so…
I would really appreciate if someone could help me find a way to achieve my desired result