NAME_TYPE
name surname type
John Doe C
John Doe B
Jack Daniels D
Will Smith C
Brad Pitt A
George Dumb E

and I want to display all types that don't belong for some person.
For example if person is George Dumb, i want query to return result:
A
B
C
D
or if person is John Doe, query result need to be:
A
D
E

Anyone know how should I do that, please?