Lausof Interview Question

Question about a basic SELECT command on PostgreSQL