SELECT count(*) ,  formats FROM files GROUP BY formats
How many songs were released for each format?
SELECT count ( * ) , formats FROM files GROUP BY formats
select count ( * ) , formats from files group by formats
How many songs were released for each format ?