Database Design (SQL)

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.

  1. 👍 0
  2. 👎 0
  3. 👁 174

Respond to this Question

First Name

Your Response

Similar Questions

  1. stats

    Which of the following variables for data about a track team is a discrete variable? C would be the discrete variable?? The height of a team member A The weight of a team member B The number of times that a team member finished

  2. KIPP Believe

    The student-to-faculty ratio at a small college is 17:3. The total of students and faculty is 740. How many faculty members are there at the college? How many student?

  3. STOR

    Each of the following statements contain a blunder. Explain in each case what is wrong. a) There is a high correlation between the age of American workers and their occupation. b) we found a high correlation (r=1.19) between

  4. Statistics

    A certain organization recommends the use of passwords with the following​ format: consonant comma consonant, consonant comma vowel comma consonant comma vowel comma consonant comma number comma number consonant, vowel,

  1. social studies

    How has the elimination of trade barriers affected the movement of goods among member countries of the European Union? A. Member countries are able to produce all the goods they need. B. Goods can move freely among member

  2. algebra2

    you are creating a window display at a toy store using wooden blocks. the display involves stacking blocks in triangular forms. you begin to display with 1 block, which is your first "triangle," and then stack three blocks, two on

  3. Business Management

    What kinds of queries would be useful to Woodcraft, assuming that it wants to improve its sales, relationship with its customers, or other aspects of its business? Describe what information you might want to select from the

  4. SQL

    Display a list of all instructors, showing their ID, name, and the number of sections that they have taught. Make sure to show the number of sections as 0 for instructors who have not taught any section. Your query should use an

  1. mathematics

    Find the domain and range of the relation and determine whether it is a function. A graph with four points plotted is shown. The points are located at left parenthesis negative 4 comma negative 1 right parenthesis, left

  2. grammar

    2. The patient was brought to the operating room, general endotracheal anesthesia was induced by the anesthesia service. which of the following is true for the above sentence a. This is a comma splice that can be fixed by removing

  3. social studies

    How has the elimination of trade barriers affected the movement of goods among member countries of the European Union? A. Member countries are able to produce all the goods they need. B. Goods can move freely among member

  4. Grammar

    There is a tube overlying the pelvis in the midline, degenerative changes are also noted in the lumbosacral spine. fragment run-on comma splice complete sentence Answer: comma splice (should be a word after the comma.) Thanks -

You can view more similar questions or ask a new question.