Database: music_1
Question: What are the maximum duration and resolution of songs grouped and ordered by languages?
SQL:
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