Cornerstone OnDemand interview question

query and relation between two tables