CODE EXAMPLE FOR SQL

mysql find most common value

SELECT column, COUNT(*) AS magnitude 
FROM table 
GROUP BY column 
ORDER BY magnitude DESC
LIMIT 1