Pentana Solutions interview question

SELECT and Update queries on SQL