What is the average rating of songs produced by female artists?
select avg(t2.rating) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.gender = "Female"