How many songs are there?
select count(distinct title) from songs
Show me the ones with a lead vocal.
select distinct title from vocals as t1 join songs as t2 on t1.songid = t2.songid where type = "lead"
How many are there?
select count(distinct title) from vocals as t1 join songs as t2 on t1.songid = t2.songid where type = "lead"