Observe the HAPPY INSURANCE DATABASE:

Happy Insurance ER Diagram

Happy Insurance Relational Schema

Happy Insurance Data

CLIENT

ClientID ClientName AgentID ClientSpouseName ClientIncome

C$111$ Tom A$1$ Jenny $102,000$

C$222$ Karin A$1$ Bill $105,000$

C$333$ Cole A$2$ Amy $80,000$

C$444$ Dorothy A$290,000$

C$555$ Andy A$3$ Amy $70,000$

C$666$ Tina A$4$ Matt $180,000$

C$777$ Christina A$5$ Mike $200,000$

AGENT

AgentID AgentName AgentArea AgentRating AgentYearOfHire SupervisedBy AgentSalary

A$1$ Kate $11011990102,000$

A$2$ Amy $2922009$ A$1100,000$

A$3$ Luke $21001992101,000$

A$4$ James $3902010$ A$390,000$

A$5$ Salcedo $31002018$ A$180,000$

AREA

AreaID AreaName AreaHQ

$1$ East Boston

$2$ West San Francisco

$3$ Central Chicago

$4$ South Memphis

The result of FULL OUTER JOIN between tables AGENT $($on the left$)$ and AREA $($on the right$)$ in will contain:

$3$ rows of data

$4$ rows of data

$5$ rows of data

$6$ rows of data

$9$ rows of data