Yup, I was going to say that it was missing the GROUP BY clause as well.

Both solutions work, but I'm going with Luiz's as it's very simple, and since I don't care which email address I get, I don't need to prioritize.

Thanks guys!