Cornerstone OnDemand Interview Question

query and relation between two tables