Invitation to Computer Science 8th Edition

Published by Cengage Learning
ISBN 10: 1337561916
ISBN 13: 978-1-33756-191-4

Chapter 14 - 14.3 - Databases - Practice Problems - Page 698: 3

Answer

SELECT LastName, FirstName, MonthlyCost FROM Employees, InsurancePlans, InsurancePolicies WHERE LastName = "Takasano" AND ID = EmployeeID AND InsurancePolicies.PlanType = $\quad$InsurancePlans.PlanType;

Work Step by Step

SELECT LastName, FirstName, MonthlyCost FROM Employees, InsurancePlans, InsurancePolicies WHERE LastName = "Takasano" AND ID = EmployeeID AND InsurancePolicies.PlanType = $\quad$InsurancePlans.PlanType;
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.