Intermountain Health interview question

They asked me to write SQL queries for certain scenarios.