方法1：

Select sum(invest_amount) 投资金额

from cmn_investment_request a

left join dim_agent b

on a.User_id=b.User_id and created_at between start_date and end_date

where Agent_id="10002";

方法2：

-- 每笔订单所归属的业务员

Select *

from cmn_investment_request a

left join dim_agent b

on a.User_id=b.User_id and created_at between start_date and end_date;

-- 归属于10002业务员的订单

Select *

from cmn_investment_request a

left join dim_agent b

on a.User_id=b.User_id and created_at between start_date and end_date

where Agent_id="10002";

-- 归属于10002业务员的投资金额

Select sum(invest_amount) 投资金额

from cmn_investment_request a

left join dim_agent b

on a.User_id=b.User_id and created_at between start_date and end_date

where Agent_id="10002";