Optum interview question

Multiple problem statements and asked for the corresponding SQL commands and codes