Question

Hi I need help creating an SQL query to display each faculty member's last name, comma, first name as a CONCATenated element, then their salary as CONCATenated element with a dollar sign and comma. Then, the boss's last name, comma, first name as a CONCATenated element, then the boss's salary as CONCATenated element with a dollar sign and comma. Finally I need to use and INNER JOIN to gather the data. Restrict the rows where the faculty member's salary is greater than their boss's salary. Order the output by the faculty member's salary in descending order.