Intermountain Health Interview Question

They asked me to write SQL queries for certain scenarios.