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
shortest duration refers to MIN(duration); lowest rating refers to MIN(rating); grouped by genre refers to GROUP BY genre; ordered by genre refers to ORDER BY genre;