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

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

SQL Create a view listing the project city not at London and

Working Table:

the project doesnt have any staff. You should use Project and Working

| pcode | name | city 1 +- -+- | POI University | Union | PO2 | Citi Bank | NYC | P03 | British Museum | London | PO4 | Buckingham Palace | London | | P05 | Granite | | Aberdeen | --+ 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!

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

Language SQL I need help with this question. Create a view vHW1_6_xxxx listing the city that has only one female staff working in the city. Your out header should be (city, count). So far i have...

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

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

Fayol believed that every department of the organisation should be working on the same plan to achieve the organisation's objectives. He expressed this in which principle of management? A B Unity of...

List the more important rules of sound budgeting.

Which of the following is NOT an advantage of budgeting? It provides a standard for performunce evaluation. It suarantees an improvement in organirational effciency. It forces managers to plan. It...

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

Question Can plan participants borrow from a VEBA?

Question What is an educational benefit trust and how is it used?

Question How are VEBA assets allocated when a plan terminates?