What is the longest duration?
select duration from files order by duration desc limit 1
What is the shortest duration?
select duration from files order by duration limit 1
How many songs have a short duration less than 4 minutes?
select count ( * ) from files where duration < 4