1. Display the employee last name, salary, job title and manager# of all

employees WITHOUT manager OR if they work in MARKETING department (here you will NOT use join clause use wild cards for the job title), but only if their total monthly salary with $1000 included bonus and commission (if earned) is greater than $10,000.

Lets assume that all employees received this monthly bonus only once. If an employee does not have a manager, then display message No Manager instead. This column should have an alias Manager#.

Display the Total annual salary as well in the form of $135,600 with the heading Total Income. (do NOT include the Bonus discussed above).Sort the result so that best paid employees are shown first.