회원분포현황 - 성별

select sex, sum(cnt) as visitCnt, count(sex) as sexCnt from
(
select sex as sex, sum(visit_count_day) as cnt from member as mb
inner join member_visit as mv
on mb.sn = mv.fk_member
group by sn, sex
) jj
group by sex