Note the use of the SELECT statement within the aggregate operation AVG. In
this statement, the iterator variable p iterates over the partition collection (of type
bag). The path expression p.s.salary is used to access the salary of
each sales staff member in the partition