Question: This exercise is based on the tables shown in the figure from the Adventure Works2008 database. These tables can be found on the SQL server

This exercise is based on the tables shown in the figure from the Adventure Works2008 database. These tables can be found on the

This exercise is based on the tables shown in the figure from the Adventure Works2008 database. These tables can be found on the SQL server via remote desktop. Department (Huma 9 DepartmentID Name GroupName ModifiedDate EmployeeDepartment History (Hu 9 BusinessEnttyID DepartmentID ShiftID StartDate EndDate ModifiedDate 8 EmployeePay History o Employee (HumanResources) BusinessEntityID Business EntityID RateChangeDate NationalIDNumber Rate LoginID PayFrequency OrganizationNode ModifiedDate OrganizationLevel Job Title BirthDate Marital Status Gender HireDate Please write the SQL statements to answer the following questions. 7. List all employees' NationalIDNumber, Job Title, and HireDate for those who have ever worked in Department 7 (Use a sub-query instead of Join) 1 2 3 4 5 6 7 8 9 10 NationallDNumber 519899904 446466105 14417807 948320468 410742000 750246141 330211482 801758002 754372876 999440576 JobTitle HireDate Vice President of Production 2003-03-07 Production Supervisor - WC60 2002-03-30 Production Technician - WC60 2000-07-31 Production Technician - WC60 2003-02-24 Production Technician - WC60 2003-03-02 Production Technician - WC60 2003-02-05 Production Technician-WC60 2003-01-30 Production Technician-WC60 2003-01-18 Production Technician - WC60 2003-03-20 Production Technician - WC60 2003-03-12

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!

Please write the SQL statements to answer the following questions (provide SQL code for the questions below) using the Table and columns in the above diagram. 4. Show all employees and the department...

This exercise is based on the tables shown in the figure from the Adventure Works2008 database. These tables can be found on the SQL server via remote desktop. Department (Huma 9 DepartmentID Name...

New England Co. predicts that it will use 360,000 gallons of material during the year. The material is expected to cost $5 per gallon. It anticipates that it will cost $72 to place each order. The...

on May 20 of the current year, Tracey sells a building to Judy for 540,000. Traceys basis in the building is 290,000. This area has a real property tax year that ends on June 30. The taxes are...

eBook Today, the one - year U . S . interest rate is 3 percent, while the one - year interest rate in Argentina is 1 1 percent. The spot rate of the Argentine peso ( AP ) is $ 0 . 4 9 . The one -...

E9-13 (Algo) Computing Four Present Value Problems LO 9-7 On January 1 of this year, Shannon Company completed the following transactions (assume a 9% annual interest rate): (FV of $1, PV of $1, FVA...

3. The decline in union representation in the workforce means that employees have a more direct relationship with their employer. Lacking the protection and advocacy provided by a labor union puts...

2. Privacy issues are in the forefront as websites, marketers, and now employers begin to collect data on every move we make. While many people appreciate customized services, they dont approve of...

2. Identify key stakeholders among both formal and informal leaders. Top executives must support an ADR program. Dont ignore the informal leaders, since they can influence the rest of the employees,...