SELECT Status FROM city GROUP BY Status ORDER BY COUNT(*) DESC LIMIT 1
What is the most common status across all cities?
SELECT Status FROM city GROUP BY Status ORDER BY COUNT ( * ) DESC LIMIT 1
select status from city group by status order by count ( * ) desc limit value
What is the most common status across all cities ?