SELECT formats FROM files GROUP BY formats ORDER BY COUNT (*) DESC LIMIT 1
Find the file format that is used by the most files.
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
Find the file format that is used by the most files .