update-sequencia-with-group-by.sql

update table1 t1
set "order" = t2.seq
from (
	select id, row_number () over (partition by target_id order by created_at) as seq
	from table2
) as t2
where t1.id = t2.id