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

Let the shortest duration as bar chart's X-axis and the most poorly rated song for each genre as the Y, show in asc by the 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) ORDER BY MIN(T1.duration)
SELECT MIN("T1"."duration"), MIN("T2"."rating") FROM "files" "T1" JOIN "song" "T2" ON "T1"."f_id" = "T2"."f_id" GROUP BY MIN("T1"."duration") ORDER BY MIN("T1"."duration")