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

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

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 -