What is the name of the person that has the highest number of nominated award but didn't win?
nominated refers to result = 'Nominee'; highest number of nominated award refers to Max(Count(person))
SELECT person FROM Award WHERE result = 'Nominee' GROUP BY person ORDER BY COUNT(person) DESC LIMIT 1;