LP Infotech interview question

Basic SQL question from w3 schools