How long is the longest pop track?
select max(milliseconds) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Pop"
How about the shortest one?
select min(milliseconds) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Pop"
Show me durations for both of those pop tracks.
select max(milliseconds), min(milliseconds) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Pop"