Determine the average total compensation, including salaries and bonuses, for employees categorized by their job titles and gender. To calculate total compensation, sum the salaries and bonuses for employees who receive bonuses. Do consider that some employees might receive multiple bonuses.

The output should include employee titles, gender $($referred to as "sex"$),$ and the average compensation. It should be in increasing order of average total compensation

Tables Schema as Below:

Employees

columnName dataType

id INT

first$\_$name VARCHAR$(50)$

last$\_$name VARCHAR$(50)$

age INT

sex CHAR$(1)$

employee$\_$title VARCHAR$(50)$

department VARCHAR$(50)$

salary DECIMAL$(10,2)$

target INT

email VARCHAR$(100)$

city VARCHAR$(50)$

address VARCHAR$(100)$

manager$\_$id INT

Bonuses

columnName dataType

worker$\_$ref$\_$id INT

bonus DECIMAL$(10,2)$

Output