Question

Get the number of male and female premium users in the platform.

Expected Output Format

gendertotal_usersF...M

Answer 1

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;