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

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 the output column name should (city_name, staff_name). The staff_name should combine fname and lname with a space in between.

Staff2:

SQL Create a view listing all the cities and the male staff

Branch:

names working there. If a city does not have any staff, that

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

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

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

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

Refer to the 2013 annual report of JB Hi-Fi Limited on its website, ww.jbhifi.com.au, and answer the following questions: 1. List the subsidiary companies in the JB Hi-Fi Group. 2. What is the value...

Refer to the 2013 annual report of JB Hi-Fi Limited on its website, ww.jbhifi.com.au, and answer the following questions: 1. What are the different types of revenues generated by the consolidated...

I want to have the individual assignment essay answerddddd For personal use only JB Hi-Fi Limited Annual Report 2013 2013 ANNUAL REPORT jbhifi.com.au CORPORATE INFORMATION ABN 80 093 220 136...

The following are partial income statement account balances taken from the December 31, 2021, year-end trial balance of White and Sons, Inc.: restructuring costs, $320,000; interest revenue, $42,000;...

The geared system shown in Figure represents an elevator system. The motor has inertia I and supplies a torque T1. Neglect the inertias of the gears, and assume that the cable does not slip on the...

Which of the following instruments are traded in the capital markets? Check all that apply. Long - term bank loans Treasury bills Commercial paper Preferred stocks Common stocks A financial...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

LO5 Explain how ethical issues in organizations affect HR management.

1. How did the Water Quality Associations use of technology help enhance how employees acquired important work competencies? Can you think of any other mobile technology applications that might be...

LO6 Explain the key competencies needed by HR professionals and why certification is important.