Show me all artists with first name "Marianne"
select * from band where firstname = "Marianne"
How many songs have they produced in total?
select count(*) from performance as t1 join band as t2 on t1.bandmate = t2.id join songs as t3 on t3.songid = t1.songid where t2.firstname = "Marianne"
Show me the names of those songs.
select t3.title from performance as t1 join band as t2 on t1.bandmate = t2.id join songs as t3 on t3.songid = t1.songid where t2.firstname = "Marianne"