Order the songs by their file size, from large to small.
select * from files order by file_size desc
What about ordering by duration?
select * from files order by duration desc
From those results, which one is the top 1, only keep the id of it.
select f_id from files order by duration desc limit 1