如何在MySQL表的列中找到最常见的结果

SELECT column_name, COUNT(*) AS count
FROM table_name
GROUP BY column_name
ORDER BY count DESC
LIMIT 1;

SELECT gender, COUNT(*) AS count
FROM users
GROUP BY gender
ORDER BY count DESC
LIMIT 1;