Database: music_1
Question: What is the shortest and most poorly rated song for each genre, ordered alphabetically 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