Optum interview question

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