# 知识点：模糊查询
*一般我们能想到的是字符串截取函数substring_index(),而模糊查询不失为另一种解题思路；
SELECT 
IF(profile LIKE '%female','female','male') as gender,
COUNT(1) as number
FROM user_submit
GROUP BY IF(profile LIKE '%female','female','male');