Unnamed

mysql> select id, type, count(type) from kv group by id, type;
+----+------+-------------+
| id | type | count(type) |
+----+------+-------------+
|  1 |    1 |           1 |
|  1 |    2 |           2 |
|  1 |    3 |           1 |
|  1 |    5 |           3 |
|  2 |    1 |           1 |
|  2 |    2 |           2 |
|  2 |    3 |           1 |
+----+------+-------------+