Cotiviti interview question

SQL Joins and Sub Queries