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)
CREATE TABLE genre (g_name VARCHAR, rating VARCHAR, most_popular_in VARCHAR)
CREATE TABLE files (f_id DECIMAL, artist_name VARCHAR, file_size VARCHAR, duration VARCHAR, formats VARCHAR)

Let the shortest duration as bar chart's X-axis and the most poorly rated song for each genre as the Y, could you list in asc by the total number?
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(T2.rating)
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("T2"."rating") NULLS FIRST