GE HealthCare Interview Question

Query those tables. Write the sql.