What is the lowest duration of songs that have mp3 format and resolution below 800?
select min ( t1.duration ) from files as t1 join song as t2 on t1.f_id = t2.f_id where t1.formats = "mp3" and t2.resolution < 800
What is the highest duration of songs that have mp3 format and resolution below 800?
select max ( t1.duration ) from files as t1 join song as t2 on t1.f_id = t2.f_id where t1.formats = "mp3" and t2.resolution < 800
What is the average duration of songs that have mp3 format and resolution below 800?
select avg ( t1.duration ) from files as t1 join song as t2 on t1.f_id = t2.f_id where t1.formats = "mp3" and t2.resolution < 800