Question
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
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;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started