SELECT count(*) ,  gender FROM artist GROUP BY gender
What is the number of artists for each gender?
SELECT count ( * ) , gender FROM artist GROUP BY gender
select count ( * ) , gender from artist group by gender
What is the number of artists for each gender ?