yes
select t1.title from album as t1 join track as t2 on t1.albumid = t2.albumid join genre as t3 on t2.genreid = t3.genreid where t3.name = 'Reggae' intersect select t1.title from album as t1 join track as t2 on t1.albumid = t2.albumid join genre as t3 on t2.genreid = t3.genreid where t3.name = 'Rock'
List album titles for albums containing Rock genre tracks
select t1.title from album as t1 join track as t2 on t1.albumid = t2.albumid join genre as t3 on t2.genreid = t3.genreid where t3.name = 'Reggae' intersect select t1.title from album as t1 join track as t2 on t1.albumid = t2.albumid join genre as t3 on t2.genreid = t3.genreid where t3.name = 'Rock'
List album titles for albums containing Metal genre tracks
select distinct t1.title from album as t1 join track as t2 on t1.albumid = t2.albumid join genre as t3 on t2.genreid = t3.genreid where t3.name = 'Metal'
How many albums contain 'Metal' genre tracks?
select count ( distinct t1.title ) from album as t1 join track as t2 on t1.albumid = t2.albumid join genre as t3 on t2.genreid = t3.genreid where t3.name = 'Metal'