Okay I need to extract records in a table based on it occuring in the table more than 4 times, each time having a different event code.

For example John Smith occurs 5 times with a different event code each time.
Name Code
John Smith emd1
John Smith emd2
John Smith emd3
John Smith emd4
John Smith emd5