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