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

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 still listed in the output. You should use Staff2 and Branch table and the output column name should be (city, count).

Staff2

SQL Create a view listing the city and the number of female

Branch

staff who has salary higher than 15000 working in the city. If

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

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 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 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 project city not at London and the project doesnt have any staff. You should use Project and Working table and the output header should be (Project_name,city) Project...

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

2. (10 pts) Create a view vHW1_2_xxxx listing the first name, last name and salary for staff who has last name ending with 'e'. The output should be alphabetically ordered from high to low by the...

Qustion1. identify what job from duplex copiers you would use for "key job matching". Make the choice from the jobs included in the job evaluation outcomes spreadsheet you have been provided. You...

Assignment Questions -Many municipalities and public agencies ask developers to include diversity and inclusion plans in their construction bids. What is unique about Massports approach? -Who...

OB Team project Case Study 10[1] - Protected View . Saved v Search sign Layout References Mailings Review View Help rom the Internet can contain viruses. Unless you need to edit, it's safer to stay...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Explain the MARS model of individual behaviour. (30 marks) Ken is a fresh graduate who has joined an automobile company as a salesperson. He is highly motivated and enthusiastic and understands his...

What is the basic form of a worksheet?

Which of the following values in a permanent life insurance policy is changed when the policy s owner uses the non - forfeiture option to convert the policy to extended term insurance? The death...

Nuclei with an imbalance of neutrons and protons are considered: a ) Stable b ) Isotopes c ) Radioactive d ) Fissionable

How do Data Types perform data validation?

How does Referential Integrity work?

What are Dimensional Relational Databases designed to hold primarily?