DXC Technology interview question

Some technical sql queries they ask