How many genres are there in total?
select count(distinct genre_is) from song
How many songs for each of them, show the result in the order of genre?
select genre_is,count(*) from song group by genre_is
What are the shortest duration and lowest rating for each group?
select min(t1.duration), min(t2.rating), t2.genre_is from files as t1 join song as t2 on t1.f_id = t2.f_id group by t2.genre_is order by t2.genre_is