RBC interview question

Database questions in regards to MS SQL