You know, you can just write GROUP BY x, y, ...

    SELECT t.i+1, count(*) FROM table t GROUP BY 1

1 in this context means the first selected item (i.e. t.i+1). I know this works in PostgreSQL.