I have got a table with ID's:

```
Id
===
1
2
2
3
1
2

```

And I want to create a table with two columns like this:

```
Id      COUNT
=============
1      2
2      3
3      1

```

How can I do that?