GE HealthCare interview question

Query those tables. Write the sql.