Answer to Question #284137 in Databases | SQL | Oracle | MS Access for Lovely

Question

Get the total number of countries where the users of the platform are present.

Expected Output Format

country count

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;