How many songs are produced by female artists?
select count(*) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.gender = "Female"
What is the maximum rating of these songs?
select max(t2.rating) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.gender = "Female"
How about average rating?
select avg(t2.rating) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.gender = "Female"