FDM Group Interview Question

Basic SQL question regarding SELECT statement