Question: 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

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 fname and lname, with a space in between. The output should be female first and then male.

Staff2

SQL Create a view listing the lowest salary for each gender. You

| 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!

in mysql 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 fname and...

Question: 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, M_salary)....

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 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 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 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 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: |...

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,...

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...

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...

How is goodwill derived from a merger and acquisition transaction?

You are a CPA and a new client who is starting a small retail business with four other investors. The new client is convinced that an S corporation is the best choice because a friend who is not a...

What is the coupon payment of a 2 5 - year $ 1 0 , 0 0 0 bond with a 1 0 % coupon rate with semiannual payments? A . $ 1 , 0 0 0 B . $ 5 0 0 C . $ 2 , 0 0 0 D . $ 1 6 6 . 6 7

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...

2. Buy 2, get 1 free. Explain why the 1 free is free to the buyer but not to society. LO1

7. Suppose you won $15 on a lotto ticket at the local 7-Eleven and decided to spend all the winnings on candy bars and bags of peanuts. The price of candy bars is $.75 and the price of peanuts is...

8. What are economic resources? What categories do economists use to classify them? Why are resources also called factors of production? Why are they called inputs? LO4