select '1' as type ,sum(firm_order_num) as firm_order_num ,sum(order_total_amount) as order_total_amount from daily_order_report_income as a where order_date='2020-02-24' and ad_code='110100'
union all
select '2' as type ,sum(firm_order_num) as firm_order_num ,sum(order_total_amount) as order_total_amount from daily_order_report_income as a where order_date='2020-02-25' and ad_code='110100'
select
MAX(CASE type WHEN '1' THEN a.firm_order_num ELSE 0 END) AS last_firm_order_num,
MAX(CASE type WHEN '2' THEN a.firm_order_num ELSE 0 END) AS ben_firm_order_num,
MAX(CASE type WHEN '1' THEN a.order_total_amount ELSE 0 END) AS last_order_total_amount,
MAX(CASE type WHEN '2' THEN a.order_total_amount ELSE 0 END) AS ben_order_total_amount
from (
select '1' as type ,sum(firm_order_num) as firm_order_num ,sum(order_total_amount) as order_total_amount from daily_order_report_income as a where order_date='2020-02-24' and ad_code='110100'
union all
select '2' as type ,sum(firm_order_num) as firm_order_num ,sum(order_total_amount) as order_total_amount from daily_order_report_income as a where order_date='2020-02-25' and ad_code='110100'
)as a