mysql> update ssc set score =score*1.05 where score<(select avg(score)from ssc);
1093 - You can't specify target table 'ssc' for update in FROM clause