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

What will be retrieved by the following query on the table CLIENT?

SELECT DISTINCT clientname

FROM client

WHERE clientspousename $=$ 'Amy';

Name Amy twice

Name Amy once

Name Cole

Names Andy and Cole

Names Andy, Cole, and Amy