Optum Interview Question

Then he asked me to write an SQL query.