Show me the 10 most common genres in all tracks.
select t1.name from genre as t1 join track as t2 on t1.genreid = t2.genreid group by t2.genreid order by count(*) desc limit 10
Show me the 10 least common genres.
select t1.name from genre as t1 join track as t2 on t1.genreid = t2.genreid group by t2.genreid order by count(*) asc limit 10
Show me the most common one.
select t1.name from genre as t1 join track as t2 on t1.genreid = t2.genreid group by t2.genreid order by count(*) desc limit 1