CREATE TABLE files (f_id DECIMAL, artist_name VARCHAR, file_size VARCHAR, duration VARCHAR, formats VARCHAR)
CREATE TABLE artist (artist_name VARCHAR, country VARCHAR, gender VARCHAR, preferred_genre 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)

Let the shortest duration as bar chart's X-axis and the most poorly rated song for each genre as the Y.
SELECT MIN(T1.duration), MIN(T2.rating) FROM files AS T1 JOIN song AS T2 ON T1.f_id = T2.f_id GROUP BY MIN(T1.duration)
SELECT MIN("T1"."duration"), MIN("T2"."rating") FROM "files" AS "T1" JOIN "song" AS "T2" ON "T1"."f_id" = "T2"."f_id" GROUP BY MIN("T1"."duration")