Question: SQL Create a view listing the male staffs name, salary who has salary higher than all female. You should use Staff2 table and the output

SQL

Create a view listing the male staffs name, salary who has salary higher than all female. You should use Staff2 table and the output header should be (name, salary) where name is combined by fname and lname, with a space in between.

SQL Create a view listing the male staffs name, salary who has

| staffNo | fName | iName | position sex | DOB | salary | branchNo | superno | ABCi | CCI | SAS | SG14 | SG37 | SG5 | SL21 | SL41 | XY1 | New | Enginer | Intern IM | Super | User | DBA IM | Mary | Howe | Assistant | IF | David | Ford | Supervisor | M | Ann | Beech | Assistant | F | Susan | Brand | Manager | F | John | White | Manager | M | Julie | Lee | Assistant | F | New | Tester | Assistant | 2000-01-01 | 9000.00 | B002 | 1995-01-01 | 90000.00 | B005 | 1970-02-19 | 9000.00 | B007 | 1958-03-24 | 18000.00 | B003 | 1960-11-10 | 12000.00 | B003 | 1940-06-03 | 24000.00 | B003 | 1945-10-01 | 30000.00 | B005 | 1965-06-13 | 9000.00 | B005 | 1990-01-01 | 8000.00 | B002 | SL21 | SG14 | SG5 | SGS | SG5 | SL21 | NULL | SL21 | SL21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

QUESTION 6 - Please answer (a) and (b) separately Ace Construction Company ("A") mails a "request for bid" to Baker Steel Fabrication Company ("B"). The request asks for bids for providing steel for...

SQL Create a view listing the staffs fname and salary for whom has higher salary than their managers. You should use Staff2 table and the output column name should be (E_fName, E_salary, M_fName,...

in mysql listing the male staffs name, salary who has salary higher than all female. should use Staff table showed above and the output header should be (name, salary) where name is combined by fname...

D. Please implement your answers in the database CPS3740_2019S on imc.qqqq.edu server. E. You have to refer to tables Staff, Hotel, Room, Booking, Guest in database CPS3740 on imc.qqqq.edu server. F....

SQL Create a view listing all the branch location and female staff information that branch is not in Aberdeen or London and female staffs age is older than 35. You should use Branch and Staff2 tables...

SQL Create a view listing the lowest salary for each gender. You must use UNION operation and Staff 2 table. The output column name should be (gender, name, age, salary). The name should be combined...

SQL Create a view listing the city and the number of female staff who has salary higher than 15000 working in the city. If the city doesnt have any working staff meet the criteria, the city should be...

SQL Create a view listing all the cities and the male staff names working there. If a city does not have any staff, that city should be still in the output. You should use Staff2 and Branch table and...

SQL Create a view listing the incorrect record in the Working table that staff has project year before their birthday. You should use Staff2, Project and Working tables. You need to figure out how to...

SQL Create a view listing the city that has only one male staff working in the city. You should use Staff2 and Branch table and the output column name should be (city, count). Staff2: Branch: |...

Question: listing the first name, position and their manage first names and positions for all male staff who work at London. The output header needs to distinguish between staff and manger. You...

(a) Show that the nucleus 8/4Be (mass = 8.005305u) is unstable and will decay into two particle (b) Is 12/6C stable against decay into three particles? Show why or why not.

What is the DCR for year one (NOI/DS)? What is the Cash-on-Cash Return for year one (BTCF/Initial Equity Investment)? Discounted Cash Flow What is the NOI for year 3? What is the Unleveraged IRR and...

Not every consumer is in the market for a mortgage. Life choices or financial issues may cause one to remain in the role of a "renter". When considering a home purchase there are many financial...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

LO3 Discuss the steps of a typical selection process.

5. Your small home health care service company of about 50 workers has traditionally recruited employees using newspaper print advertisements. Applications have been decreasing from these ads, so you...

4. Social sourcing and corporate talent networks help companies connect with potential employees in real time through viral communities. Promoting an employment brand will be more important in these...