What is the average duration of tracks that belong to Latin genre?
select avg(milliseconds) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Latin"
How about Pop?
select avg(milliseconds) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Pop"
Show me the average for both genres.
select avg(milliseconds) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Latin" or t1.name = "Pop"