Hi, could you please let me know the genre ID for Latin and Pop?
select genreid from genre where name = "Latin" or name = "Pop"
That was very quick, thank you very much :) Then, could you please let me know the average duration (milliseconds) of Latin and Pop?
select avg ( milliseconds ) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Latin" or t1.name = "Pop"
That's an amazingly precise number, thank you again. Then what about the average unit price of Latin and Pop?
select avg ( unitprice ) from genre as t1 join track as t2 on t1.genreid = t2.genreid where t1.name = "Latin" or t1.name = "Pop"