PowerSchool Group Interview Question

Complete based on SQL queries .