List all the durations of the songs.
select duration from files
How many are there when the duration is only 4 mins?
select count(*) from files where duration like "4:%"
What about that of 3 mins?
select count(*) from files where duration like "3:%"
How about the maximum and minimum resolutions of these songs?
select max(t2.resolution), min(t2.resolution) from files as t1 join song as t2 on t1.f_id = t2.f_id where t1.duration like "3:%"