By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | name | row |
|---|---|---|
| 1 | John | 1 |
| 1 | John | 2 |
| 2 | Mary | 1 |
| 3 | Jeff | 1 |
| 4 | Bill | 1 |
| 4 | Bill | 2 |
| 4 | Bill | 3 |
| 4 | Billy | 4 |
| 5 | Bobby | 1 |
| 5 | Bob | 2 |
| 5 | Bob | 3 |
| 5 | Bob | 4 |
| id | name | count |
|---|---|---|
| 1 | John | 2 |
| 2 | Mary | 1 |
| 3 | Jeff | 1 |
| 4 | Bill | 4 |
| 5 | Bobby | 4 |