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)
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)

What are the maximum duration and resolution of songs grouped and ordered by languages?
SELECT MAX(T1.duration), MAX(T2.resolution), T2.languages FROM files AS T1 JOIN song AS T2 ON T1.f_id = T2.f_id GROUP BY T2.languages ORDER BY T2.languages
SELECT MAX("T1"."duration"), MAX("T2"."resolution"), "T2"."languages" FROM "files" AS "T1" JOIN "song" AS "T2" ON "T1"."f_id" = "T2"."f_id" GROUP BY "T2"."languages" ORDER BY "T2"."languages" NULLS FIRST