Microsoft Interview Question

SQL query, Select * related question