HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT AGENT AREA

question 9

Essay

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 l } \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 { A1 } \\\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.
-Assume a search form for HAPPY INSURANCE database is created where a user can perform the following action:
ENTER AREA ID:
ENTER AREA NAME:
ENTER AREA HQ:
ENTER AgentID:
ENTER AgentName:
ENTER AgentArea:
ENTER AgentRating:
ENTER AgentYearOfHire: 2010 (<--- Entered by the user)
ENTER SupervisedBY: A3 (<--- Entered by the user)
(User clicks on the search button upon entering the values above. )
Write the SQL statement that will be issued on the user's behalf based on this action.

---

Definitions:

Linea Alba

A fibrous structure that runs down the midline of the abdomen, forming the median attachment of the abdominal muscles.

Rectus Abdominis

A long muscle of the abdomen whose contraction results in flexion of the lumbar spine or helps in compressing the abdominal cavity.

External Abdominal Oblique

A muscle located in the lateral part of the abdomen, involved in trunk rotation and lateral flexion.

Transversus Abdominis

A muscle layer of the anterior and lateral abdominal walls which is deep to the internal oblique muscle.