Table schema:
CREATE TABLE artist (gender VARCHAR)

Question: What is the number of artists for each gender?
SQL: SELECT COUNT(*), gender FROM artist GROUP BY gender