I need to find what topics the user has the most entries in.
select msg_author, msg_topic from messages where msg_author = 'mary';
msg_author msg_topic
mary diet
mary diet
mary exercise
mary recipes
mary recipes
mary recipes
mary recipes
mary yoga
mary yoga
So obviously, Mary's most popular topic is "recipes".
1) How could I write a query that would pull her most used msg_topic?
2) If 2, or 3 msg_topics are equal, I would like all of the topics to display.