Question: SQL Create a listing the project name, staff name and the staffs branch city for the same staff who working on the same project more

SQL

Create a listing the project name, staff name and the staffs branch city for the same staff who working on the same project more than one time. You should use Project, Staff2, Branch, and Working tables. The output column header should be (Project_name, Staff_name, Branch_city). The staff_name should combine fname and lname with a space in between.

Project:

SQL Create a listing the project name, staff name and the staffs

Staff2:

branch city for the same staff who working on the same project

Branch:

more than one time. You should use Project, Staff2, Branch, and Working

Working:

tables. The output column header should be (Project_name, Staff_name, Branch_city). The staff_name

| pcode | name | city 1 +- -+- | POI University | Union | PO2 | Citi Bank | NYC | P03 | British Museum | London | PO4 | Buckingham Palace | London | | P05 | Granite | | Aberdeen | --+ | 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 pcode | staffNo 1 year | POI | POI POI PO2 PO2 | PO2 PO2 PO3 PO3 PO3 PO3 | P03 | ABC1 | ABCl | SG5 | XY1 | SG5 | SG5 | SL21 | ABCI | SG37 | SG14 | cci | ccl | 1980 | | 2010 | | 2000 | | 2014 | | 2002 | | 2018 | | 2006 | | 1995 | 1995 | 2003 | | 1990 | | 2019 | -+

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!

Staff2 Branch Working Project Pls can you give steps and screenshot on how to do it. I want to learn from it 13. (10 pts) Create a view vHW1_#_xxxx listing the project name, staff name and the...

Staff 2 Branch Working Project 13. (10 pts) Create a view vHW1_#_xxxx listing the project name, staff name and the staff's branch city for the same staff who working on the same project more than one...

Development of bridge between City 1 and City 2 Business Needs: This was crucial that the connectivity between cities 1 and 2 improve due to the introduction of new commercial prospects. As a result,...

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

DATABASE | PLEASE NEED YOUR OWN ANSWER! DO NOT PROVIDE ME COPIED OR OTHER PEOPLE ASNWER...THANKS Creation of tables: CREATE TABLE place( PLACEID INT PRIMARY KEY, CITY VARCHAR(30), COUNTRY CHAR(2) );...

DATABASE: Creation of tables: CREATE TABLE place( PLACEID INT PRIMARY KEY, CITY VARCHAR(30), COUNTRY CHAR(2) ); CREATE TABLE staff( STAFFID INT PRIMARY KEY, FNAME VARCHAR(30), LNAME VARCHAR(30),...

Worksheet Query Builder select * from staff Worksheet Query Builder select * from place 1 1 2 3 Script Output Query Result SQL | All Rows Fetched: 11 in 0.003 seconds STAFFID FNAME 1 LNAME SALARY 95...

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

Please ,Carefully read the case study &Answer the following Discuss the significance of HRM practices in Pharmaceutical companies. How HRM practices helps in improving other industries. Please kindly...

Determine whether each of the following is primarily a microeconomic or a macroeconomic issue: a. What price to charge for an automobile b. Measuring the impact of tax policies on total consumer...

The following polypeptide was treated with 2-mercaptoethanol and then with iodoacetic acid. After reacting with maleic anhydride, the peptide was hydrolyzed by trypsin. (Treatment with maleic...

Research indicates that diversified closed - end stock funds trading at a discount tend to outperform those trading at a premium and the average open - end mutual fund. True False

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

1. Explain why evaluation is important.

6. Go to www.buckman.com, the Web site for Buckman Laboratories. Buckman Laboratories works with industries worldwide, providing advanced chemical treatment technologies and extensive technical...

4. Develop specific recommendations that the instructor could use to make this class a learning organization.