Scalar interview question

Some questions on SQL which need to be solved by sharing the screen?