select
case
when profile like '%,%,%,male'
then 'male'
when profile like '%,%,%,female'
then 'female'
end as gender,
count(*)
from user_submit
group by gender