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 song (song_name VARCHAR2, artist_name VARCHAR2, country VARCHAR2, f_id NUMBER, genre_is VARCHAR2, rating NUMBER, languages VARCHAR2, releasedate DATE, resolution NUMBER)
CREATE TABLE genre (g_name VARCHAR2, rating VARCHAR2, most_popular_in VARCHAR2)

How many songs were released for each format Show bar chart, and order by the formats from low to high.
SELECT formats, COUNT(*) FROM files GROUP BY formats ORDER BY formats
SELECT "formats", COUNT(*) FROM "files" GROUP BY "formats" ORDER BY "formats"