tree queries 2

tree

/*
SELECT date(activated_at) as activated_at,
                    leader_member_id,
                    count(if(leg_side = 'left',1,null)) as left_count,
                    count(if(leg_side = 'right',1,null)) as right_count
            FROM `binary_active_team_members`
            WHERE earning_id is NULL

            GROUP BY date(activated_at),
                     leader_member_id
ORDER BY `binary_active_team_members`.`leader_member_id` ASC, `activated_at`  ASC


///////////////////
select leader_member_id , max(activated_at), sum(left_count) , sum(right_count)
from (SELECT date(activated_at) as activated_at,
                    leader_member_id,
                    count(if(leg_side = 'left',1,null)) as left_count,
                    count(if(leg_side = 'right',1,null)) as right_count
            FROM `binary_active_team_members`
            WHERE earning_id is NULL

            GROUP BY date(activated_at),
                     leader_member_id ) as s
GROUP BY leader_member_id

//////////////////////

SELECT date(activated_at) as activated_at,
                    leader_member_id,
                    count(if(leg_side = 'left',1,null)) as left_count,
                    count(if(leg_side = 'right',1,null)) as right_count
            FROM `binary_active_team_members`
            WHERE earning_id is NULL

            GROUP BY date(activated_at),
                     leader_member_id
ORDER BY leader_member_id ASC, activated_at  ASC

////////////////////
select leader_member_id ,  sum(left_count) , sum(right_count)
from (SELECT date(activated_at) as activated_at,
                    leader_member_id,
                    count(if(leg_side = 'left',1,null)) as left_count,
                    count(if(leg_side = 'right',1,null)) as right_count
            FROM `binary_active_team_members`
            WHERE earning_id is NULL

            GROUP BY date(activated_at),
                     leader_member_id ) as s
                     where activated_at = '2019-09-19'
GROUP BY leader_member_id