Optum Interview Question

Example of SQL queries, what did they do, how could they be optimized