Task: Text to Code
Input (English): SQL: SELECT Avg ( * ) FROM artist WHERE gender = "Female"
Feedback: Here it should find average rows in song table whose corresponding artist's song id equals female .
Output (English): SELECT avg(T2.rating) FROM artist AS T1 JOIN song AS T2 ON T1.artist_name  =  T2.artist_name WHERE T1.gender  =  "Female"