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

Show the shortest duration and lowest rating of songs grouped by genre using a bar chart, and display y axis in desc order.
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) DESC
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("T2"."rating") DESC