How many songs were released for each format?
SELECT count(*) ,  formats FROM files GROUP BY formats
count of songs for each format refers to COUNT(*) GROUP BY formats; songs released refers to count of records in files;}