I have a table below:
How can I query to get who appeared most of the times in the table? (In the case, the answer is John.)
Try select count(*) from t1 group by name.
And...are you supposed to be doing this for your homework? :)