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

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 get the year from the birthday. The output column header should be (Project_name, year, Staff_name, birthday). The staff_name should combine fname and lname with a space in between.

Staff2

SQL Create a view listing the incorrect record in the Working table

Project

that staff has project year before their birthday. You should use Staff2,

Working Project and Working tables. You need to figure out how to get

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

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

that is all that was given In this Task you will build a database to support the needs of The Central Hospital, England who are working with local doctors' surgeries to keep accurate data about the...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

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

I am working on my final project in an SQL class using MYSQL. I am working my way through it but it is going slow so I think that I may need a little bit of help to finish in time. If I could get a...

Instructions: two written paragraphs for each numbered question, 10 sentences per paragraph. providing good support from Chapter 6 helps strengthen your answer, opinions are welcomed. 1. what type of...

I need help making the SQL statements in visual studio 2017 Please read homework carefully svxGS0201 9 1 0/Project%20Task%2075628 1 %29.pdf MGMT 329: Database Management Project Task 7: Requi The...

K+ channels have openings that are much wider than Na+ ions, yet sodium ions cannot pass through efficiently. Explain.

Marin Entertainment completed the following transactions during December of the current year. The company records unearned items initially as revenue. The company uses the accounts Gift Cards...

13. What is the profit equation?

A 2 . 5 V potential difference is applied between the ends of a 0 . 8 0 - mm - diameter, 9 0 - cm - long nichrome wire. For the steps and strategies involved in solving a similar problem, you may...

Assume that the banking system has total reserves of $100 billion. Assume also that required reserves are 10 percent of checking deposits and that banks hold no excess reserves and households hold no...

As shown in Figure 3, the overall labor-force participation rate of men declined between 1970 and 2000. At the same time, the labor-force participation rate of women increased sharply. This overall...

The Bureau of Labor Statistics announced that in February 2008, of all adult Americans, 145,993,000 were employed, 7,381,000 were unemployed, and 79,436,000 were not in the labor force. Use this...