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
* I have left the chat *
select file_size,formats from files as t1 join song as t2 on t1.f_id = t2.f_id group by t2.languages order by t2.languages
What are the maximum duration and resolution of songs grouped and ordered by country?
select max ( t1.duration ), max ( t2.resolution ) from files as t1 join song as t2 on t1.f_id = t2.f_id group by t2.country order by t2.country
What are the the file size and fomats of songs grouped and ordered by country for each file?
select file_size,formats from files as t1 join song as t2 on t1.f_id = t2.f_id group by t2.country order by t2.country