PointClickCare interview question

Write SQL query based on Database diagrams provided and create an SSIS package