Report question

Question: MySQL update with sub select