Elation Health interview question

Interviewer asked several SQL optimization questions that were DBMS-specific