Optum interview question

SQL basic Q from interviewer