eClinicalWorks Interview Question

Optimize the SQL join Query for better performance.