PowerSchool Group interview question

Basic database questions using LIKE, Max, Having, and Distinct.