How many songs, on average, are sung by a female artist?
select avg(t2.rating) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.gender = "Female"