I have the following table:
+------+------+
|userID|Name |
+------+------+
|1 |sport |
+------+------+
|2 |it |
+------+------+
|3 |game |
+------+------+
|1 |sport |
+------+------+
|1 |game |
+------+------+
|3 |it |
+------+------+
|3 |sport |
+------+------+
|2 |it |
+------+------+
I want to count the total number of records per UserID and if all of those are unique/have the same Name. Example:
- userID 1: sport, sport, game
- userID 2: it, it
- userID 3: game, it, sport
I should get:
- userId 1: 3, False
- userID 2: 2, True
- userID 3: 3, False