HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT AGENT AREA

question 59

Multiple Choice

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Matt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$
This database will be used for the following questions citing tables from the HAPPY INSURANCE database.


-How many records will be retrieved by the following query on table AGENT?
SELECT a.agentname,s.agentname
FROM agent a,agent s
WHERE a.supervisedby = s.agentid;

• A)0
• B)1
• C)2
• D)4

---

Definitions:

Diego Rivera

A prominent Mexican painter and muralist, known for his large frescoes that helped establish the Mexican Mural Movement.

Depression-Era Artist

An artist active during the Great Depression who often depicted the struggles, socioeconomic challenges, and resilience of people during that period.

Ben Shahn

An American artist of Lithuanian Jewish descent, known for his works of social realism and left-wing political views.

Massachusetts

A state in the northeastern United States, known for its significant historical sites related to the early colonization of America.