DXC Technology interview question

Views and alias in sql