What is the shortest and most poorly rated song for each genre, ordered alphabetically by genre?
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