PowerSchool Group interview question

Complete based on SQL queries .