Database: music_1
Question: How many artists are male and how many are female?
SQL:
SELECT count(*) ,  gender FROM artist GROUP BY gender