How many artists are male and how many are female?
SELECT count(*) ,  gender FROM artist GROUP BY gender
SELECT count(*) ,  gender FROM artist GROUP BY gender
[{'count(*)': 3, 'gender': 'Female'}, {'count(*)': 3, 'gender': 'Male'}]