Nested Subqueries

SELECT Count(Unique PolicyNum)

FROM PolicyPlan

WHERE PlanCode = ‘45’ and PolicyNum IN

(SELECT PolicyNum

FROM Commission

WHERE AgentNum IN

(SELECT AgentNum

FROM Agent

WHERE Area = 100))

Determine the number of policies sold in area 100 of type 45:

Previous slide

Next slide

Back to first slide

View graphic version