CREATE TABLE files (duration INT, f_id VARCHAR)
CREATE TABLE song (languages VARCHAR, resolution INT, f_id VARCHAR)

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