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

For each file format, return the number of artists who released songs in that format Show bar chart, and order bar from high to low order.
SELECT formats, COUNT(*) FROM files GROUP BY formats ORDER BY formats DESC
SELECT "formats", COUNT(*) FROM "files" GROUP BY "formats" ORDER BY "formats" DESC