what is the duration of the longest song grouped by genre?
select max ( t1.duration ), t2.genre_is from files as t1 join song as t2 on t1.f_id = t2.f_id group by t2.genre_is
How about the shortest?
select min ( t1.duration ), t2.genre_is from files as t1 join song as t2 on t1.f_id = t2.f_id group by t2.genre_is
Can you order them by genre?
select min ( t1.duration ), 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
Yes please
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