I have a table below:

Table
Name id
John 40
Mary 50
Peter 15
John 40
Peter 15
John 40

How can I query in SQL to get who appear most of the times in the table?
(in the case, the answer is John)

please help me¡Kthanks

My email address is
l.liou@student.unsw.edu.au
lunchih@hotmail.com

thanks a lot
primer in Oracle