PointClickCare Interview Question

SQL technical question from leetcode.