eClinicalWorks interview question

different sql queries.Like join,normalization.