Answer to Question #172101 in Databases | SQL | Oracle | MS Access for Krishna

Question #172101

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

Expected Output Format

gendertotal_usersF...M


1
Expert's answer
2021-03-16T07:49:25-0400
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;

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS