What are the duration's of the longest and shortest track in milliseconds.
select max ( milliseconds ), min ( milliseconds ) from track
What is the name of the longest track?
select name from track where milliseconds = ( select max ( milliseconds ) from track )
Who was the longest track written by?
select composer from track where milliseconds = ( select max ( milliseconds ) from track )