id_, main_id_, fill_date_, reference_, enterprise_code_, enterprise_name_, enterprise_name_en_, counterparty_, currency_, initial_value_, qutstanding_, start_date_, deal_type_, interest_rate_, last_time_ SELECT m.fill_year_ as year, SUM(d.initial_value_) AS financingMoney, sum(d.qutstanding_) AS qutstanding_, count(*) as financingCount FROM qf_finance_lease_d d LEFT JOIN qf_finance_lease_m m ON m.id_ = d.main_id_ and m.fill_year_ >= #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ AND d.enterprise_code_ = #{vo.enterpriseCode} GROUP BY m.fill_year_ SELECT m.fill_quarter_ as quarter, SUM(d.initial_value_) AS financingMoney, sum(d.qutstanding_) AS qutstanding_, count(*) as financingCount FROM qf_finance_lease_d d LEFT JOIN qf_finance_lease_m m ON m.id_ = d.main_id_ and m.fill_year_ = #{vo.year} and m.fill_quarter_ >= #{vo.startQuarter} AND #{vo.endYear} >= m.fill_quarter_ AND d.enterprise_code_ = #{vo.enterpriseCode} GROUP BY m.fill_quarter_