CREATE TABLE artist (artist_name CLOB, country CLOB, gender CLOB, preferred_genre CLOB)
CREATE TABLE files (f_id NUMBER, artist_name CLOB, file_size CLOB, duration CLOB, formats CLOB)
CREATE TABLE genre (g_name CLOB, rating CLOB, most_popular_in CLOB)
CREATE TABLE song (song_name CLOB, artist_name CLOB, country CLOB, f_id NUMBER, genre_is CLOB, rating NUMBER, languages CLOB, releasedate TIME, resolution NUMBER)

What are the shortest duration and lowest rating of songs grouped by genre and ordered by genre?
SELECT MIN(T1.duration), MIN(T2.rating), T2.genre_is FROM files AS T1 JOIN song AS T2 ON T1.f_id = T2.f_id GROUP BY T2.genre_is ORDER BY T2.genre_is
SELECT MIN("T1"."duration"), MIN("T2"."rating"), "T2"."genre_is" FROM "files" "T1" JOIN "song" "T2" ON "T1"."f_id" = "T2"."f_id" GROUP BY "T2"."genre_is" ORDER BY "T2"."genre_is"