How many composers do you have recorded in the system ?
select count ( distinct composer ) from track
Have many MPEG media audio files are in the system ?
select count ( * ) from mediatype as t1 join track as t2 on t1.mediatypeid = t2.mediatypeid where t1.name = "MPEG audio file"
What is the highest recorded millisecond for a single track ?
select max ( milliseconds ) from track
What is the title name for the highest recorded single track ?
select name from track order by milliseconds desc limit 1
What is the Album Id for Occupation / Precipice ?
select albumid from track where name = "Occupation / Precipice"