Microsoft interview question

SQL query, Select * related question