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
What are the shortest duration and lowest rating of songs grouped by genre and ordered 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
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
What are the shortest duration and lowest rating of songs grouped by genre and ordered by genre ?