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

SELECT DISTINCT clientname

FROM client

WHERE clientspousename $=$ 'Amy';

A$.$

Name Amy twice

B$.$

Name Amy

C$.$

Name Cole

D$.$

Names Andy and Cole