I have a SQL table with two columns like this with about 130k rows. (9k unique users, 7500 unique skills)
User | Skill |
---|---|
A | 1 |
A | 2 |
B | 3 |
C | 1 |
I’m trying to understand (and possibly visualize) the number of users who share the same skills sets. I don’t know which skills overlap today.
I want some output of Group A {Skills: 1 & 2 & 7} has 10 people
I want some output of Group B {Skills: 10 & 95} has 19 people, etc…
Thanks for your help.
I’m at a loss of where to begin here.
New contributor