SQL query to retrieve all employees in descending order of total bonus plus commission

,

I have a table EMPLOYEE with these fields:

    empno, firstnme, midinit, lastname, workdept, phoneno, hiredate, job, edlevel, sex, birthdate, salary, bonus, comm.

Do you know how to create an SQL query to retrieve all employees from the john.employee table in descending order of total bonus plus commission (BONUS and COMM a开发者_StackOverflow中文版ttributes).

Thank you!

This isn't an olap question, this is a simple SQL statement.

SELECT   ...
FROM     employee
ORDER BY bonus+comm DESC