What is the least common media type in all tracks
select t1.name from mediatype as t1 join track as t2 on t1.mediatypeid = t2.mediatypeid group by t2.mediatypeid order by count ( * ) asc limit 1
How many different kinds of media types are there?
select count ( * ) from ( select t2.mediatypeid from mediatype as t1 join track as t2 on t1.mediatypeid = t2.mediatypeid group by t2.mediatypeid )
What is the most common media type?
select t1.name from mediatype as t1 join track as t2 on t1.mediatypeid = t2.mediatypeid group by t2.mediatypeid order by count ( * ) desc limit 1
How many tracks are there?
select count ( * ) from track