I have one table:

| ID | Account |
| --- | --- |
| 1 | 22 |
| 1 | 22 |
| 2 | 44 |
| 3 | 22 |

So lots of duplicates as you can see. I need to basically write a query that does 2 things:

1. Matches the separate IDs with linked accounts -- so 1, 3 are 22
2. Counts the number of times they link -- so in the case above, twice.

Edit:

My desired result is the number of times Account 22 is linked with an ID and the list of those IDs.