id_, main_id_, fill_date_, enterprise_code_, customer_, customer_development_center_, model_code_, model_name_, nomination_date_, sop_, estimated_volume_, revenue_, revenue_lifetime_, ebitda_rate_, last_time_ SELECT m.fill_year_ as year,sum(d.revenue_) as actual FROM qf_operation_new_orders_d d LEFT JOIN qf_operation_new_orders_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_ AS year, max(m.fill_month_) AS month FROM qf_operation_new_orders_d d LEFT JOIN qf_operation_new_orders_m m ON m.id_ = d.main_id_ GROUP BY m.fill_year_ ) q on q.year = m.fill_year_ and q.month = m.fill_month_ and m.fill_year_ >= #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ AND #{vo.year} = m.fill_year_ AND d.enterprise_code_ = #{vo.enterpriseCode} AND d.customer_en_ = #{vo.customer} GROUP BY m.fill_year_ ORDER BY m.fill_year_ SELECT m.fill_year_ as year,sum(d.revenue_lifetime_) as actual FROM qf_operation_new_orders_d d LEFT JOIN qf_operation_new_orders_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_ AS year, max(m.fill_month_) AS month FROM qf_operation_new_orders_d d LEFT JOIN qf_operation_new_orders_m m ON m.id_ = d.main_id_ GROUP BY m.fill_year_ ) q on q.year = m.fill_year_ and q.month = m.fill_month_ and m.fill_year_ >= #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ AND #{vo.year} = m.fill_year_ AND d.enterprise_code_ = #{vo.enterpriseCode} AND d.customer_en_ = #{vo.customer} GROUP BY m.fill_year_ ORDER BY m.fill_year_ SELECT m.fill_year_ as year,sum(d.revenue_lifetime_) as actual FROM qf_operation_new_orders_d d LEFT JOIN qf_operation_new_orders_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_ AS year, max(m.fill_month_) AS month FROM qf_operation_new_orders_d d LEFT JOIN qf_operation_new_orders_m m ON m.id_ = d.main_id_ GROUP BY m.fill_year_ ) q on q.year = m.fill_year_ and q.month = m.fill_month_ left join qf_enterprise_info e on e.code_ = d.enterprise_code_ and m.fill_year_ >= #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ AND #{vo.year} = m.fill_year_ AND d.enterprise_code_ = #{vo.enterpriseCode} AND e.continent_ = #{vo.analyseType} GROUP BY m.fill_year_ ORDER BY m.fill_year_ SELECT m.fill_year_ as year,sum(d.revenue_) as actual FROM qf_operation_new_orders_d d LEFT JOIN qf_operation_new_orders_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_ AS year, max(m.fill_month_) AS month FROM qf_operation_new_orders_d d LEFT JOIN qf_operation_new_orders_m m ON m.id_ = d.main_id_ GROUP BY m.fill_year_ ) q on q.year = m.fill_year_ and q.month = m.fill_month_ left join qf_enterprise_info e on e.code_ = d.enterprise_code_ and m.fill_year_ >= #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ AND #{vo.year} = m.fill_year_ AND d.enterprise_code_ = #{vo.enterpriseCode} AND e.continent_ = #{vo.analyseType} GROUP BY m.fill_year_ ORDER BY m.fill_year_ SELECT m.fill_year_ as year,avg(d.ebitda_rate_) as actual FROM qf_operation_new_orders_d d LEFT JOIN qf_operation_new_orders_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_ AS year, max(m.fill_month_) AS month FROM qf_operation_new_orders_d d LEFT JOIN qf_operation_new_orders_m m ON m.id_ = d.main_id_ GROUP BY m.fill_year_ ) q on q.year = m.fill_year_ and q.month = m.fill_month_ and d.ebitda_rate_ is not null and m.fill_year_ >= #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ AND #{vo.year} = m.fill_year_ AND d.enterprise_code_ = #{vo.enterpriseCode} AND d.customer_en_ = #{vo.customer} GROUP BY m.fill_year_ ORDER BY m.fill_year_