with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%' then '拼多多'
when mch_nm like '%京东%' or mch_nm = '网银在线-平台商户'then '京东'
when mch_nmlike '%淘宝%' or mch_nm like '%天猫%' then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%' then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户','京东支付-北京京东世纪贸易有限公司')then '京东'
when mch_nmlike '%淘宝%' or mch_nm like '%天猫%' then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%' then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户','京东支付-北京京东世纪贸易有限公司')then '京东'
when mch_nmlike '%淘宝%' or mch_nm like '%天猫%' then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' or mch_nm like '%全球购%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%' then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户','京东支付-北京京东世纪贸易有限公司') or mch_nm like '%全球购%' then '京东'
when mch_nmlike '%淘宝%' or mch_nm like '%天猫%' then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%' or mch_nm like '%全球购%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户','京东支付-北京京东世纪贸易有限公司')then '京东'
when mch_nmlike '%淘宝%' or mch_nm like '%天猫%' then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户','京东支付-北京京东世纪贸易有限公司')then '京东'
when mch_nmlike '%淘宝%' or mch_nm like '%天猫%'or mch_nm like '%全球购%'then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户','京东支付-北京京东世纪贸易有限公司')then '京东'
when mch_nmlike '%淘宝%' or mch_nm like '%天猫%' then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户','京东支付-北京京东世纪贸易有限公司')then '京东'
when mch_nmlike '%淘宝%' or mch_nm like '%天猫%' or mch_nm like '%格物%' then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户','京东支付-北京京东世纪贸易有限公司')then '京东'
when mch_nmlike '%淘宝%' or mch_nm like '%天猫%'then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户','京东支付-北京京东世纪贸易有限公司')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司') then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司') then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司') then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司') then '淘系'
when mch_nm like '%小红书%' ormch_nm like '%行吟%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司') then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
where mch_nm not in ('支付宝-行吟信息科技有限公')
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司') then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' or mch_nm ='财付通-喜茶' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户','财付通-喜茶')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司') then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司','财付通-喜茶') then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司') then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
where mch_nm not in ('北京空间变换科','财付通-成都所见所得科')
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司') then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
where mch_nm not in ('北京空间变换科')
order by mch_nm
with main as (
select distinct mch_nm from ccb_trx_rcd
)
select mch_nm as merchant_name,
case when mch_nm like '%拼多多%' or mch_nm like '%寻梦信息%'then '拼多多'
when mch_nm in ('微信-京东平台商户','支付宝-京东','网银在线-平台商户')then '京东'
when mch_nmin ('支付宝-天猫','支付宝-淘宝','财付通-格物致品网络科技有限公司') then '淘系'
when mch_nm like '%小红书%'then '小红书'
when mch_nm like '%抖音%' or mch_nm like '%北京空间变换科%' or mch_nm like '%所见所得科技%'or mch_nm like '%合众%' then '抖音'
else '其他'
end as platform from main
where mch_nm not in ('北京空间变换科','支付宝-行吟信息科技有限公')
order by mch_nm