具体sql如下:
select a1.cust_id,
a1.house_id,
a1.cell_id,
f1.cell_hot_flag,
a1.city_id,
f1.fdd_city_name,
case when a1.work_order_source_id in (1, 2) then '1'
when a1.work_order_source_id = 3 then '2'
when a1.work_order_source_id = 4 then '3'
else a1.work_order_source_id end as data_source_code,
case when a1.work_order_source_id in (1, 2) then 'APP'
when a1.work_order_source_id = 3 then 'WEB'
when a1.work_order_source_id = 4 then 'M站'
else 'other' end as data_source_name,
case when a1.work_order_source_id in (1, 2) then '?'
when a1.work_order_source_id not in (3, 4) then a1.work_order_source_id
when a1.work_order_source_id = '4'
and d1.utm_source2_text in ('?','am1','am2','wechat','wechat_welcome','suzhou1','hangzhou01','hangzhou02')
then
case when d1.user_agent_text like '%MicroMessenger%' then '微信'
else '自然' end
when a1.work_order_source_id = '4'
then
case when e1.utm_type = 'brand' then '固定'
else '可调' end
when a1.work_order_source_id = '3'
and d1.utm_source2_text in ('?',&#