PointClickCare interview question

Given database structure and asked to write queries on that