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
WHICH ARTISTS SUNG THE SONGS?
select artist_name from song
how many songs has Enrique produced?
select count ( * ) from song where artist_name = "Enrique"