daVIZta interview question

ER model, SQL joins , subqueries