Cornerstone OnDemand interview question

query and relations between 2 tables