There are two tables with the following fields containing information for employ

Question

There are two tables with the following fields containing information for employees working for Gizmos, Inc.: Employees EmpID - Unique record ID EmployedID - Employee's ID number FirstName - Employee's first name MI - Employee's middle initial LastName - Employee's last name Dept - Employee's department OfficeBuilding - Employee's office building OfficeNumber - Employee's office number CompInventory CompInvID - Unique record ID EmployeeID - Employee's ID number Type - Equipment type (computer, printer, etc.) Manufacturer - Manufacturer of the equipment SerialNo - Serial number MAC - Mac address, if applicable PurDate - Date of purchase IssDate - Date of issue List all employees whose type of computer is a laptop. List all employees who have printers from Hewlett Packard. List all employees in Accounting who have a desktop computer. List all employees who are in the Marshall building and have a scanner. List all the desktops and laptops in inventory along with the employee using the equipment, if any.

Explanation / Answer

a.

Select E.* from Employees E inner join CompInventory CI on E.EmployeeID = CI.EmployeeID where CI.Type = 'laptop';

b.

Select E.* from Employees E inner join CompInventory CI on E.EmployeeID = CI.EmployeeID where CI.Type = 'printer' and CI.Manufacturer = 'Hewlett Packard';

c.

Select E.* from Employees E inner join CompInventory CI on E.EmployeeID = CI.EmployeeID where CI.Type = 'desktop' and E.Dept = 'Accounting';

d.

Select E.* from Employees E inner join CompInventory CI on E.EmployeeID = CI.EmployeeID where CI.Type = 'scanner' and E.OfficeBuilding = 'Marshall';

e.

Select CI.Type,E.* from Employees E inner join CompInventory CI on E.EmployeeID = CI.EmployeeID where CI.Type = 'desktop' or CI.Type = 'laptop';

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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