HealthEdge Software Interview Question

System design, project related, SQL query