Report question

Question: SQL UPDATE with sub-query that references the same table in MySQL