Write an SQL query for the HAPPY INSURANCE database that will for each area display the area ID and the number of agents in the area.

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:

CLIENT

ClientID ClientName ClientAgent ClientSpouseName

C111 Tom A1 Jenny

C222 Karin A1 Bill

C333 Cole A2 Amy

C444 Dorothy A2

C555 Andy A3 Amy

C666 Tina A3 Matt

C777 Christina A4 Mike

AGENT

AgentID AgentName AgentArea AgentRating AgentYearOfHire SupervisedBy

A1 Kate 1 101 1990

A2 Amy 2 92 2009 A1

A3 Luke 3 100 1992

A4 James 3 90 2010 A3

AREA

AreaID AreaName AreaHQ

1 East Boston

2 West San Francisco

3 Central Chicago

A. SELECT agentarea, COUNT(*)

FROM agent

GROUP BY agentarea;

B. SELECT agentarea, COUNT

FROM agent

GROUP BY agentarea;

C. SELECT agent, COUNT(*)

FROM agent

GROUP BY agentarea;

D. SELECT agentarea, COUNT(*)

FROM agent

GROUP BY agent;