CREATE TABLE files (f_id DECIMAL, artist_name VARCHAR, file_size VARCHAR, duration VARCHAR, formats VARCHAR)
CREATE TABLE genre (g_name VARCHAR, rating VARCHAR, most_popular_in VARCHAR)
CREATE TABLE song (song_name VARCHAR, artist_name VARCHAR, country VARCHAR, f_id DECIMAL, genre_is VARCHAR, rating DECIMAL, languages VARCHAR, releasedate DATE, resolution DECIMAL)
CREATE TABLE artist (artist_name VARCHAR, country VARCHAR, gender VARCHAR, preferred_genre VARCHAR)

A bar chart about how many songs were released for each format?, and could you rank by the x axis from high to low?
SELECT formats, COUNT(*) FROM files GROUP BY formats ORDER BY formats DESC
SELECT "formats", COUNT(*) FROM "files" GROUP BY "formats" ORDER BY "formats" DESC NULLS LAST