Warner Bros. interview question

SQL join, update, insert into statement