Which song ids are the top three long ones?
select f_id from files order by duration desc limit 3
What about the shortest one?
select f_id from files order by duration asc limit 1
What is the artist name of it?
select t1.artist_name from song as t1 join files as t2 on t1.f_id = t2.f_id order by t2.duration limit 1