PLEASE HELP WITH THIS QUESTION THANK YOU

Assume we have two relations: Employee (Name, EID, position-number, salary, salary-increase-percentage, year) and Job (position-number, max-average-increase, year). A position number refers to a position type (e.g., supervisor). We would like to express an assertion that the average salary percentage increase for any given position is not exceeded for a particular year. We assume that employees holding the same position may have different salary percentage increases. The percentage increase reflects the employee's performance in that year. Write an ASSERTION using the CHECK clause which uses subqueries to express this constraint