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

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" AS "T1" JOIN "song" AS "T2" ON "T1"."f_id" = "T2"."f_id" GROUP BY "T2"."genre_is" ORDER BY "T2"."genre_is" NULLS FIRST