How many file formats are supported?
select count ( distinct formats ) from files
How many songs are available in each format?
select formats, count ( * ) from files group by formats
Is MP4 the most popular format?
select formats from files group by formats order by count ( * ) desc limit 1