eClinicalWorks interview question

SQL tables joins and performance tuning related