Invitation to Computer Science 8th Edition

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

Chapter 14 - Exercises - Page 708: 6

Answer

$171$ $B2$ $171$ $C1$

Work Step by Step

The first query, SELECT ID, PlanType, retrieves and produces the ID and PlanType. The second query, FROM Employees, InsurancePolicies, retrieves the information for ID and PlanType from the Employees and InsurancePolicies tables. The third query, WHERE Birthdate $\gt$ #1/01/1980#, makes it so that only the information with birthdays before January 1st 1980 is retrieved. The 4th line, AND ID = EmployeeID; is a continuation of the third query, and restricts the retrieved information to only be that in which the ID is EmployeeID. As a result, $171$ $B2$ $171$ $C1$ is displayed.
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.