Nobody to help me solve this problem? Please help!

I forgot to inform you that the table has a ascending non-sequencial column for each ID group. This can help?

CREATE TABLE Problem

(

id...