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

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:

SQL Create a view listing the city that has only one male

Branch:

staff working in the city. You should use Staff2 and Branch table

| 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 | branchNo | street | city | postcode | + | B002 | 56 Cover Drive | London | NW10 6EUL | B003 | 163 Main Street | Glasgow | Gli 90X | B004 | 32 Manse Road | Bristol | BS99 INZ | B005 | 22 Deer Road | London | Swi 4EH | B007 | 16 Argyll Street | Aberdeen | AB2 3SU

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!

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

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

Staff2 Branch Pls can you give steps and screenshot on how to do it. I want to learn from it 12. (10 pts) Create a view vHW1_#_xxxx listing all the cities and the male staff names working there. Ifa...

Staff 2 Table Branch Table 12. (10 pts) Create a view vHW1_#_xxxx listing all the cities and the male staff names working there. Ifa city does not have any staff, that city should be still in the...

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

junior Sayou, a financial analyst for Chargers Products, a manufacturer of stadium benches, must evaluate the risk and return of two assets, X and Y. The firm is considering adding these assets to...

What is the interpretation of the Y intercept and the slope in the simple linear regression equation?

10.66 Group Project: The class should be divided into pairs of students for this project. Suppose it is conjectured that at least 25% of students at your university exercise for more than two hours a...

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

7. A minimum level of contact between the mentor and protg is specified. Mentors and protgs need to determine the mechanics of the relationship: when they will meet, how often, and how they will...

3. Job rotation is used for all levels and types of employees.

2. Relate how assessment of personality type, work behaviors, and job performance can be used for employee development.