SELECT formats FROM files GROUP BY formats ORDER BY COUNT (*) DESC LIMIT 1
What is the most popular file format?
SELECT formats FROM files GROUP BY formats ORDER BY COUNT ( * ) DESC LIMIT 1
select formats from files group by formats order by count ( * ) desc limit value
What is the most popular file format ?