DataCare interview question

SQL - basic update/insert/delete statements with joins