update tables add soso related score and rank columns