Check out example codes for "how to find the most occuring in SQL". It will help you in understanding the concepts better.

Code Example 1

SELECT       `column`,
             COUNT(`column`) AS `value_occurrence` 
    FROM     `my_table`
    GROUP BY `column`
    ORDER BY `value_occurrence` DESC
    LIMIT    1;

Learn ReactJs, React Native from akashmittal.com