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

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