SELECT SUBSTRING(profile FROM 15 FOR 6) AS gender,
COUNT(blog_url) AS number
FROM user_submit
GROUP BY gender;