Get the number of male and female premium users in the platform.
gendertotal_usersF...M
select count(case when user_category='M' then 1 end) as male_cnt,
count(case when user_category='F' then 0 end) as female_cnt
from quiz.user_details
where Is_premium =1;
Comments
Leave a comment