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
Rich Kramp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.