The following data samples show a few rows from each table. For the questions th

Question

The following data samples show a few rows from each table. For the questions that follow, assume that each table contains many more rows than are shown here FirstName tName tate 1 John 2 Jane 3 Sue 4 Tim Smith Doe Johnsorn Johnson Boston Boston New York New York MA MA NY NY Employee employerlD employerName employerCi 1 Stark Industries 2 Initech 3 Acme Corporation 4 Wayne Enterprises Los Angeles Newark Los Angeles New York City employerState CA NJ CA NY Employer D employeelD employerlD dateHired 2006-05-09 2005-11-25 EmployeeEmployer

Explanation / Answer

Query:

SELECT Employer.employerName

FROM EmployeeEmployer INNERJOIN Employer on EmployeeEmployer.employeeID = Employer.EmployerID where EmployeeEmployer.employeeID = 416

Expalanation:

This query inner joins the tables EmployeeEmpoyer and employer tables and retrives the results for employeeId =416

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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