Optum Interview Question

SQL basic Q from interviewer