Intermountain Health interview question

1- Write a SQL query on the board.