Kaiser Permanente interview question

Given a table write SQL query that retrieves certain information.