1a)Write a query using the HumanResources.Emploee and Person.Contact table showi

Question

1a)Write a query using the HumanResources.Emploee and Person.Contact table showing the EmploeeID, Title, FirstName and LastName. Label the Title as JobTitle. (ALL QUERIES USE THE ADVENTUREWORKS DATABASE ON THE REMOTE ELMHURST COLLEGE SQL SEREVER DATA BASE AT 192.217.84.36)

1b) Modify (1a) to include the employee's address and limit the result set to only those employee's country region code of "US".(ALL QUERIES USE THE ADVENTUREWORKS DATABASE ON THE REMOTE ELMHURST COLLEGE SQL SEREVER DATA BASE AT 192.217.84.36)

Explanation / Answer

/*BY assuming that HumanResources.Emploee table has a colomn personID Which maps personID of Person.Contact table , and By assuming that HumanResources.Emploee table has a colomn countryregioncode which is a country region code of employee. **If Required more help Please write to me With full details. */ ANS 1a) SELECT emp.EmploeeID , emp.Title AS JobTitle, emp.FirstName , emp.LastName , emp.Label , con.address FROM HumanResources.Emploee AS emp INNER JOIN Person.Contact AS con ON emp.personID = con.personID; ANS 1b) SELECT emp.EmploeeID , emp.Title AS JobTitle, emp.FirstName , emp.LastName , emp.Label , con.address FROM HumanResources.Emploee AS emp INNER JOIN Person.Contact AS con ON emp.EmploeeID = con.EmploeeID WHERE emp.countryregioncode='US';

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.