Lausof interview question

Question about a basic SELECT command on PostgreSQL