/*SELECT member.recommend_member, dis_id, sum(member_money_charge_history.money), count(member_money_charge_history.money) FROM member_money_charge_history
join member on member_money_charge_history.member_idx = member.idx
where member_money_charge_history.status = 3 and create_dt >= '2024-02-01 00:00:00' and create_dt <= '2024-02-15 00:00:00'
group by dis_id order by recommend_member asc;*/

/*SELECT member.recommend_member, dis_id, sum(member_money_exchange_history.money), count(member_money_exchange_history.money) FROM member_money_exchange_history
join member on member_money_exchange_history.member_idx = member.idx
where member_money_exchange_history.status = 3 and create_dt >= '2024-02-01 00:00:00' and create_dt <= '2024-02-15 00:00:00'
group by dis_id order by recommend_member asc;*/