change reports query to group by majors instead of class