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