FDM Group interview question

Basic SQL question regarding SELECT statement